JobSandhan.com

Latest Govt Job Notification Sarkari Naukri Employment News 2018

DBMS MCQ Database Questions Answers Download PDF

Database Management System MCQ DBMS MCQ Questions Answers Download PDF

DBMS MCQ Database Management System Questions Answers Download PDF

1) In the context of data warehousing, data map or ‘data about data’ is known as …………….

a) tuple

b) attribute

c) metadata

d) teradata

View Answer

2) Which of the following normal form deals with the anomaly of multivalue dependency?

a) 1NF

b) 2NF

c) 4NF

d) 5NF

View Answer

3) Which of the following normal form deals with the repeating group anomaly?

a) 1NF

b) 2NF

c) 4NF

d) 5NF

View Answer

4) …………… is a database language used to define data structures in SQL?

a) Sybase

b) Oracle

c) DDL

d) MySQL

View Answer

5) The ………………… is a database file that contains metadata.

a)  data index

b) data repository

c) data dictionary

d) none

View Answer

6)Which of the following is not the state of a transaction in the database?

a) Active

b) Committed

c) Terminated

d) Nullified

View Answer

7) The …………… file saves the recovery scenario in Quick Test Professional (QTP) environment

a) QRS

b) JPEG

c) DOC

d) TSR

View Answer

8) Which of the following is not a command is SQL?

a) WHERE

b) ORDER BY

c) REMOVE

d) SELECT

View Answer

9) How should we traverse an oracle database to retrieve a row in the quickest possible time?

a)  Full table scan

b) Unique index

c) Primary key

d) Table access by row id

View Answer

10) Which of the following is a concurrency control protocol?

a) Locked-based protocol

b) two-phase locking protocol

c) Timestamp ordering protocol

d) all

View Answer

11) Which of the following normal forms deals with the anomaly of partial functional dependency on the composite key?

a) 1NF

b) 2NF

c) 4NF

d) 5NF

View Answer

12)  ………………… represents the structure of the database in a formal language acceptable by the DBMS.

a) Database schema

b) ER diagram

c) Database table

d) None

View Answer

13) Which of the following statements are used to create indexes in the database?

a) CREATE INDEX

b)  BUILD INDEX

C) WRITE INDEX

d) None’

View Answer

14)Which of the following is a database recovery technique?

a) Check-pointing

b) Transaction rollback

c) Shadow paging

d) All

View Answer

15)Which of the following is a foreing key constraint?

a)Referential integrity

b) Domain integrity

d) Entity integrity

d) All

View Answer

16) Which of the following trains are important to select a primary key?

a) Unique

b) Not Null

c) Fully functional dependency

d) Indexed

d) All

View Answer

17) What are various types of DBMS?

a) ORBDMS

b) Client server DBMS

c) Distributed DBMS

d) OODBMS

e) All

View Answer

18) Which of the following are the types of integrity constraints enforced by RDBMS?

a) Entity integrity

b) Domain integrity

c) Referential integrity

d) All

View Answer

JobSandhan.com © 2018        Home     About Us     Sitemap     Disclaimer     Privacy Policy     Contact us