Olete.in – MCQs, Mock Tests & Government Job Prep | Data Base Management System (DBMS) DBMS Multiple Choice Questions and Answers

——- responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use and monitoring efficiency of operations.

1. Storage Manager
2. File Manager
3. Transaction Manager
4. Buffer Manager

✅ Correct Answer: 4

——- is a property that describes various characteristics of an entity

1. ER Diagram
2. Column
3. Relationship
4. Attribute

✅ Correct Answer: 4

——– level describes what data is stored in the database and the relationships among the data

1. Physical Level
2. Logical Level
3. Conceptual Level
4. None of the above

✅ Correct Answer: 2

——- denote derived attributes.

1. Double ellipse
2. Dashed ellipse
3. Squared ellipse
4. Ellipse with attribute name underlined

✅ Correct Answer: 2

A ——— is an association between entities

1. Relation
2. One to One
3. Generalization
4. Specialization

✅ Correct Answer: 1

—- stores metadata about the structure of the database

1. Physical database
2. Query Analyzer
3. Data Dictionary
4. Data Catalog

✅ Correct Answer: 3

——is a collection of operations that perform s single logical function in a database application

1. Transaction
2. Concurrent operation
3. Atomicity
4. Durability

✅ Correct Answer: 1

The problem that is compounded when constraints involve several data items from different files are Called ——–

1. Transaction Control Management Problem
2. Security Problem
3. Integrity Problem
4. Durability Problem

✅ Correct Answer: 3

Ensuring atomicity is the responsibility of the ————component

1. File Manager
2. Buffer Manager
3. DGA
4. Transaction Manager

✅ Correct Answer: 4

—–manages the allocation of the space on the disk storage and the database structure used to represent information stored on disk

1. Disk Manager
2. File Manager
3. Memory Manager
4. None of the above

✅ Correct Answer: 2

is the minimal super key .

1. Primary Key
2. Candidate Key
3. Unique Key
4. Alternate Key

✅ Correct Answer: 2

-engine executes low-level instructions generated by the DML compiler

1. DDL Analyzer
2. Query Interpreter
3. Database Engine
4. None of the above

✅ Correct Answer: 4

————responsible to define the content, the structure, the constraints, and functions or transactions against the database

1. Transaction Manager
2. Query Analyzer
3. DBA
4. None of the above

✅ Correct Answer: 3

In the ER model ————-denote derived attributes

1. Double ellipse
2. Diamond
3. Rectangle
4. None of the above

✅ Correct Answer: 4

The ascending order of a data hierarchy is:

1. bit-byte-record-field-file-database
2. byte-bit-field-record-file-database
3. bit-byte-field-record-file-database
4. bit-byte-file-record-field-database

✅ Correct Answer: 3

Which of the following is true of a network structure?

1. it is a physical representation of the data
2. It allows a many-to-many relationship
3. It is conceptually simple
4. It will be the dominant database of the future

✅ Correct Answer: 2

Which of the following is true of a network structure?

1. it is a physical representation of the data
2. It allows a many-to-many relationship
3. It is conceptually simple
4. It will be the dominant database of the future

✅ Correct Answer: 2

Which of the following is a problem of the file management system?

1. difficult to update
2. data redundancy
3. program dependence
4. All of the above

✅ Correct Answer: 4

One data dictionary software package is called

1. DB/DC dictionary
2. TOTAL
3. Datapac
4. Data Manager

✅ Correct Answer: 1

The function of a database is …

1. to check all input data
2. to check all spelling
3. to collect and organize input data
4. to output data

✅ Correct Answer: 3

What is the language used by most of the DBMSs for helping their users to access data?

1. High-level language
2. SQL
3. Query Language
4. 4GL

✅ Correct Answer: 3

The model for a record management system might be

1. handwritten list
2. a Rolodex card file
3. a business form
4. All of the above

✅ Correct Answer: 4

Primitive operations common to all record management system include

1. print
2. sort
3. Look-up
4. All of the above

✅ Correct Answer: 3

In a large DBMS

1. each user can “see” only a small part of the entire database
2. each user can access every subschema
3. each subschema contains every field in the logical schema
4. None of these

✅ Correct Answer: 1

Information can be transferred between the DBMS and a

1. spreadsheet program
2. word processor program
3. graphics program
4. All of the above

✅ Correct Answer: 4

Which of the following fields in a student file can be used as a primary key?

1. class
2. Social Security Number
3. GPA
4. Major

✅ Correct Answer: 2

Which of the following is not an advantage of the database approach

1. Ability of associate deleted data
2. increased security
3. program/data independence
4. all of the above

✅ Correct Answer: 4

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

1. report writer
2. query language
3. data manipulation language
4. transaction log

✅ Correct Answer: 4

In the DBMS approach, application programs perform the

1. access control
2. processing functions
3. all of the above
4. None of the above

✅ Correct Answer: 2

et of programs that handle a firm’s database responsibilities is called

1. database management system (DBMS)
2. database processing system (DBPS)
3. data management system (DMS)
4. All of the above

✅ Correct Answer: 4

Which is the make given to the database management system which is able to handle full text data, image data, audio and video?

1. full media
2. graphics media
3. multimedia
4. hypertext

✅ Correct Answer: 3

A record management system

1. can handle many files of information at a time
2. can be used to extract information stored in a computer file
3. always uses a list as its model
4. both a and b

✅ Correct Answer: 2

A transparent DBMS

1. can not hide sensitive information from users
2. keeps its logical structure hidden from users
3. keeps its physical structure hidden from users
4. both b and c

✅ Correct Answer: 3

A file produced by a spreadsheet

1. is generally stored on disk in an ASCII text fromat
2. can be used as is by the DBMS
3. both a and b
4. None of the above

✅ Correct Answer: 1

An audit trail

1. is used to make backup copies
2. is the recorded history of operations performed on a file
3. can be used to restore lost information
4. None of the above

✅ Correct Answer: 2

If a piece of data is stored in two places in the database, then

1. storage space is wasted
2. changing the data in one spot will cause data inconsistency
3. in can be more easily accessed
4. both and b

✅ Correct Answer: 4

Sort/Report generators

1. are faster than index/report generators
2. require more disk space than indexed/report generators
3. do not need to sort before generating report
4. both a and b

✅ Correct Answer: 2

In order to use a record management system

1. you need to understand the low level details of how information is stored
2. you need to understand the model the record management system uses
3. bother a and b
4. None of the above

✅ Correct Answer: 2

Which of the following is not a relational database?

1. dBase IV
2. 4th Dimension
3. FoxPro
4. Reflex

✅ Correct Answer: 4

Large collection of files are called

1. fields
2. records
3. database
4. sectors

✅ Correct Answer: 3

Batch processing is appropriate if

1. only a small computer system is avilbale
2. only a few transactions are involved
3. all of the above
4. None of the above

✅ Correct Answer: 4

Which of the following hardware component is the most important to the operation of database management system?

1. high resolution video display
2. printer
3. high speed, large capacity disk
4. mouse

✅ Correct Answer: 3

Which of the following is not true of the traditional approach to information processing

1. it is file oriented
2. programs are dependent on the file
3. it is inflexible
4. all of the above are true

✅ Correct Answer: 1

The relational database environment has all of the following components except

1. separate files
2. database
3. query languages
4. database

✅ Correct Answer: 2

The management information system (MIS) structure with one main computer system is called a

1. hierarchical MIS structure
2. distributed MIS structure
3. centralized MIS structure
4. decentralized MIS structure

✅ Correct Answer: 3

A top-to-bottom relationship among the items in a database is established by a

1. hierarchical schema
2. network schema
3. relational schema
4. All of the above

✅ Correct Answer: 1

The relational database environment has all of the following components except

1. users
2. separate files
3. database
4. query languages

✅ Correct Answer: 2

Database management systems are intended to

1. establish relationship among records in different files
2. manage file access
3. maintain data integrity
4. All of the above

✅ Correct Answer: 4

One approach to standardization storing of data?

1. MIS
2. structured programming
3. CODASYL specification
4. None of the above

✅ Correct Answer: 3

The language used application programs to request data from the DBMS is referred to as the

1. DML
2. DDL
3. query language
4. any of the above

✅ Correct Answer: 1