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.

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 :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Nov
Kotlin MCQ