On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 31

Q1 | The backup is taken by
  • erasing all previous records
  • entering the new records
  • sending all log records from primary site to the remote backup site
  • sending selected records from primary site to the remote backup site
Q2 | When the                      the backup site takes over processing and becomes the primary.
  • secondary fails
  • backup recovers
  • primary fails
  • none of the mentioned
Q3 | The simplest way of transferring control is for the old primary to receive                       from the old backup site.
  • undo logs
  • redo logs
  • primary logs
  • all of the mentioned
Q4 | The time to process the remote backup can be reduced by
  • flags
  • breakpoints
  • redo points
  • checkpoints
Q5 | A                                configuration can make takeover by the backup site almost instantaneous.
  • hot-spare
  • remote
  • direct
  • spare
Q6 | A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
  • one safe
  • two safe
  • two-very safe
  • very safe
Q7 | A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
  • one safe
  • two safe
  • two-very safe
  • very safe
Q8 | If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
  • one safe
  • two safe
  • two-very safe
  • very safe
Q9 | A Database Management System (DBMS) is
  • Collection of interrelated data
  • Collection of programs to access data
  • Collection of data describing one particular enterprise
  • All of the above
Q10 | Which of the following is not a Schema?
  • Database Schema
  • Physical Schema
  • Critical Schema
  • Logical Schema
Q11 | The number of entities associated in relationship is called as it’s.....................
  • Cardinality
  • Degree
  • Tuples
  • Entity
Q12 | The DBMS utility...................... allows reconstructing the correct state of database from the backupand history of transactions.
  • Backup
  • Recovery
  • Monitoring
  • Data loading
Q13 | In the........... Normal form, a composite attribute is converted to individual attributes.
  • First
  • Second
  • Third
  • Fourth
Q14 | In RDBMS, Data is presented as a collection of............
  • Table
  • Attributes
  • Relations
  • Entities
Q15 | A .................. normal form, normalization will be needed where all attributes in a relation tuple arenot functionally dependent only on the key attribute.
  • First
  • Second
  • Third
  • Fourth
Q16 | To select all columns from the table the syntax is:
  • Select all from table_name
  • Select * from table_name
  • Select from table_name
  • Non of the above
Q17 | If an attribute of a composite key is dependent on an attribute of the other composite key,normalization called ................ is needed.
  • DKNF
  • BCNF
  • Fourth
  • Third
Q18 | Identify the criteria for designing database from the point of view of user
  • No redundancy
  • No inapplicable attributes
  • Uniformity in naming & definitions of the data items
  • All of the above
Q19 | The ............ operator preserves unmatched rows of the relations being joined.
  • Inner join
  • Outer join
  • Union
  • Union join
Q20 | Which are the not user in End-user:
  • Naïve users
  • Casual users
  • Sophisticated user
  • All of these
Q21 | DBMS is a collection of ………….. that enables user to create and maintain a database.
  • Keys
  • Translators
  • Programs
  • Language Activity
Q22 | In a relational schema, each tuple is divided into fields called
  • Relations
  • Domains
  • Queries
  • All of the above
Q23 | In an ER model, ……………. is described in the database by storing its data.
  • Entity
  • Attribute
  • Relationship
  • Notation
Q24 | DFD stands for
  • Data Flow Document
  • Data File Diagram
  • Data Flow Diagram
  • Non of the above
Q25 | A top-to-bottom relationship among the items in a database is established by a
  • Hierarchical schema
  • Network schema
  • Relational Schema
  • All of the above