DBMS MCQ Questions and Answers Quiz

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.
Tags

MCQ Multiple Choice Questions and Answers on DBMS

DBMS Trivia Questions and Answers PDF

DBMS Question and Answer

Spreading Education Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....