Database Management System MCQs

To identify the deleted records we use the ______________

Bitmaps can be used as a compressed storage mechanism at the leaf nodes of ________ for those values that occur very frequently.

Bitmaps can be combined with regular B+-tree indices for relations where a few attribute values are extremely common, and other values also occur, but much less frequently.

A tablespace is further broken down into ________

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

What is the purpose of the index in sql server?

How many types of indexes are there in sql server?

How non clustered index point to the data?

Which one is true about clustered index?

What is true about indexes?

Does index take space in the disk?

If an index is _________________ the metadata and statistics continue to exists

In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.

A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.

A collection of data designed to be used by different people is called a/an

Which of the following is the oldest database model?

Which of the following schemas does define a view or views of the database for particular users?

Which of the following is an attribute that can uniquely identify a row in a table?

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Which of the following terms does refer to the correctness and completeness of the data in a database?

A table can be logically connected to another table by defining a

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

Ensuring isolation property is the responsibility of the

In query processing, the ___________ is the lowest-level operator to access data.

In a ____________ the system scans each file block and tests all records to see whether they satisfy the selection condition.

Index structures are referred to as __________ since they provide a path through which data can be located and accessed.

Search algorithms that use an index are referred to as

Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.

The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is

The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.

If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by

Conjunctive selection using one index. This is

Two main measures for the efficiency of an algorithm are

The time factor when determining the efficiency of an algorithm is measured by

The space factor when determining the efficiency of an algorithm is measured by

Which of the following case does not exist in complexity theory

The Worst case occur in linear search algorithm when

The Average case occur in linear search algorithm

The complexity of a linear search algorithm is

The complexity of Binary search algorithm is

The complexity of Bubble sort algorithm is

A_____ is a query that retrieves rows from more than one table or view:

A condition is referred to as __________

Which oracle is the join condition is specified using the WHERE clause:

How many join types in join condition:

Which are the join types in join condition:

Which product is returned in a join query have no join condition:

Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

Which operation are allowed in a join view: