Q.1.

Large collections of files are called

Q.2.

Which of the following is not true of the traditional approach to information processing?

Q.3.

A data dictionary is a special file that contains

Q.4.

Embedded pointer provide

Q.5.

In SQL, which command is used to select data in rows and column from one or more tables?

Q.6.

In SQL, which command is used to add a column/integrity constraint to a table

Q.7.

In SQL, the _____ command is used to recompile a view

Q.8.

One data dictionary software package is called

Q.9.

A _____ Contains fields of data about one entity.

Q.10.

A condition that led to the development of databases was

Q.11.

A logical schema

Q.12.

Which command is used to select distinct subject (SUB) from the table (BOOK)?

Q.13.

The language used in application programs to request data from the DBMS is referred to as the

Q.14.

The index consists of

Q.15.

Batch processing is appropriate if

Q.16.

A file that is organized in uniform format is formally referred to as a _____ or a database file.

Q.17.

Which of the following is a type of DBMS software?

Q.18.

A scheme describes

Q.19.

In SQL, which command(s) is(are) used to enable/disable a database trigger?

Q.20.

A list in alphabetical order

Q.21.

One approach to standardizing storing of data

Q.22.

The _____ command is used to allocates an extent for the table in SQL

Q.23.

Queries to a database

Q.24.

The master list of an indexed file

Q.25.

What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

Q.26.

A form can be used to

Q.27.

Data items grouped together for storage purposes are called a

Q.28.

A report form

Q.29.

In a relational schema, each tuple is divided into fields called

Q.30.

If a piece of data is stored in two places in the database, then