Question # 1

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values.

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

Which of the following is the correct description of cache hit?

Choose an answer

When data is found in the cache

When data is removed in the cache

The number of times the cache is accessed directly by the processor

When data is lost from the cache

Which of the following is CORRECT about database management system's languages?

Choose an answer

Data definition languages are used to specify the conceptual schema only.

Data manipulation languages are used to create the databases

Data manipulation languages are used for retrieval, insertion, deletion and modification of data

Data definition langauges are only used to update data in the DBMS.

Which of the following should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

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

You can’t modify more than one table at a time through a view.

Choose an answer

True

False

Not Sure

Which of the following is not a type of user interface?

Choose an answer

Graphical User Interface (GUI)

Forms

DB tables

Text based

Identify the advantage of DELETE command over TRUNCATE.

Choose an answer

Can be Rolled back

is DDL Command.

cannot activate a trigger.

faster and uses fewer system

A collection of related data is

Choose an answer

Logical model

Database

Data

Relational model

Only one type of constraint can be enforced in any table by CREATE command

Choose an answer

True

False

Not Sure

Which of the following is correct?

Choose an answer

The relation Interview is in 3NF

The relation Interview is in BCNF.

The FD3 violates 3NF.

The FD2 violates 2NF

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