Tuesday, 20 March 2012

DBMS MCQ 08


Introduction to Database MCQ
1.      _______refers to the basic facts and entities, such as names and numbers.

a.       Data
b.      Information
c.       Input
d.      Output

2.      Information is processed from __________

a.       Output
b.      Data
c.       Memory
d.      None of these

3.      MIS stands for:
a.       Management Information Server
b.      Management Information Service
c.       Management Information System
d.      Master Information System
4.      Which is the false statement:
a.       A database is ordered collection of data.
b.      A database is systematic compilation of records in a computer.
c.       DBMS manages the database
d.      Data helps in making decisions.
5.      Which is the data model

a.       Relational
b.      Object-Relational
c.       Network
d.      All of these

6.      Which is not the feature of database:

a.      Data redundancy
b.      Independence
c.       Flexibility
d.      Data Integrity

7.      Which is the type of data independence:

a.       Physical data independence
b.      Logical data independence
c.       Both
d.      None of these

8.      Which is the feature of database:

a.       Query Language
b.      Multi user access
c.       Data Dictionary
d.      All of these

9.      Which is the advantage of database:

a.       Prevents Data redundancy
b.      Restricts unauthorized access
c.       Persistent storage
d.      Backup and recovery
e.       Integrity Constraints
f.        All of these

10.  Which is the database language:

a.       C
b.      C++
c.       SQL
d.      None of these

11.  Which person is responsible for overall activities for database:

a.       Database designer
b.      Database analyst
c.       Database Administrator
d.      Database manager

12.  Which level of database is viewed by user:

a.       Internal level
b.      External Level
c.       Conceptual Level
d.      All of these



13.  Internal level has:
a.       Individual Users View of the database
b.      Community view of the database
c.       Physical Representation of the database
d.      All of these
14.  Which is the component of database management system:

a.       Query Language
b.      Database Manager
c.       File manager
d.      All of these

15.  ______is the structure of the database.

a.       Table
b.      Relation
c.       Schema
d.      None of these

16.  Schema is usually stored in____________.

a.       Tables
b.      Data Dictionary
c.       Both
d.      None of these

17.  Schema is defined by:

a.       DML
b.      DDL
c.       DCL
d.      DQL

18.   DML language is used to:

a.       Define schema
b.      Define internal level
c.       Access Data
d.      All of these

19.  DBMS is the bridge between operating system and ___________.

a.       User
b.      Database administrator
c.       Application program
d.      None of these

20.  Which is the most popular database model:

a.       Network Model
b.      Relational Model
c.       Hierarchical Model
d.      Object Oriented

21.  Which is the schema object:

a.       Database links and clusters
b.      Packages and Indexes
c.       Procedures and functions
d.      All of these

22.  In database records are called:

a.       Attributes
b.      Entity
c.       Tuples
d.      Relations

23.  An entity has a set of ___________ that describe it.

a.      Attributes
b.      Entity
c.       Tuples
d.      Relations

24.  In ER model rectangle represents:

a.       Attributes
b.      Entity set
c.       Relationships
d.      None of these

25.  Date is the type of attribute:

a.       Simple
b.      Composite
c.       Single values
d.      Multi valued

26.  __________is the attribute or group of attributes that uniquely identify occurrence of each entity.

a.       Foreign key
b.      Super Key
c.       Primary Key
d.      All of these


27.   _________is the real world object, such as a person, place etc.

a.       Attribute
b.      Entity
c.       Records
d.      All of these

28.  Grant and revoke is the type of command:

a.       DDL
b.      DML
c.       DCL
d.      DQL

29.  A user that manages the files of application in DBMS is called:

a.       Administrator
b.      Database analyst
c.       File Manager
d.      None of these

30.  ________is the information about data.

a.       Data
b.      Meta-Data
c.       Entity
d.      Relations


1 comment :

  1. Very nice: Great tutorial: even you can play quiz on database: click here

    ReplyDelete