Question # 1

Identify the correct statement with respect to normalization

Choose an answer

Normalization is a formal technique that can be used only at the starting phase of the database design

Normalization can be used as a top-down standalone database design technique

The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss? Select correct option:

Choose an answer

User accessible catalog

Data processing

Recovery service

Authorization service

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example o

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

Choose an answer

Join

Union

Cartesian Product

Set Difference

Description on particular collection of data using data model

Choose an answer

Schema

Relation

Data base

None of the above

Which of the following SQL keywords is not used with DDL statements?

Choose an answer

Table

Update

Create

Alter

The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype

Choose an answer

specialization

uniqueness

inheritance

completeness

_______ 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

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

Choose an answer

ALTER

HAVING

SELECT

THEN

Which key word is available in SQL to enforce referential integrity?

Choose an answer

Check

Primary Key

Set Default

Unique

A superkey that does not contain a subset of attributes that is itself a superkey is called a ___

Choose an answer

candidate key

primary key

superkey

secondary key

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