Question # 1

Which of the following gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

While recovering data, which of the following files does a recovery manager examines at first?

Choose an answer

A system file

Log file

Data dictionary

Metadata

Structural constraints of a relationship type refer to

Choose an answer

identifying the owner entity type relevant to a given entity type

whether the existence of an entity depends on it being related to another entity via the relationship type.

the role that a participating entity from the entity type plays in each relationship instance

the constraints applicable in granting access to tables, columns and views in a database schema.

Which of the following is true about relational schema?

Choose an answer

The sequence of columns is significant

The sequence of rows is significant.

Contains only derived attributes.

Values are atomic

_______ records data by burning microscopic holes in the surface of the disk with a laser.

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

Identify which of the above statements is/are correct.

Choose an answer

Only A

Only B

Only B and C

Only A and B

Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type: Select the correct statement among the following on the above diagram

Choose an answer

The relationship type Y is of cardinality ratio 1 : N

The diagram depicts existence dependencies

The participation of X in the Y relationship type is total

The participation of Z in the Y relationship type is partial.

Which of the following is used to add or drop columns in an existing table?

Choose an answer

ALTER

HAVING

SELECT

THEN

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

What is the impact of setting multiple indexes for the same key, in index sequential file

Choose an answer

Multiple indexes for the same key can not be set

It increases efficiency

It decreases efficiency

It will increase complexity as the access time will be increased

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