DBMS Multiple Choice Questions and Answers

11. The natural join is equal to :

1. Cartesian Product
2. Combination of Union and Cartesian product
3. Combination of selection and Cartesian product
4. Combination of projection and Cartesian product

12. Which of the following is a valid SQL type?

1. CHARACTER
2. NUMERIC
3. FLOAT
4. All of the above

13. Which of the following is another name for weak entity?

1. Child
2. Owner
3. Dominant
4. All of the above

14. The view of total database content is

1. Conceptual view.
2. Internal view.
3. External view.
4. Physical View.

15. Relational Algebra is

1. Data Definition Language .
2. Meta Language
3. Procedural query Language
4. None of the above

16. Related fields in a database are grouped to form a

1. data file.
2. data record.
3. menu.
4. bank.

17. An advantage of the database management approach is

1. data is dependent on programs.
2. data redundancy increases.
3. data is integrated and can be accessed by multiple programs.
4. none of the above.

18. Which of the following is an advantage of view?

1. Data security
2. Derived columns
3. Hiding of complex queries
4. All of the above

19. The conceptual model is

1. dependent on hardware.
2. dependent on software.
3. dependent on both hardware and software .
4. independent of both hardware and software.

20. DML is provided for

1. Description of logical structure of database.
2. Addition of new structures in the database system.
3. Manipulation & processing of database.
4. Definition of physical structure of database system.