Question # 1

Which of the following functions are NOT performed by a database administrator?

Choose an answer

Planning, designing and implementing database systems

Establishing standards and procedures for database systems

Communicating with database users

Allocation of storage locations and data structures

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

Which one is true regarding relation?

Choose an answer

Every attribute value Non atomic

Attribute in table may not have unique name

table order of the column is relevant

the order of the rows is irrelevant

What is the alternate name of Data Dictionary?

Choose an answer

Index

Metadata

Data

System Catalog

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Choose an answer

primary key

foreign key

index

determinant

Identify the constraint that limits the values that can be placed in a column.

Choose an answer

NOT NULL

CHECK

FOREIGN KEY

UNIQUE

A super key that does not contain a subset of attributes that is itself a super key is called a ____.

Choose an answer

candidate key

primary key

superkey

secondary key

Which of the following is a correct way to implement one-to-many relationship while designing tables?

Choose an answer

by splitting the data into two tables with primary key and foreign key relationships

using a junction table with the keys from both the tables forming the composite primary key of the junction table.

by splitting each table into three

as a single table and rarely as two tables with primary and foreign key relationships

A relation (from the relational database model) consists of a set of tuples, which implies that

Choose an answer

all tuples in a relation must be distinct.

relational model supports multi-valued attributes whose values can be represented in sets

for any two tuples, the values associated with all of their attributes may be the same

all tuples in a particular relation may have different attributes.

Which of the following is NOT a feature of Indexed sequential files?

Choose an answer

Records are stored in sequence and index is maintained.

Dense and nondense types of indexes are maintained.

Track overflows and file overflow areas can not be ensured

Cylinder index increases the efficiency

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer