Database Management System MCQs

Database Management System MCQs

These Database Management System multiple-choice questions and their answers will help you strengthen your grip on the subject of Database Management System. You can prepare for an upcoming exam or job interview with these Database Management System MCQs.
So scroll down and start answering.

1: Data Manipulation Language (DML) is not to

A.   Create information table in the Database

B.   Deletion of information in the Database

C.   Insertion of new information into the Database

D.   Modification of information in the Database

2: Report generators are used to

A.   Retrieve information from files

B.   None of these

C.   Both retrieve information from files and answer queries

D.   Store data input by a user

E.   Answer queries

3: Database locking concept is used to solve the problem of?

A.   Lost Update

B.   Inconsistent Data

C.   All of these

D.   Uncommitted Dependency

4: The Primary key must be

A.   Option Non Null or Unique


C.   Non Null

D.   Option Non Null and Unique

5: Administrate supervision of database activities is the responsibility of the

A.   DP Manager

B.   DB Manager

C.   Database Administrator

D.   None of these

E.   DP administration

6: In SQL, which of the following is not a data definition language commands?


B.   Revoke



E.   None of these

7: Snapshot of the dta in the database at a given instant of time is called

A.   Database Instance

B.   Database Schema

C.   Database Snapshot

D.   All of these

8: A command that lets you change one or more fields in a record is


B.   Modify

C.   Look-up

D.   All of these

E.   None of these

9: What is ACID properties of Transactions?

A.   Atomicity, Consistency, Isolation, Durability

B.   Atomicity, Consistency, Inconsistent, Durability

C.   Atomicity, Consistency, Isolation, Database

D.   Automatically, Concurrency, Isolation, Durability

10: Data integrity control

A.   All of these

B.   Requires the use of passwords to prohibit unauthorized access to the file

C.   Is used to set upper and lower limits on numeric data

D.   None of these

E.   Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

11: A command to remove a relation from an SQL database

A.   Drop table < table name >

B.   Erase table < table name >

C.   Alter table < table name >

D.   Delete table < table name >

12: In DBMS FD stands for _______

A.   Functional dependency

B.   Functional data

C.   Facilitate dependency

D.   Facilitate data

13: The attribute that can be divided into other attributes is called

A.   Simple Attribute

B.   Derived Attribute

C.   Multi-valued Attribute

D.   Composite Attribute

14: How many types of keys in Database Design?

A.   Foreign key

B.   All of these

C.   Candidate key

D.   Primary key

15: Which of the following in true regarding Null Value?

A.   Null < 0

B.   Null > 0

C.   Null = 0

D.   Null < > 0

16: A _____ DBMS distributes data processing tasks between the workstation and a network server.

A.   Hierarchical

B.   Relational

C.   Network

D.   Client server

E.   None of these

17: In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

A.   None of these


C.   All of these



18: If every non-key attribute is functionally dependent on the primary key, the relation will be in

A.   Third Normal Form

B.   Fourth Formal Form

C.   Second Normal Form

D.   First Normal Form

19: Which of the following is not a level of data abstraction?

A.   View Level

B.   Logical Level

C.   Physical Level

D.   Critical Level

20: Which of the following in true regarding Referential Integrity?

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

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

C.   Every primary-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

21: ____ is used to reveal the meaning of data.

A.   Relationship

B.   Information

C.   Composite

D.   Unstructured

22: ______ databases are the most frequently used electronic databases.

A.   Flat-file

B.   Object-oriented

C.   Multidimensional

D.   Relational

23: ________ databases are the most commonly used electronic databases.

A.   Flat-file

B.   Object-oriented

C.   Multidimensional

D.   Relational

24: ________ involves searching for patterns and relationships among data.

A.   Data mining

B.   Data marting

C.   Data processing

D.   Knowledge management

E.   Data warehousing

25: ________ is used to ensure that data is organized most efficiently in a database.

A.   Artificial intelligence

B.   Centralization

C.   Relational

D.   Normalization

26: _________ maintains information about various types of objects, events, people, and places.

A.   Web analytics

B.   Infographics

C.   Database

D.   Classification

27: __________ are the most commonly used database clients.

A.   Operational

B.   Incorrect

C.   Browsers

D.   Primary key

28: A ____ database supports data distributed across several different sites.

A.   Desktop

B.   Workgroup

C.   Distributed

D.   Enterprise

29: A ____ is a program that lets computer users create and access a collection of organized data.

A.   Database management system

B.   Data warehouse

C.   Database

D.   Management system

30: A ______ is the highest level of data hierarchy.

A.   Bits

B.   Character

C.   Database

A.   Database

B.   Spreadsheet

C.   Memo

D.   Macro

A.   Database

B.   Spreadsheet

C.   Memo

D.   Macro

33: A ________ is a highly structured collection of data values organized into separate tables.

A.   False

B.   Database

C.   Data cube

D.   Timeline

A.   Field

B.   Table

C.   Primary Key

D.   Report

35: A consistent database is ____.

A.   One in which all tables have foreign keys

B.   One in which all data integrity constraints are satisfied

C.   One in which all data integrity constraints are not satisfied

36: A data ____ table describes the fields you plan to maintain in a table.

A.   Dialog box

B.   Two or four

C.   Definition

D.   Contains

37: A database administrator (dba) is responsible for _____.

A.   True

B.   Used for analytical purposes.

C.   Hierarchy

D.   Developing recovery procedures in case data is lost or corrupted

38: A distributed _____ can reference several different local or remote data processing sites.

A.   Request

B.   Site

C.   Data location

D.   Transaction

39: A(n) ____ synonym is used by others to access an individual's database objects.





40: A(n) ______ is an item that contains data, as well as the actions that read or process the data.

A.   Attribute

B.   Table

C.   Object

D.   Field

41: After a dbms detects a deadlock, the ____ should break the deadlock.

A.   First user

B.   Second user

C.   Database administrator


42: An attribute is also referred to as a ________.

A.   Field

B.   Data mart

C.   False

D.   True

43: An electronic storage file where firms keep customer information is known as a(n) ________.

A.   Database

B.   Worksheet

C.   Program

44: An entity that exists to implement a many-to-many relationship is called a(n) ____.

A.   Weak entity

B.   Minimum

C.   Composite entity

D.   Independent entity

45: Another name for a composite entity is a(n) _____ entity.

A.   Bridge

B.   False

C.   Attribute

D.   Unique

46: Another term for a database row is a(n) ________.

A.   Attribute

B.   Primary key

C.   Hadoop

D.   Record

47: As part of a dbms, a(n) _________ documents information about a database.

A.   Data cleansing

B.   Data mining

C.   Data warehouse

D.   Data dictionary

48: Big data analytics is usually associated with ________ services.

A.   Decision support

B.   Data warehouse

C.   Office support

D.   Management information

49: A ____ is a group of interrelated files.

A.   False

B.   The System Development Life Cycle

C.   True

D.   Database

50: Browser-based applications ________.

A.   Support querying using graphics

B.   Process queries using C++

C.   Are thick-client applications

D.   Can only display static content