DBMS UNIT 5

The log is a sequence of _________ recording all the update activities in the database.

• Log records

• Records

• Entries

• Redo

In the ___________ scheme, a transaction that wants to update the database first creates a complete copy of the database.

• Shadow paging

• Shadow copy

• Update log records

• All of the mentioned

The actions which are played in the order while recording it is called ______________ history.

• Redo

• Replay

• Repeating

• Undo

Which of the following is not a recovery techni Data about data is normally termed as

• Directory

• Data bank

• Meta data

• None of the above

Collection of information stored in a database at a particular moment is

• View

• Schema

• Instance

• None of the above

In a hierarchical database, a hashing function is used to locate the

• Root

• Collisions

• Primary key

• Duplicate records

Which one of the following design is both software and hardware independent ?

• Logical

• Physical

• Conceptual

• None of the above

Which one is lowest level data model ?

• Physical data model

• Logical data model

• External data model

• None of the above

Data items grouped together for storage purposes are called a ?

• Record

• Title

• List

• String

Which is not a DBMS package?

• Unify

• Ingress

• IDMS

• All are DBMS packages