DBMS LAB

In E-R model, Y is the dominant entity and X is subordinate entity

• If X is deleted, then Y is also deleted
• None of the above
• If Y is deleted, then X is not deleted
• If Y is deleted, then X is also deleted

An indexing operation

• Establishes an index for a file
• Sorts a file using two keys
• Sorts a file using a single key
• Both (b) and (c)

The database administrator is, in effect, the coordinator between them ____ and the ____

• Database, users
• Application program; database
• DBMS; database
• Application programs; users

A view of database that appears to an application program is known as

• Schema
• Virtual table
• Subschema
• None of these

The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the

• Sequential method
• Predetermined method
• Queuing method
• Direct access method

External database is

• Database created using DBMS package
• Database created in MS-Word
• Database created in EXCEL
• All of the above

The logical data structure with a one-to-many relationship is a

• A) Tree
• (B) Chain
• (C) Network
• (D) All of these

The following are components of a database except _____

• (A) reports
• (B) indexes
• (C) metadata
• (D) user data

The smallest logical data entity is called a data item or data

• (A) Field
• (B) Collection
• (C) Base
• (D) Bank

A DBMS makes it possible for users to:-

• CREATE
• UPDATE
• DELETE
• ALL THE ABOVE