DBMS MCQ

DBMS MCQ | Freshers & Experienced

  • Sharad Jaiswal
  • 13th Feb, 2021

We have listed here the best DBMS MCQ Questions for your basic knowledge of DBMS MCQ. This DBMS MCQ Test contains 15 multiple Choice Questions. You have to select the right answer to every question.

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
React JS MCQ
01st
Feb
Angular Js MCQ
01st
Feb
Angular 2 MCQ
01st
Feb
JSON MCQ
01st
Feb
PHP MCQ