Database Management System

..................... is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

C

DBMS is a collection of .............. that enables user to create and maintain a database. A) Keys B) Translators C) Program D) Language Activity

C

................ is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors

A

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

A

Data items grouped together for storage purposes are called a A) record B) title C) list D) string

A

HSAM stands for .......... A) Hierarchic Sequential Access Method B) Hierarchic Standard Access Method C) Hierarchic Sequential and Method D) Hierarchic Standard and Method

A

In an ER model, ................ is described in the database by storing its data. A) Entity B) Attribute C) Relationship D) Notation

A

Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational

A

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.

C

SQL server stores index information in the ............ system table A) systindexes B) systemindexes C) sysind D) sysindexes

D

DFD stands for A) Data Flow Document B) Data File Diagram C) Data Flow Diagram D) Non of the above

C

............. contains data assisting day to day activities of the organization. A) Control database B) Operational database C) Strategic database D) Sequential database

B

................. 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.

B

..............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

B

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

B

In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

B

Processed data is called .................... A) Raw data B) Information C) Useful data D) Source

B

.................. clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

C

.................. table store information about database or about the system. A) SQL B) Nested C) System D) None of these

C

..................... 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

C