Question # 1

Which of the following is not a feature of TRANSACTION?

Choose an answer

Users should be able to regard the execution of each transaction as atomic

Each transaction, run by itself

must preserve the consistency of the database

dependant on other concurrent transactions

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.

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

Identify the correct statement.

Choose an answer

Referential integrity constraints check whether the primary key values are unique

Referential integrity constraints check whether an attribute value lies in the given range

Referential integrity constraints are specified between entities having recursive relationships

When Referential integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

Which of the following constraints enforces referential integrity?

Choose an answer

FOREIGN KEY

CHECK

PRIMARY KEY

UNIQUE

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?

Choose an answer

6

9

5

4

Incase of Context-level Diagram, the system is represented by

Select correct option:

Choose an answer

One process atleast

Two processes atleast

One process only

Any number of processes

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 is true about DELETE command?

Choose an answer

is DDL Command

Resets identity of the table

cannot activate a trigger

Can be Rolled back

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Choose an answer

strong

weak

business

relationship

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