DBMS MCQ Question and Answer

Question - 1

Which below data type can store unstructured data?

CHAR
RAW
NUMERIC
FLOAT

Solutions

Question - 2

The method of access which uses key transformation is known as

Hash
Salt
Random
None of the above

Solutions

Question - 3

In E-R diagram generalisation is represented by

Ellipse
Triangle
Sqaure
Rectangle

Solutions

Question - 4

What do you mean by one to many relationships?

One class may have many teachers
Many classes may have many teachers
Many teachers may have many classes
One teacher can have many classes

Solutions

Question - 5

The term "FAT" is stands for_____

File Allocation Table
File Allocation Tree
File Allocation Tuples
None of the above

Solutions

Question - 6

A data manipulation command the combines the records from one or more tables is called

JOIN
SELECT
GET
PROJECT

Solutions

Question - 7

Which of the following can be considered as the maximum size that is supported by FAT?

Solutions

Question - 8

Which database level is closest to the users?

Internal
External
Physical
Conceptual

Solutions

Question - 9

A B-tree of order n has maximum of _____________ children

n
n-1
n+1
(n+1)/2

Solutions

Question - 10

Which of the following can be used to extract or filter the data & information from the data warehouse?

Data Concurrency
Data recovery tool
Data mining
None of the above

Solutions

Question - 11

To delete a particular column in a relation the command used is

UPDATE
ALTER
DROP
DELETE

Solutions

Question - 12

To which of the following the term "DBA" referred?

Data Bank Administrator
Data Bank Admin
Database Administrator
Data Administrator

Solutions

Question - 13

In E-R Diagram relationship type is represented by

Triangle
Rectangle
Diamond
Ellipse

Solutions

Question - 14

Cross Product is a

Unary Operator
Ternary Operator
Binary Operator
Not an operator

Solutions

Question - 15

The result of the UNION operation between R1 and R2 is a relation that includes

All the tuples of R1
All the tuples of R2
All the tuples of R1 and R2
None of the above

Solutions

Question - 16

In E-R Diagram derived attribute is represented by

Dashed ellipse
Ellipse
Rectangle
Triangle

Solutions

Question - 17

Rows of a relation are known as the _______.

Tuples
Degree
Entity
All the above

Solutions

Question - 18

Which of the following is a record based logical model?

Object-oriented model
E-R Model
Network Model
None of these

Solutions

Question - 19

Which of the following refers to the number of tuples in a relation?

Cardinality
Entity
Column
None of the above

Solutions

Question - 20

Which of the following database object does not physically exist?

View
Table
Index
None of the above

Solutions

Practice more set questions

Tags:

60+ Best DBMS Interview Questions, DBMS MCQ questions for placement,DBMS interview questions, Previously asked DBMS Questions, Frequently asked DBMS Questions,DBMS Questions for TCS, DBMS Interview Questions for Freshers, DBMS Interview Questions for Experience, Accenture DBMS Interview Questions, DBMS Objective Questions for Interview,

Practice More sets Questions

Topic wise Database