Database Management System Set 31

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
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
Q2 | When the                      the backup site takes over processing and becomes the primary.
Q3 | The simplest way of transferring control is for the old primary to receive                       from the old backup site.
Q4 | The time to process the remote backup can be reduced by
Q5 | A                                configuration can make takeover by the backup site almost instantaneous.
Q6 | A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
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
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
Q9 | A Database Management System (DBMS) is
Q10 | Which of the following is not a Schema?
Q11 | The number of entities associated in relationship is called as it’s.....................
Q12 | The DBMS utility...................... allows reconstructing the correct state of database from the backupand history of transactions.
Q13 | In the........... Normal form, a composite attribute is converted to individual attributes.
Q14 | In RDBMS, Data is presented as a collection of............
Q15 | A .................. normal form, normalization will be needed where all attributes in a relation tuple arenot functionally dependent only on the key attribute.
Q16 | To select all columns from the table the syntax is:
Q17 | If an attribute of a composite key is dependent on an attribute of the other composite key,normalization called ................ is needed.
Q18 | Identify the criteria for designing database from the point of view of user
Q19 | The ............ operator preserves unmatched rows of the relations being joined.
Q20 | Which are the not user in End-user:
Q21 | DBMS is a collection of ………….. that enables user to create and maintain a database.
Q22 | In a relational schema, each tuple is divided into fields called
Q23 | In an ER model, ……………. is described in the database by storing its data.
Q24 | DFD stands for
Q25 | A top-to-bottom relationship among the items in a database is established by a
Previous Next