The most recently accessed data from the disk (as well as adjacent sectors) is stored in a ----------------------.

• A) Memory buffer
• B) EPROM
• C) ROM
• D) hard disk

The log file is also called----------------------------.

• A) Non Transaction file
• B) Temporary file
• C) hash file
• D) Transaction file

Inverted files or inversions. Linked lists. B+ Trees. these are the three implementation approaches of----------------.

• A) Sequential Access
• B) Hashing
• C) Indexes
• D) Non sequential.

When the power is turned off content of ________________ is lost.

• A) Non Volatile storage
• B) Volatile storage
• C) Hard disk storage
• D) permanent storage

Which of the following is true about creating database in MS Access?

• A) After running MS Access, create database option is selected directly.
• B) Go to the tool option of MS Access and select create Database option with suitable name.
• C) Click on the file menu, select create database option and then click it.
• D) First we will run MS Access and select New option from the file. Next it will ask the name of database.

Cache is a portion of memory made of high-speed ---------------------------------instead of the slower and cheaper----------------used for main memory.

• A) PROM,EPROM
• B) ROM, RAM
• C) RAM, ROM
• D) Static RAM (SRAM), DRAM

A ---------------index determines the storage order of data in a table.

• A) Dense
• B) Secondary
• C) Clustered
• D) Primary

Which file organization is allowed by a direct access storage device?

• A) indexed and direct only
• B) sequential, indexed and direct,
• C) sequential only
• D) Direct only

Can be defined even when there is no data in the table. Existing values are checked on execution of this command. It supports selections of form; these are the major properties of---------------------.

• A) Sequential approach
• B) Indexes
• C) Direct approach
• D) View

A memory cache, sometimes called a cache store or-------------------.

• A) Hard disk
• B) DROM
• C) RAM
• D) ROM

Following are the characteristics of _________________________.
i. No indexes to search or maintain
ii. Very fast direct access
iii. Inefficient sequential access
iv. Use when direct access is needed, but sequential access is not.

• A) Hashed Access
• B) sequential Index
• C) Index Access
• D) Non Hashed Access

The two basic types of record access methods are-------------------------------.

• A) sequential and immediate
• B) sequential and random
• C) sequential and indexed
• D) Direct and immediate

------------------types of caching are commonly used in personal computers.

• A) four
• B) five
• C) Two
• D) three

Which of the following is not related to Index sequential file structure?

• A) Track overflows and file overflow areas are ensured
• B) We choose a number of buckets to correspond to the number of search key values we will have stored in the database
• C) Records are stored in sequence and index is maintained
• D) Dense and non-dense types of indexes are maintained

The _______________ should be user friendly, Data integrity must be ensured and checks can be applied within the tables.

• A) Input forms
• B) Database
• C) Application programing
• D) computer language

The index which has some of the key value is classified as _________________.

• A) Dense index
• B) Non dense index
• C) Cluster index
• D) Linear index

In Denormalization two relations who have _________ relationship are merged into one relation.

• A) Many to one
• B) One to many
• C) One to one
• D) Many to many

We should not compromise ________ over efficiency.

• A) Query response time
• B) Accuracy
• C) Privacy
• D) Consistency

At which design level de-normalization will take place?

• A) Physical design
• B) All of the given
• C) Logical design
• D) Conceptual design

The optional items in the SQL commands are kept in______.

• A) {}
• B) []
• C) ||
• D) ()