Question # 1

A ____ relationship exists when an association is maintained within a single entity.

Choose an answer

unary

ternary

binary

weak

Which of following is not the feature of Indexes?

Choose an answer

consume storage space

must be refreshed when the data in their master tables changes

improve the performance of SQL execution when they are used for query rewrites

can be accessed directly using a SELECT statement

In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

Choose an answer

1:1

1:M

M:M

Ternary

_______ 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 statements is correct with respect to the two relations given above?

Choose an answer

The two relations are not union-compatible since their attribute names differ.

The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.

To find out those students who work as instructors, it is necessary to perform the operation Student ∩ Instructor.

CS403-MIDTERM SOLVED MCQS with references by MOAAZ(2).pdf

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.

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

Identify the factor which enforces a relation in 3NF?

Choose an answer

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

Every non-key attribute is partially dependent on super key

The domain of attribute must include only atomic values.

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

_______is a control that enables users to select one option from an associated list; users can also type an option.

Choose an answer

Combo box

Button

Text box

Static area

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

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