DBMS Multiple Choice Questions with Answers Set-4

1. The __________ stores information about the data in the database.

2. In E-R diagram, the term cardinality is a synonym fo the term __________.

3. An oracle server index__________.

4. The __________ key in a relational database links one table to another.

5. A(n) __________ accesses the database and data dicitionary in a DBMS as they exist on a storage device

6. A hierarchical database organizes data in a (n) __________.

7. In SQL, which command is used to changes data in a data table?

8. In SQL, which of the following is not a data definition language command?

9. Which command(s) is (are) used to redefine a column of the table in SQL?

10. In a relational schema, each tuple is divided into fields called __________.

11. E R model is used in _________ phase.

12. The language used in the application programs to request data from the DBMS is referred to as the __________.

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

14. A __________ store(s) data in two dimensional tables.

15. A __________means that one record in a particular record type is related to only one record of another record type.

16. Bookmarks can be organized by using ___________.

17. In files, there is a key associated with each record which is used to differentiate among different records. For every file, there is at least one set of keys that is unique. Such a key is called__________.

18. A table in a relational database terminology is synonymous with _________.

19. Data mining evolve as a mechanism to cater for the limitations of __________ systems to deal with massive data sets with high dimensionality, new data type, multiple heterogeneous data resources etc.

20. Rows of a relation are called __________.