MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In a _______ clustering index, the index record contains the search-key value and a |
| A. | Dense |
| B. | Sparse |
| C. | Straight |
| D. | Continuous |
| Answer» B. Sparse | |
| 2. |
Large collection of files are called |
| A. | sectors |
| B. | database |
| C. | fields |
| D. | records |
| Answer» C. fields | |
| 3. |
which of the following is not an Aggregate function? |
| A. | min |
| B. | max |
| C. | select |
| D. | avg |
| Answer» D. avg | |
| 4. |
Which of the following is not Unary operation? |
| A. | select |
| B. | project |
| C. | rename |
| D. | union |
| Answer» E. | |
| 5. |
Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively |
| A. | m = min(r,s) |
| B. | 0 <= m <= r + s |
| C. | min(r,s) <= m <= max(r,s) |
| D. | 0 <= m <= min(r,s) |
| Answer» E. | |
| 6. |
Consider a relation R(A,B,C,D,E) with the following functional dependencies: |
| A. | 2 |
| B. | 7 |
| C. | 10 |
| D. | 12 |
| Answer» D. 12 | |
| 7. |
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into |
| A. | Lossless decomposition |
| B. | Lossless-join decomposition |
| C. | All of the mentioned |
| D. | None of the mentioned |
| Answer» E. | |
| 8. |
There are two functional dependencies with the same set of attributes on the left side of the arrow: |
| A. | A->BC |
| B. | A->B |
| C. | B->C |
| D. | None of the mentioned |
| Answer» B. A->B | |
| 9. |
A _________ integrity constraint requires that the values appearing in specified attributes |
| A. | Referential |
| B. | Referencing |
| C. | Specific |
| D. | Primary |
| Answer» B. Referencing | |
| 10. |
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), |
| A. | The statement is syntactically wrong |
| B. | It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null. |
| C. | It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null. |
| D. | It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters. |
| Answer» D. It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters. | |