07th
Feb
DBMS MCQ

Take DBMS MCQ Quiz & Online Test to Test your Knowledge 

We have listed Below the best DBMS MCQ Questions and Answers, that checks your basic knowledge of DBMS (DataBase Management System). This DBMS MCQ Test contains 25 Multiple Choice Questions. You have to select the right answer to every question. apart from this, you can also download the DBMS MCQ Questions with Answers PDF Here.

Also, Read the Best DBMS Interview Questions.

DBMS MCQ Questions and Answers

1) A Computer File Contains Several Records. What Does Each Record Contain ?

  • A. Bytes
  • B.Words
  • C.Database
  • D.Fields

2) Data Are :

  • A. Information
  • B.Raw Facts And Figures
  • C.Electronic Representation Of Facts
  • D.None Of The Above

3) Which One Is Lowest Level Data Model ?

  • A. Physical Data Model
  • B.Logical Data Model
  • C.External Data Model
  • D.None Of The Above

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

  • A. Logical
  • B.Physical
  • C.Conceptual
  • D.None Of The Above

5) Which Of Following Are The Properties Of Entities ?

  • A. Table
  • B.Attributes
  • C.Switchboards
  • D.Groups
Download Free : DBMS MCQ PDF

6) The Level Of Data Abstraction Which Describes How The Data Is Actually Stored Is :

  • A. Conceptual Level
  • B.Physical Level
  • C.File Level
  • D.None Of These

7) A Data Model Is :

  • A. Used To Describe Structure Of A Database
  • B.Set Of Basic Operations On The Database
  • C.Both [A] And [B]
  • D.None Of The Above

8) SET Concept Is Used In :

  • A. Hierarchical Model
  • B.Relational Model
  • C.Network Model
  • D.None Of The Above

9) Choose The DBMS, Which Supports Full-fledged Client Server Application Development ?

  • A. DBASEIV
  • B.Ingress
  • C.FoxPro 2.1
  • D.Oracle 7.1

10) A Top-to-bottom Relationship Among The Items In A Database Is Established By A :

  • A. Network Schema
  • B.Hierarchical Schema
  • C.Relational Schema
  • D.All Of The Above

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

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

12) An Association Between Entities Two Tables Sharing An Attribute Is Called

  • A. Attribute Sharing
  • B.Relationship
  • C.Prototyping
  • D.Association

13) Database Is A

  • A. Set Of Tables
  • B.Set Of Columns
  • C.Set Of Classes
  • D.Set Of Collections

14) What Are Tuples Typically Called?

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

15) Report Generators Are Used To

  • A. Store Data Input By A User
  • B.Retrieve Information From Files
  • C.Answer Queries
  • D.Both B And C

16) The database schema is written in -

  • A. DML
  • B.HLL
  • C.DDL
  • D.DCL

17) A report generator is used to

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

18) An advantage of the database management approach is

  • A. data is dependent on programs
  • B.data is integrated and can be accessed by multiple programs
  • C.data redundancy increases
  • D.All of the above

19) A DBMS query language is designed to

  • A. specify the structure of a database
  • B.support end-users who use English-like commands
  • C.support in the development of complex applications software
  • D.All of the Above

20) DBMS helps achieve

  • A. Centralised control of data
  • B.Data independence
  • C.Both 1 & 2
  • D.None of the above

21) The data model which describes how the data is actually stored is ...................

  • A. logical model
  • B.internal model
  • C.external model
  • D.None of above

22) what are the different views to present a table?

  • A. Design View
  • B.Datasheet View
  • C.Pivote TableView
  • D.All of the above

23) Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

  • A. File level
  • B.Logical Level
  • C.Physical level
  • D.Conceptual level

24) Which design is both software and hardware independent?

  • A. Logical
  • B.Physical
  • C.Conceptual
  • D.All of the above

25) A level that describes how a record is stored.

  • A. View
  • B.User
  • C.Logical
  • D.Physical

26) The relational model is hardware-dependent and software-independent.

  • A. True
  • B.False

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.