Database Management System Set 3
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 3
Q1 | How many types of keys in Database Design?
- foreign key
- all of the options
- candidate key
- primary key
Q2 | Which of the following is based on Multi Valued Dependency?
- third
- fourth
- first
- second
Q3 | Which of the following is the structure of the Database?
- table
- none of these
- schema
- relation
Q4 | The minimal set of super key is called
- primary key
- secondary key
- foreign key
- candidate key
Q5 | ______________ is a classical approach to database design?
- bottom – up approach
- top – down approach
- left – right approach
- right – left approach
Q6 | _____________ refers to the correctness and completeness of the data in a database?
- data independence
- data integrity
- data security
- data constraint
Q7 | A table that displays data redundancies yields ____________ anomalies
- insertion
- deletion
- update
- all of the options
Q8 | A lock that allows concurrent transactions to access different rows of the same table is known as a
- row-level lock
- database-level lock
- field-level lock
- table-level lock
Q9 | A type of query that is placed within a WHERE or HAVING clause of another query is called
- multi-query
- sub query
- super query
- master query
Q10 | A form defined
- none of the options
- where data is placed on the screen
- the width of each field
- both where data is placed on the screen and the width of each field
Q11 | If a piece of data is stored in two places in the database, then
- in can be more easily accessed
- both storage space is wasted and changing the data in one spot will cause data inconsistency
- storage space is wasted
- changing the data in one spot will cause data inconsistency
Q12 | Which of the following is a problem of file management system?
- data redundancy and program dependence
- all of the options
- difficult to update
- lack of data independence
Q13 | Which of the following is not an advantage of the database approach
- elimination of data redundancy
- ability of associate deleted data
- increased security and program/data independence
- all of the above
Q14 | An audit trail
- none of the options
- is the recorded history of operations performed on a file
- is used to make backup copies
- can be used to restore lost information
Q15 | One approach to standardization storing of data?
- codasyl specification
- none of the options
- mis
- structured programming
Q16 | Report generators are used to
- store data input by a user
- answer queries
- both retrieve information from files and answer queries
- retrieve information from files
Q17 | Which of the following is true of a network structure?
- it will be dominant data base of the future
- it allows a many-to-many relationship
- it is a physical representation of the data
- it is conceptually simple
Q18 | A record management system
- can handle many files of information at a time
- always uses a list as its model
- both can handle many files of information at a time and always uses a list as its model
- can be used to extract information stored in a computer file
Q19 | One data dictionery software package is called
- db/dc dictionary
- datapac
- total
- access
Q20 | The function of a database is ...
- to check all input data
- to output data
- to collect and organize input data
- to check all spelling
Q21 | A command that lets you change one or more fields in a record is
- none of the options
- modify
- insert
- lookup
Q22 | What is the language used by most of the DBMSs for helping their users to access data?
- high level language
- 4gl
- query language
- sql
Q23 | Information can be transferred between the DBMS and a
- spreadsheet program
- word processor program
- graphics program
- all of the options
Q24 | The relational database environment has all of the following components except
- users
- database
- query languages
- separate files
Q25 | The ascending order of a data hirerchy is:
- bit-byte-file-record-field-database
- bit-byte-field-record-file-database
- bit-byte-record-field-file-database
- byte-bit-field-record-file-database