Advanced-rdbms-concepts Questions Set 7:
How many possible super keys are there for a table with n attributes?
Solution:
Where does the ON condition appear in a join expression?
Solution:
The database designer's dependency rules are referred to as ____.
Solution:
Which layer is present in both 1-tier and 2-tier architectures?
Solution:
Which of the following need not necessarily be saved on a context switch between processes?
Solution:
The database anomaly that occurs when there is a requirement to change multiple records of an entity, but not all records get updated, is called:
Solution:
4 independent messages have bandwidths of 100 Hz, 100 Hz, 200 Hz and 400 Hz. Each is sampled at the Nyquist rate, and the samples are time division multiplexed and transmitted at the combined sample rate.
Solution:
The original (main) database in the project was deleted and is in restricted mode, preventing access for anyone except one person. Who is responsible for this situation?
Solution:
What is an instance of a database?
Solution:
Observe the EMPLOYEE table given below.
| ID | NAME | AGE | SALARY |
|---|---|---|---|
| 1 | Ramesh | 32 | 20000 |
| 2 | Suresh | 26 | 30000 |
| 3 | Tarun | 35 | 46000 |
| 4 | Swapnil | 43 | 100500 |
For the SQL query below, what will be the output?
SELECT NAME FROM EMPLOYEE WHERE AGE>30 OR SALARY>25000
Solution:
Related Question Sets:
Related Topics:
Scroll to Top
