Database Management System Set 1
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 1
Q1 | Where is metadata stored in MySQL?
- in the mysql database meta
- in the mysql database metasql
- in the mysql database metadata
- in the mysql database mysql
Q2 | What MySQL property is used to create a surrogate key in MySQL?
- identical
- unique
- auto_increment
- sequence
Q3 | A relational database consists of a collection of
- keys
- records
- tables
- fields
Q4 | A Database Management System (DBMS) is:
- collection of data describing one particular enterprise
- collection of programs to access data
- all options are correct
- collection of interrelated data
Q5 | Which of the following is not a level of data abstraction?
- view level
- physical level
- logical level
- critical level
Q6 | Disadvantages of File systems to store data is:
- data isolation
- data redundancy and inconsistency
- difficulty in accessing data
- all options are correct
Q7 | In an Entity Relationship Diagram Rectangles represents
- tables
- attributes
- database
- entity sets
Q8 | Which of the following is not a Storage Manager Component?
- transaction manager
- logical manager
- file manager
- buffer manager
Q9 | Data Manipulation Language enables users to
- retrieval of information stored in database
- insertion of new information into the database
- deletion of information from the database
- all the options are correct
Q10 | Which of the following is not an Schema?
- logical schema
- physical schema
- database schema
- critical schema
Q11 | Which of the following is Database Language?
- data definition language
- data manipulation language
- data query language
- all of the options
Q12 | Which of the following in not a function of DBA?
- network maintenance
- schema definition
- authorization for data access
- routine maintenance
Q13 | Which of the following is a Data Model?
- entity relationship model
- object based data model
- all of the options are correct
- relational data model
Q14 | A Database Management System (DBMS) is
- collection of interrelated data
- collection of data describing one particular enterprise
- all of the options
- collection of programs to access data
Q15 | Which of the following is not a level of data abstraction?
- physical level
- view level
- critical level
- logical level
Q16 | Disadvantages of File systems to store data is:
- data redundancy and inconsistency
- data isolation
- all of the options
- difficulty in accessing data
Q17 | Which of the following is not a Storage Manager Component?
- transaction manager
- buffer manager
- file manager
- logical manager
Q18 | Data Manipulation Language enables users to
- retrieval of information stored in database
- deletion of information from the database
- all of the above
- insertion of new information into the database
Q19 | Which of the following is not an Schema?
- logical schema
- critical schema
- database schema
- physical schema
Q20 | Which of the following is Database Language?
- all of the options
- query language
- data definition language
- data manipulation language
Q21 | Which of the following in not a function of DBA?
- authorization for data access
- network maintenance
- routine maintenance
- schema definition
Q22 | Which of the following is a Data Model?
- object-based data model
- all of the options
- entity-relationship model
- relational data model
Q23 | Column header is refer as
- table
- domain
- attributes
- relation
Q24 | _______ allow us to identify uniquely a tuple in the relation.
- schema
- superkey
- domain
- attribute
Q25 | Minimal Superkeys are called
- schema keys
- attribute keys
- candidate keys
- domain keys