Solved MCQ of Database Management System Set - 1
1.
DBMS is a collection of ………….. that enables user to create and maintain a
database.
A)
Keys
B)
Translators
C)
Program
D)
Language Activity
2.
In a relational schema, each tuple is divided into fields called
A)
Relations
B)
Domains
C)
Queries
D)
All of the above
3.
In an ER model, ……………. is described in the database by storing its data.
A)
Entity
B)
Attribute
C)
Relationship
D)
Notation
4.
DFD stands for
A)
Data Flow Document
B)
Data File Diagram
C)
Data Flow Diagram
D)
Non of the above
5.
A top-to-bottom relationship among the items in a database is established by a
A)
Hierarchical schema
B)
Network schema
C)
Relational Schema
D)
All of the above
6.
……………… table store information about database or about the system.
A)
SQL
B)
Nested
C)
System
D)
None of these
7.
…………..defines the structure of a relation which consists of a fixed set of
attribute-domain pairs.
A)
Instance
B)
Schema
c)
Program
D)
Super Key
8.
……………… clause is an additional filter that is applied to the result.
A)
Select
B)
Group-by
C)
Having
D)
Order by
9.
A logical schema
A)
is the entire database
B)
is a standard way of organizing information into accessible parts.
C)
Describes how data is actually stored on disk.
D)
All of the above
10.
………………… is a full form of SQL.
A)
Standard query language
B)
Sequential query language
C)
Structured query language
D)
Server side query language
11.
Processed data is called ………………..
A)
Raw data
B)
Information
C)
Useful data
D)
Source
12.
…………….. is a utility to capture a continuous record of server activity and
provide auditing capability.
A)
SQL server Profile
B)
SQL server service manager
C)
SQL server setup
D)
SQL server wizard.
13.
Data items grouped together for storage purposes are called a
A)
record
B)
title
C)
list
D)
string
14.
…………. contains data assisting day to day activities of the organization.
A)
Control database
B)
Operational database
C)
Strategic database
D)
Sequential database
15.
………………… approach reduces time and effort required for design and lesser risk in
database management.
A)
Single global database
B)
Top-down approach
C)
Multiple databases
D)
None of the above
16.
HSAM stands for ……….
A)
Hierarchic Sequential Access Method
B)
Hierarchic Standard Access Method
C)
Hierarchic Sequential and Method
D)
Hierarchic Standard and Method
17.
SQL server stores index information in the ………… system table
A)
systindexes
B)
systemindexes
C)
sysind
D)
sysindexes
18.
The one guideline to be followed while designing the database is
A)
A database design may be ambiguous.
B)
Unrelated data should be in the same table so that updating the data will be
easy.
C)
It should avoid/reduce the redundancy.
D)
An entity should not have attributes.
19.
Which of the following is not a logical database structure?
A)
Chain
B)
Network
C)
Tree
D)
Relational
20.
……………. is a preferred method for enforcing data integrity
A)
Constraints
B)
Stored procedure
C)
Triggers
D)
Cursors
Answers:
1. 1C) Program
2. 2 B) Domains
3. 3 A) Entity
4. C) Data Flow Diagram
5. A) Hierarchical schema
6. C) System
7. B) Schema
8. C) Having
9. B) is a standard …... accessible parts.
10. A) Standard query language
|
11. 11 B) Information
12. 12B) SQL server service manager
13. 13A) record
14. B) Operational database
15. C) Multiple databases
16. A) Hierarchic Sequential Access Method
17. D) sysindexes
18. C) It should avoid/reduce … redundancy.
19. A) Chain
20. A) Constraints
|
No comments:
Post a Comment