Database Question Answers MCQ 2020 Download DBMS PDF

Download Database Question Answers MCQ PDF Database Question Answers MCQ Practice Set Database Question Answers MCQ Model Paper.

1)If a relation scheme is in BSNF then it is also in

a) First normal form

b) Second normal form

c)Third normal form

d) Not in any normal form

View Answer
Option – c.

2)Attribute of one table matching to the primary key of other table, is called as

a) foreign key

b) secondary key

c) candidate key

d) composite key

View Answer
Option – a.

3)Ascending order of data hierarchy is

a) bit->byte->record->field->file->database

b) bit->byte->field->record->file->database

c) byte->bit->field->record->file->database

c) byte->bit->field->file->record->database

View Answer
Option – B.

4)Non procedural query language can be related with

a) Function dependency

b) B tree

c) Domain calculus

d) Relational algebric operators

View Answer
Option – c.

5)Which command is used to set a link between two database files

a) JOIN

b) UPDATE

c) BROWSE

d) SET RELATION

View Answer
Option – d.

6) Which among following contains a complete record of all activity that affected the contents of a database during a creation period of time

a) report writer

b) query language

c) DML

d) transaction log

View Answer
Option – d.

7) Which among following is not a relational database

a)dBase IV

b) 4th Dimention

c) FoxPro

d) Reflex

View Answer
Option – d.

8) Data dictionary is a special file that contains

a) the names of all fields in all files

b) the data types of all fields of all files

c) Both of above

d) None of above

View Answer
Option – b.

9) In context of database DML Means

a) Data Multiplication Line

b) Data Manupulation Language

c) Data Method Limit

d) Data Merit Logic

View Answer
Option – b.

10) Data dictionary tell DBMS

a) what files are in the database

b) what attributes are processed by data

c) what these files contain

d) all of above

View Answer
Option – d.

11)Non procedural query language can be related with

a) Function dependency

b) B tree

c) Domain calculus

d) Relational algebric operators

View Answer
Option – c.

12) The distinguishable parts of a record are called

a) files

b) data

c) fields

d) formats

View Answer
Option – c.

13)The logical structure with one to many relationships is a

a) network

b) tree

c) chain

d) relational

View Answer
Option – b.

14) Embedded pointer provides

a) a secondary access path

b) a physical record key

c) an inverted index

d) all of above

View Answer
Option – a.

15)RAID configurations of a disk are used to provide

a) fault tolerance

b) high speed

c) high data density

c) none of above

View Answer
Option – a.
error: Content is protected !!