Set-1 DBMS

DATABASE MANAGEMENT SYSTEM

NOTE: Here are some of the Multiple Choice Questions that are helpful to the Student for the Campus Recruitment Training, UGC-NET, GATE, TET, and many more Competitive Exams.

1. DBA stands for:

a.       Database associated

b.      Database administrator

c.       Database application

d.      None of these

2.      DBMS stands for:

a.       Database associated

b.      Database administrator

c.       Database application

d.      Database management system

3.      Which means a place where data can be stored in a structured manner:

a.       CPU

b.      Database

c.       ALU

d.      All of these

4.      A database is a complex ______:

a.       Data structure

b.      Memory

c.       Both

d.      None

5.      The set of data available to the user, the so-called:

a.       Start-user data

b.      End-user data

c.       Database

d.      None of these

6.      How is describing the end-user data:

a.       Memory

b.      CPU

c.       ALU

d.      Data

7.      DBMS is to impose a logical and structured organization on:

a.       Register

b.      Data

c.       Memory

d.      None of these

8.      How many basic operation performed in DBMS:

a.       1

b.      2

c.       3

d.      4

9.      Basic operation performed in DBMS are:

a.       Management of data in the database

b.      Management of user associated with database

c.       Both

d.      None

10.  _____is a collection of programs performing all necessary action associated with a database:

a.       Database associated

b.      Database administrator

c.       Database application

d.      Database management system

11.  _______is a program or set of program that interacts with the database at some point in its execution:

a.       A database system

b.      A database application

c.       Both

d.      None

12.  ________is a collection of application programs that interacts with the database along with DBMS:

a.       A database system

b.      A database application

c.       Both

d.      None

13.  In which services the processes of database management and data management are complementary:

a.       Database associated

b.      Database administrator

c.       Database application

d.      Database management system

14.  ACID stands for:

a.       Atomicity, consistency, isolation, and durability

b.      Atomicity, command, integrity, and data

c.       Atomicity, control, integrated, and direct

d.      None of these

15.  A DBMS provides users with the conceptual representation of:

a.       Register

b.      Data

c.       Logical view

d.      Physical view

16.  Which structure of data clearly is one of the main features of the database approach:

a.       Logical view

b.      Physical view

c.       Both

d.      None

17.  A _____view of data expresses the way a user thinks about data

a.       Logical view

b.      Physical view

c.       Both

d.      None

18. A physical view of data refers to the way data is handled at a_____ its storage and retrieval:

1. High level
2. Low level
3. Medium level
4. All of these
18. In logical and physical view of data the set of principles that defines a data model may be divided into how many parts:

1. 1
2. 2
3. 3
4. 4

20.  In logical and physical view of data the set of principles that defines a data model may be divided into which part:

a.       Data definition

b.      Data manipulation

c.       Data integrity

d.      All of these

21.  The overall description of a database is called______:

a.       Data definition

b.      Data manipulation

c.       Data integrity

d.      Database schema

22.  Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:

a.       Schema

b.      Subschema

c.       Non-schema

d.      None-subschema

23.  A data dictionary is a repository that manages _____:

a.       Database

b.      Memory

c.       Metadata

d.      All of these

24.  Which languages are used to define and query a database:

a.      Database

b.      Memory

c.       Metadata

d.      All of these

25.  DDL stand for:

a.      Data definition language

b.      Data description languages

c.       Data design languages

d.      Database dictionary languages

26.  Which are the not most frequently used DDL statements:

a.       CREATE

b.      DROP

c.       ALTER

d.      None of these

27.  VDL stand for:

a.       View data languages

b.      View design languages

c.       View definition languages

d.      View done languages

28.  SDL stands for

a.       Stand definition languages

b.      Storage definition languages

c.       Select definition languages

d.      system definition languages

29.  The DDL is used to specify the_____:

a.      Conceptual schemas

b.      Internal schemas

c.       Both

d.      None

30.  The  SDL is used to specify the_______:

a.       Conceptual schemas

b.      Internal schemas

c.       Both

d.      None

31.  DML stands for:

a.       Data description languages

b.      Data design languages

c.       Database dictionary languages

d.      Data manipulation languages

32.  Which is used for data retrieval from the database:

a.       DDL

b.      DML

c.       SDL

d.      VDL

33.  Which is used to specify the user views and their mappings to the conceptual schema:

a.       DDL

b.      DML

c.       SDL

d.      VDL

34.  How many types of DML:

a.       1

b.      2

c.       3

d.      4

35.  What are the types of DML:

a.       Low level

b.      High level

c.       Procedural DML

d.      All of these