MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which_of_the_following_can_be_used_as_a_primary_key_entry_of_the_instructor_relation.$ |
| A. | DEPT_NAME |
| B. | NAME |
| C. | ID |
| D. | All of the mentioned |
| Answer» C. ID | |
| 2. |
Identify the error in the section relation |
| A. | No error |
| B. | Year numeric (4,0) |
| C. | Building varchar (15) |
| D. | Sec_id varchar (8) |
| Answer» D. Sec_id varchar (8) | |
| 3. |
In the above DDL command the foreign key entries are got by using the keyword |
| A. | References |
| B. | Key reference |
| C. | Relating |
| D. | None of the mentioned |
| Answer» C. Relating | |
| 4. |
In the course relation, the title field should throw an error in case of any missing title. The command to be added in title is |
| A. | Unique |
| B. | Not null |
| C. | 0 |
| D. | Null |
| Answer» B. Not null | |
| 5. |
The department relation has the an entry budget whose type has to be replaced by |
| A. | Varchar (20) |
| B. | Varchar2 (20) |
| C. | Numeric (12,2) |
| D. | Numeric |
| Answer» B. Varchar2 (20) | |
| 6. |
Which is the main relation which is used in the university database which is referenced by all other relation of the university? |
| A. | Teaches |
| B. | Course |
| C. | Department |
| D. | Section |
| Answer» C. Department | |