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),
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