Database Management Quiz 3

1. The language used in application programs to request data from the DBMS is referred to as the ______?

Correct! Wrong!

2. In Oracle, who owns the data dictionary?

Correct! Wrong!

3. In SQL, which command is used to update existing row in a table?

Correct! Wrong!

4. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

Correct! Wrong!

5. A relation between two entities is treated as a single entity is called__________?

Correct! Wrong!

6. Data mining evolve as a mechanism to cater the limitations of _______ systems to deal massive data sets with high dimensionality.

Correct! Wrong!

7. In Relational table, the term “Attribute” is also used to represent _______?

Correct! Wrong!

8. Which of the following categories of the data integrity RDBMS will enforce specific business rules?

Correct! Wrong!

9. E-R Modeling technique is a _______?

Correct! Wrong!

10. The number of attributes in a relation is called its _____?

Correct! Wrong!

11. ________ allows a unique number to be generated when a new record is inserted into a table.

Correct! Wrong!

12. Which of the following constraint is used to limit the value range that can be placed in a column?

Correct! Wrong!

13. A Foreign key in one table points to a ________ key in another table.

Correct! Wrong!

14. Domain constraints, functional dependency and referential integrity are special forms of_________.

Correct! Wrong!

15. 4NF stands for ______?

Correct! Wrong!

16. Which of the following field type is used to store photograph of employees?

Correct! Wrong!

17. _______ statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.

Correct! Wrong!

18. Which of the following method can be used to add more tables in a database?

Correct! Wrong!

19. Which of the following field type is the best to store serial numbers?

Correct! Wrong!

20. The feature that database allows to access only certain records in database is______?

Correct! Wrong!

Database Management Quiz Set 3
Results
Below 12 is not good, 13-16 need some improvement, 16+ excellent

Leave a Reply

error: Content is protected !!
%d bloggers like this: