DBMS MCQ Questions

DBMS MCQ Questions

Sharad Jaiswal
25th Nov, 2021

We have listed here the best DBMS MCQ Questions for your basic knowledge of DBMS (Database Management System). This DBMS MCQ Test contains 25+ DBMS Multiple Choice Questions. You have to select the right answer to every question to check your final preparation for the DBMS MCQ Interview or Exams.

Home
Interview Questions
DBMS MCQ Questions

Practice Best DBMS MCQ Questions;

1) Which of the following is an Open Source DBMS?

A. MySQL
B.Oracle
C.Microsoft SQL Server
D.Microsoft Access

2) A binary relationship is which of the following?

A. attribute with two different relationships
B.entity with two different relationships
C.between two entities
D.between two attributes

3) What are Tuples called?

A. Tables
B.Types
C.Lines
D.Records

4) ______is the structure of the database.

A. Schema
B.Relation
C.Table
D.None of these

5) Information can be transferred between DBMS and______

A. Spreadsheet program
B.Graphics program
C.Word processor program
D.All of the above

6) DBMS is the bridge between operating system and ________

A. User
B.Database administrator
C.Application program
D.None of the above

7) DBMS query language is design to

A. structure of a database
B.support end-users
C.development of complex applications software
D.All of the above

8) Which is not the feature of database:

A. Flexibility
B.Data Integrity
C.Independence
D.Data redundancy

9) Large collection of files are called

A. database
B.records
C.sectors
D.fields

10) How many primary key can a table in database have?

A. One
B.Two
C.Three
D.More than

11) The primary key is selected from the

A. Foreign keys
B.Candidate keys
C.Composite keys
D.Determinants

12) Which normal form is the partial dependency removed?

A. First
B.Second
C.Third
D.BCNF

13) An instance is _______

A. schema
B.set of entites
C.set of attributes
D.a set of relationships

14) _____is the information about data.

A. Data
B.Meta-Data
C.Entity
D.Relations

15) A Report generator is used to

A. print files on paper
B.update files
C.data entry
D.delete files

16) Which One Of The Following Design Is Both Software And Hardware Independent ?

A. Conceptual
B.Physical
C.Logical
D.None of these

17) Set Concept mainly are used in

A. Network Model
B.Relational Model
C.Hierarchical Model
D.Both A & B

18) Which One Is Lowest Level Data Model ?

A. Logical Data Model
B.Physical Data Model
C.External Data Model
D.All of the above

19) Which Of The Following Is An Example For Network Database?

A. Oracle
B.DBMS
C.Ingress
D.IDBS

20) Subschema Expresse are

A. Logical View
B.External View
C.Physical View
D.None of the above

21) Ensuring isolation property is the responsibility of the

A. Transaction-management component of the DBMS
B.Buffer management component in DBMS
C.Recovery-management component of the DBMS
D.Concurrency-control component of the DBMS

22) A functional dependency is a relationship between or among

A. Attributes
B.Relations
C.Tables
D.Rows

23) The relational model feature is that there

A. Is much more data independence than some other database models
B.Is no need for primary key data
C.Are explicit relationships among records
D.Are tables with many dimensions

Leave A Comment :

Your Comment

Valid name is required.

Name *

Valid name is required.

Your Email *

Valid email id is required.

Related MCQ/Quiz

01st
May

Robotic Process Automation MCQ

Robotic Process Automation MCQ

01st
Nov

AWS MCQ Questions

AWS MCQ Questions

01st
Nov

Kotlin MCQ

01st
Nov

MS Excel MCQ Questions

MS Excel MCQ Questions

01st
Nov

Node Js MCQ Questions

Node Js MCQ Questions

01st
Nov

Xml MCQ Questions

Xml MCQ Questions