DBMS MCQ Database Questions Answers Download PDF

Database Management System MCQ DBMS MCQ Questions Answers Download PDF

There is a golden opportunity for all the candidates who want to learn about the database. We are answering all the questions on the database here.

 

dbms pdf notes, dbms mcq questions, dbms mcq questions and answers, dbms mcq questions with answers, dbms multiple choice questions with answers pdf, dbms full form, dbms interview questions, dbms interview questions and answers, dbms short notes

We provide material here for all the candidates who are preparing for the Competitive Exam.Those who have studied computer engineering must be preparing for the competitive exam.We have provided dbms mcq questions and answers thinking about them here. Just thinking about someone we have dbms mcq questions here.dbms interview questions and answers are very important for those who are preparing for the technical line. We have provided all the material here for dbms short notes.


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
Option – c)

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

a) 1NF

b) 2NF

c) 4NF

d) 5NF

View Answer
Option – c)

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

a) 1NF

b) 2NF

c) 4NF

d) 5NF

View Answer
Option – a)

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

a) Sybase

b) Oracle

c) DDL

d) MySQL

View Answer
Option – c)

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

a)  data index

b) data repository

c) data dictionary

d) none

View Answer
Option – a)

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
Option – d)

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

a) QRS

b) JPEG

c) DOC

d) TSR

View Answer
Option – a)

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

a) WHERE

b) ORDER BY

c) REMOVE

d) SELECT

View Answer
Option – c)

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
Option – d)

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
Option – d)

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
Option – b)

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
Option – a)

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
Option – a)

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

a) Check-pointing

b) Transaction rollback

c) Shadow paging

d) All

View Answer
Option – d)

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

a)Referential integrity

b) Domain integrity

d) Entity integrity

d) All

View Answer
Option – a)

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
Option – e)

17) What are various types of DBMS?

a) ORBDMS

b) Client server DBMS

c) Distributed DBMS

d) OODBMS

e) All

View Answer
Option – e)

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
Option – d)

error: Content is protected !!