Database Management System Multiple Choice Questions with Answers

dbms mcq
database managment system

Database Management System

 

Multiple Choice Questions  with Answers:-

 

1.) Where is metadata stored in MySQL?

Options are:

A.) In the MySQL database meta

B.) In the MySQL database metasql

C.) In the MySQL database metadata

D.) In the MySQL database mysql

 

Answer: D

 

3.) What MySQL property is used to create a surrogate key in MySQL?

Options are:

A.) IDENTICAL

B.) UNIQUE

C.) AUTO_INCREMENT

D.) SEQUENCE

 

Answer: C

 

4.) A relational database consists of a collection of

Options are:

A.) Keys

B.) Records

C.) Tables

D.) Fields

 

Answer: C

 

5.) A Database Management System (DBMS) is:

Options are:

A.) Collection of data describing one particular enterprise

B.) Collection of programs to access data

C.) All Options are correct

D.) Collection of interrelated data

 

Answer: C

 

6.) Which of the following is not a level of data abstraction?

Options are:

A.) View Level

B.) Physical Level

C.) Logical Level

D.) Critical Level

 

Answer: D

 

7.) Disadvantages of File systems to store data is:

Options are:

A.) Data isolation

B.) Data redundancy and inconsistency

C.) Difficulty in accessing data

D.) All options are correct

 

Answer: D

 

                       

8.) In an Entity Relationship Diagram Rectangles represents

Options are:

A.) Tables

B.) Attributes

C.) Database

D.) Entity Sets

 

 Answer: D

 

9.) Which of the following is not a Storage Manager Component?

Options are:

A.) Transaction Manager

B.) Logical Manager

C.) File Manager

D.) Buffer Manager

 

Answer: B

 

10.) Data Manipulation Language enables users to

Options are:

A.) Retrieval of information stored in database

B.) Insertion of new information into the database

C.) Deletion of information from the database

D.) All the options are correct

 

Answer: D

 

11.) Which of the following is not an Schema?

Options are:

A.) Logical Schema

B.) Physical Schema

C.) Database Schema

D.) Critical Schema

 

 Answer: D

 

12.) Which of the following is Database Language?

Options are:

A.) Data Definition Language

B.) Data Manipulation Language

C.) Data Query Language

D.) All of the options

 

Answer: D

 

13.) Which of the following in not a function of DBA?

Options are:

A.) Network Maintenance

B.) Schema Definition

C.) Authorization for data access

D.) Routine Maintenance

 

Answer: A

                       

14.) Which of the following is a Data Model?

Options are:

A.) Entity Relationship Model

B.) Object Based Data Model

C.) All of the options are correct

D.) Relational Data Model

 

Answer: C

 

15.) A Database Management System (DBMS) is

Options are:

A.) Collection of interrelated data

B.) Collection of data describing one particular enterprise

C.) All of the options

D.) Collection of programs to access data

 

Answer: C

 

16.) Which of the following is not a level of data abstraction?

Options are:

A.) Physical Level

B.) View Level

C.) Critical Level

D.) Logical Level

 

Answer: C

 

17.) Disadvantages of File systems to store data is:

Options are:

A.) Data redundancy and inconsistency

B.) Data isolation

C.) All of the options

D.) Difficulty in accessing data

 

Answer: C

 

18.) Which of the following is not a Storage Manager Component?

Options are:

A.) Transaction Manager

B.) Buffer Manager

C.) File Manager

D.) Logical Manager

 

Answer: D

 

19.) Data Manipulation Language enables users to

Options are:

A.) Retrieval of information stored in database

B.) Deletion of information from the database

C.) All of the above

D.) Insertion of new information into the database

 

Answer: C

 

20.) Which of the following is not an Schema?

Options are:

A.) Logical Schema

B.) Critical Schema

C.) Database Schema

D.) Physical Schema

 

Answer: B

 

 

21.) Which of the following is Database Language?

Options are:

A.) All of the options

B.) Query Language

C.) Data Definition Language

D.) Data Manipulation Language

 

Answer: A

 

22.) Which of the following in not a function of DBA?

Options are:

A.) Authorization for data access

B.) Network Maintenance

C.) Routine Maintenance

D.) Schema Definition

 

Answer: B

                       

23.) Which of the following is a Data Model?

Options are:

A.) Object-Based data model

B.) All of the options

C.) Entity-Relationship model

D.) Relational data model

 

Answer: B

 

24.) Column header is refer as

Options are:

A.) Table

B.) Domain

C.) Attributes

D.) Relation

 

Answer: C

 

25.) _______ allow us to identify uniquely a tuple in the relation.

Options are:

A.) Schema

B.) Superkey

C.) Domain

D.) Attribute

 

Answer: B

 

 

26.) Minimal Superkeys are called

Options are:

A.) Schema keys

B.) Attribute keys

C.) Candidate keys

D.) Domain keys

 

Answer: C

 

27.) Which of the following is not Modification of the Database

Options are:

A.) Updating

B.) Sorting

C.) Deletion

D.) Insertion

 

Answer: B

                       

28.) Which of the following in not Outer join?

Options are:

A.) Left outer join

B.) Full outer join

C.) All of the options

D.) Right outer join

 

Answer: C

 

29.) Set of premitted values of each attribute is called

Options are:

A.) Tuple

B.) Schema

C.) Domain

D.) Relation

 

 Answer: C

 

30.) Which of the following is true regarding Null Value?

Options are:

A.) Null<0

B.) Null=0

C.) Null<>0

D.) Null>0

 

 Answer: C

 

31.) Logical design of database is called

Options are:

A.) All of the options

B.) Database Schema

C.) Database Instance

D.) Database Snapshot

 

Answer: B

                       

32.) Snapshot of the data in the database at a given instant of time is called

Options are:

A.) Database Instance

B.) All of the options

C.) Database Schema

D.) Database Snapshot

 

Answer: A

 

33.) Which of the following is not Unary operation?

Options are:

A.) Rename

B.) Union

C.) Select

D.) Project

 

Answer: B

 

34.) Which of the following is not binary operation?

Options are:

A.) Union

B.) Set Difference

C.) Cartesian Product

D.) Project

 

Answer: D

 

35.) Which of the following is correct regarding Aggregate functions?

Options are:

A.) It takes a single value and returns a single value as result

B.) It takes a list of values and return a single values as result

C.) It takes a list of values and return a list of values as result

D.) It takes a single value and returns a list of values as result

 

Answer: B

 

36.) The Primary key must be

Options are:

A.) Non Null

B.) Unique

C.) Option A or B

D.) Option A and B

 

 Answer: D

 

37.) A command to remove a relation from an SQL database

Options are:

A.) Delete table

B.) Erase table

C.) Alter table

D.) Drop table

 

Answer: D

 

38.) which of the following is not an Aggregate function?

Options are:

A.) Select

B.) Avg

C.) Min

D.) Max

 

Answer: A

 

39.) The attribute that can be divided into other attributes is called

Options are:

A.) Composite Attribute

B.) Derived Attribute

C.) Simple Attribute

D.) Multi-valued Attribute

 

Answer: A

 

40.) What is ACID properties of Transactions?

Options are:

A.) Atomicity, Consistency, Isolation, Database

B.) Automatically, Concurrency, Isolation, Durability

C.) Atomicity, Consistency, Isolation, Durability

D.) Atomicity, Consistency, Inconsistent, Durability

 

Answer: C

 

41.) If every non-key attribute is functionally dependent on the primary key, the relation will be in

Options are:

A.) Fourth Formal Form

B.) Third Normal Form

C.) First Normal Form

D.) Second Normal Form

 

Answer: B

 

42.) Database locking concept is used to solve the problem of

Options are:

A.) Inconsistent Data

B.) All of the options

C.) Lost Update

D.) Uncommitted Dependency

 

 Answer: B

 

43.) UML is stands for

Options are:

A.) Universal Modeling Language

B.) United Modeling Language

C.) Uni Modeling Language

D.) Unified Modeling Language

 

Answer: D

 

44.) Data Manipulation Language (DML) is not to

Options are:

A.) Insertion of new information into the Database

B.) Modification of information in the Database

C.) Create information table in the Database

D.) Deletion of information in the Database

 

 Answer: C

 

45.) Which of the following in true regarding Referential Integrity?

Options are:

A.) Every primary-key value must match a primary-key value in an associated table

B.) Every primary-key value must match a foreign-key value in an associated table

C.) Every foreign-key value must match a foreign-key value in an associated table

D.) Every foreign-key value must match a primary-key value in an associated table

 

Answer: D

     

46.) Which of the following option is use to retrieval of data?

Options are:

A.) Stack

B.) Data Structure

C.) Linked list

D.) Query

 

 Answer: D

 

47.) ODBC stands for ______

Options are:

A.) None of above

B.) Open database connection

C.) Offline database connection

D.) Oriented database connection

 

Answer: B

                       

48.) Which of the following is an unary operation?

Options are:

A.) Selection operation

B.) Primitive operation

C.) Projection operation

D.) Generalized selection

 

Answer: D

 

49.) Which SQL Query is use to remove a table and all its data from the database?

Options are:

A.) None of these

B.) Drop Table

C.) Create Table

D.) Alter Table

 

Answer: B

 

50.) In precedence of set operators the expression is evaluated from:

Options are:

A.) Left to Right

B.) Right to Left

C.) Left to Left

D.) Right to Right

 

Answer: A

 

51.) In DBMS, FD stands for _______

Options are:

A.) Facilitate data

B.) Functional data

C.) Facilitate dependency

D.) Functional dependency

 

 Answer: D

 

52.) How many types of keys in Database Design?

Options are:

A.) Foreign key

B.) All of the options

C.) Candidate key

D.) Primary key

 

Answer: B

 

53.) Which of the following is based on Multi Valued Dependency?

Options are:

A.) Third

B.) Fourth

C.) First

D.) Second

 

 Answer: B

 

54.) Which of the following is the structure of the Database?

Options are:

A.) Table

B.) None of these

C.) Schema

D.) Relation

 

Answer: C

 

55.) The minimal set of super key is called

Options are:

A.) Primary key

B.) Secondary key

C.) Foreign key

D.) Candidate key

 

 Answer: D

     

 

56.) ______________ is a classical approach to database design?

Options are:

A.) Bottom – Up approach

B.) Top – Down approach

C.) Left – Right approach

D.) Right – Left approach

 

Answer: B

 

57.) _____________ refers to the correctness and completeness of the data in a database?

Options are:

A.) Data independence

B.) Data integrity

C.) Data security

D.) Data constraint

 

Answer: B

 

58.) A table that displays data redundancies yields ____________ anomalies

Options are:

A.) Insertion

B.) Deletion

C.) Update

D.) All of the options

 

 Answer: D

 

59.) A lock that allows concurrent transactions to access different rows of the same table is known as a

Options are:

A.) Row-level lock

B.) Database-level lock

C.) Field-level lock

D.) Table-level lock

 

 Answer: C

                       

60.) A type of query that is placed within a WHERE or HAVING clause of another query is called

Options are:

A.) Multi-query

B.) Sub query

C.) Super query

D.) Master query

 

 Answer: B

 

61.) Which of the following hardware component is the most important to the operation of database

management system?

Options are:

A.) High resolution video display

B.) Printer

C.) Plotter

D.) High speed, large capacity disk

 

Answer: D

 

62.) A form defined

Options are:

A.) None of the options

B.) Where data is placed on the screen

C.) The width of each field

D.) Both where data is placed on the screen and the width of each field

 

Answer: B

 

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

Options are:

A.) In can be more easily accessed

B.) Both Storage space is wasted and Changing the data in one spot will cause data inconsistency

C.) Storage space is wasted

D.) Changing the data in one spot will cause data inconsistency

 

Answer: B

 

64.) Which of the following is a problem of file management system?

Options are:

A.) Data redundancy and program dependence

B.) All of the options

C.) Difficult to update

D.) Lack of data independence

 

Answer: B

 

65.) Which of the following is not an advantage of the database approach

Options are:

A.) Elimination of data redundancy

B.) Ability of associate deleted data

C.) Increased security and program/data independence

D.) all of the above

 

Answer: D

 

66.) An audit trail

Options are:

A.) None of the options

B.) Is the recorded history of operations performed on a file

C.) Is used to make backup copies

D.) Can be used to restore lost information

 

Answer: B

 

67.) One approach to standardization storing of data?

Options are:

A.) CODASYL specification

B.) None of the options

C.) MIS

D.) Structured programming

 

Answer: A

 

68.) Which of the following contains a complete record of all activity that affected the contents of a

database during a certain period of time?

Options are:

A.) Transaction log

B.) Data manipulation language

C.) Report writer

D.) Query language

 

Answer: A

 

69.) Report generators are used to

Options are:

A.) Store data input by a user

B.) Answer queries

C.) Both Retrieve information from files and Answer queries

D.) Retrieve information from files

 

Answer: C

 

70.) Which of the following is true of a network structure?

Options are:

A.) It will be dominant data base of the future

B.) It allows a many-to-many relationship

C.) It is a physical representation of the data

D.) It is conceptually simple

 

Answer: B

 

71.) A record management system

Options are:

A.) Can handle many files of information at a time

B.) Always uses a list as its model

C.) Both can handle many files of information at a time and always uses a list as its model

D.) Can be used to extract information stored in a computer file

 

Answer: D

 

72.) One data dictionery software package is called

Options are:

A.) DB/DC dictionary

B.) Datapac

C.) TOTAL

D.) ACCESS

 

Answer: A

                       

73.) The function of a database is …

Options are:

A.) To check all input data

B.) To output data

C.) To collect and organize input data

D.) To check all spelling

 

Answer: C

                       

74.) A command that lets you change one or more fields in a record is

Options are:

A.) None of the options

B.) Modify

C.) Insert

D.) Lookup

 

Answer: B

 

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

Options are:

A.) High level language

B.) 4GL

C.) Query Language

D.) SQL

 

 Answer: C

 

76.) Information can be transferred between the DBMS and a

Options are:

A.) Spreadsheet program

B.) Word processor program

C.) Graphics program

D.) All of the options

 

 Answer: D

 

77.) The relational database environment has all of the following components except

Options are:

A.) Users

B.) Database

C.) Query languages

D.) Separate files

 

 Answer: D

 

78.) The ascending order of a data hirerchy is:

Options are:

A.) Bit-byte-file-record-field-database

B.) Bit-byte-field-record-file-database

C.) Bit-byte-record-field-file-database

D.) Byte-bit-field-record-file-database

 

Answer: B

 

79.) Primitive operations common to all record management system include

Options are:

A.) Look-up

B.) All of the options

C.) Print

D.) Sort

 

Answer: A

 

80.) Generalized database management system do not retrieve data to meet routine request

Options are:

A.) False

B.) True

 

Answer: A

 

81.) Which of the following is not a relational database?

Options are:

A.) dBase IV

B.) FoxPro

C.) Reflex

D.) 4th Dimension

 

 Answer: C

 

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

Options are:

A.) Hierarchical schema

B.) All of the options

C.) Network schema

D.) Relational schema

 

 Answer: A

 

83.) In order to use a record management system

Options are:

A.) You need to understand the model the record management system uses

B.) None of the options

C.) You need to understand the low level details of how information is stored

D.) Both you need to understand the model the record management system uses and you need to understand

the low level details of how information is stored

 

Answer: A

 

84.) Choose the RDBMS which supports full fledged client server application development

Options are:

A.) dBase V

B.) Ingress

C.) Oracle 7.1

D.) FoxPro 2.1

 

Answer: C

 

85.) Sort/Report generators

Options are:

A.) Are faster than index/report generators

B.) Do not need to sort before generating report

C.) Both require more disk space than indexed/report generators and are faster than index/report

generators

D.) Require more disk space than indexed/report generators

 

Answer: D

 

86.) The highest  level in the hierarchy of data organization is called

Options are:

A.) Data base

B.) Data record

C.) Data bank

D.) Data file

 

Answer: A

 

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

Options are:

A.) Class

B.) GPA

C.) Major

 

Answer: D

 

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

Options are:

A.) Decentralized MIS structure

B.) Centralized MIS structure

C.) Hierarchical MIS structure

D.) Distributed MIS structure

 

Answer: B

 

89.) In the DBMS approach, application programs perform the

Options are:

A.) Storage function

B.) Access control

C.) All of the options

D.) Processing functions

 

Answer: D

 

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

Options are:

A.) It is file oriented

B.) It is inflexible

C.) There is common sharing of data among the various applications

D.) Programs are dependent on the file

 

Answer: C

 

 

91.) Batch processing is appropriate if

Options are:

A.) Only a few transactions are involved

B.) None of the options

C.) Large computer system is available

D.) Only a small computer system is avilbale

 

 Answer: B

 

92.) Large collection of files are called

Options are:

A.) Sectors

B.) Database

C.) Fields

D.) Records

 

Answer: B

                       

93.) A transparent DBMS

Options are:

A.) Both can not hide sensitive information from users and keeps its logical structure hidden from users

B.) Keeps its physical structure hidden from users

C.) Can not hide sensitive information from users

D.) Keeps its logical structure hidden from users

 

Answer: B

 

94.) A file produced by a spreadsheet

Options are:

A.) None of the options

B.) Is generally stored on disk in an ASCII text fromat

C.) Can be used as is by the DBMS

D.) Both is generally stored on disk in an ASCII text fromat and can be used as is by the DBMS

 

Answer: B

 

95.) The model for a record management system might be

Options are:

A.) All of the options

B.) A business form

C.) Handwritten list

D.) A Rolodex card file

 

Answer: A

 

96.) Database management systems are intended to

Options are:

A.) Eliminate data redundancy

B.) Establish relationship among records in different files

C.) Manage file access and maintain data integrity

D.) All of the options

 

 Answer: D

                       

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

Options are:

A.) DDL

B.) All of the options

C.) DML

D.) query language

 

Answer: C

 

98.) A set of programs that handle a firm’s database responsibilities is called

Options are:

A.) Database management system (DBMS)

B.) Data management system (DMS)

C.) All of the options

D.) Database processing system (DBPS)

 

Answer: C

 

99.) In a large DBMS

Options are:

A.) Each subschema contains every field in the logical schema

B.) Each user can access every subschema

C.) None of the options

D.) Each user can “see” only a small part of the entire database

 

Answer: D

 

100.) In a large DBMS

Options are:

A.) None of the options

B.) Each user can “see” only a small part of the entire database

C.) Each subschema contains every field in the logical schema

D.) Each user can access every subschema

 

Answer: B

Leave a Reply