Database Management System Test 1 Online MCQs

1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

2. If attributes A and B determine attribute C, then it is also true that:

3. The following are functions of a DBMS except __________

4. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled “Table Name,” “Number of Columns” and “Primary Key.” You are looking at ________

5. Which of the following is not a restriction for a table to be a relation?

6. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n).

7. Which of the following products was the first to implement true relational algebra in a PC DBMS?

8. A relation in this form is free of all modification anomalies:

9. In the relational model, relationships between relations or tables are created by using:

10. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

11. A key:

12. A relation is in this form if it is in BCNF and has no multivalued dependencies:

13. Which of the following refers to something that can be identified in the users’ work environment, something that the users want to track?

14. Which of the following is a group of one or more attributes that uniquely identifies a row?

15. The primary key is selected form the: