Database Management System - DBMS Quiz Question with Answer


21. …………… database is used as template for all databases

  1. Model
  2. Create
  3. Master
  4. Tempdb

22. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.

  1. Monitoring
  2. Backup
  3. Recovery
  4. Data loading

23. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.

  1. Monitoring
  2. Backup
  3. Recovery
  4. Data loading

24. An outstanding functionality of SQL is its support for automatic ………… to the target data.

  1. Navigation
  2. Programming
  3. Functioning
  4. Notification

25. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

  1. Non attributes entity
  2. Weak entity
  3. Strong entity
  4. Dependent entity

26. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:

  1. Non-schema
  2. Schema
  3. Subschema
  4. None-subschema

27. For some relations, changing the data can have undesirable consequences called:

  1. Normal forms.
  2. Referential integrity constraints.
  3. Modification anomalies.
  4. Transitive dependencies.

28. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

  1. Normalization
  2. Functional dependency
  3. Database modeling
  4. Decomposition

29. Which is the process of breaking a relation into multiple relations:

  1. Normalization
  2. Functional dependency
  3. Database modeling
  4. Decomposition

30. …………… is used to determine whether of a table contains duplicate rows.

  1. Null predicate
  2. Unique predicate
  3. Like Predicate
  4. In predicate

Tags :


Multiple Choice Questions and Answers on Database Management System - DBMS


Database Management System - DBMS Multiple Choice Questions and Answers


Database Management System - DBMS Trivia Quiz


Database Management System - DBMS Question and Answer PDF Online




Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....