DBMS Multiple Choice Questions with Answers Set-5

This post contains a database management system related to 20 multiple-choice questions (DBMS SET-5) that help you to go through the subject and prepare you for DBMS related questions in competitive exams.

DBMS MCQ Test Series Set-5

• Total Number of Questions: 20

• Each question carries equal marks i.e 1

• No Negative Marking

Page 1 of 2

1. The data control language(DCL).

A.Is used to manage user access to data bases

B.Is used to manipulate the contents of a database in some form

C.It is used to manage user access to databases and also used to manipulate the contents of a database in some form

D.Used for inserting, deleting and updating data in a database

E.None of these

2. A collection of fields is called a record with respect to DBMS, a record corresponds to _________.

A.Tuple

B.Relation

C.File

D.Attribute

E.None of these

3. __________ is a software application that enables users to create, manage and access data in a database.

A.B2B

B.B2C

C.DBMS

D.Multidimensional database

E.C2C

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

A.Hirearchical schema

B.Network schema

C.Relational schema

D.Hierarchical schema and Network schema

E.Network Schema and Relational schema

5. In the relational schema, each tuple is divided into fields called __________.

A.Relations

B.Domains

C.Queries

D.Relations and Domains

E.Relations and queries

6. Which of the following joins execute the cartesian product?

A.Left outer

B.Right

C.Left

D.Right outer

E.Cross Join

7. The modify operation is likely to be done after _________.

A.Delate

B.Insert

C.Look up

D.All of these

E.None of these

8. The way a particular application views the data from the database that the application uses is a _________.

A.Module

B.Relation model

C.SCHEMA

D.Subschema

E.None of these

9. Which two files are used during operation of the DBMS?

A.Query language and utilities

B.Data manipulation language and query language

C.Data dictionary and transaction log

D.Data dictionary and queury language

E.None of these

10. Which normal form is considered adequate for relational database design?

A.2NF

B.3NF

C.4NF

D.BCNF

E.None of these

Page 2 of 2

11. An attribute of one table matching the primary key of another table, is called as __________.

A.Foreign Key

B.Secondary key

C.Candidate Key

D.Composite key

E.None of these

12. Which of the following SQL commands can be used to modify existing data in a database table?

A.MODIFY

B.UPDATE

C.CHANGE

D.NEW

E.None of these

13. Which of the following is used to write database schema?

A.DML

B.DDL

C.DCL

D.DLM

E.HLL

14. OLAP stands for __________.

A.On-line Analytical project

B.Online Analytical problem

C.Online Application process

D.Online Application Problem

E.Online Analytical Processing

15. Which of the following languages is used in programs or applications to fetch data form DBMS?

A.DML

B.VDL

C.DDL

D.SDL

E.PHP

16. Data mining is __________.

A.Storing data when in need

B.Automatic extraction of patters of information

C.Searching data on internet

D.All of these

E.None of these

17. Decision support system are based on _________ analysis.

A.Query and reporting

B.Data Mining

C.OLAP

D.All of these

E.None of these

18. Which of the following is the representation of entities in an ER diagram?

A.Ellipse

B.Rectangle

C.Diamond Box

D.Triangle

E.Circle

19. ___________ is a language component of DBMS which gets embedded in a program.

A.A query language

B.DML

C.DDL

D.DBA

E.DRL

20. A ROLLBACK command in a transaction __________.

A.Undoes the effects of the last UPDATE commanad

B.Restores the current of the database to its state at the end of the previous day

C.Does nothing

D.Makes sure that all changes to the database are in effect

E.Undergoes all changes to the database resulting from the execution of the transaction

 Loading...