Question # 1

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.

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

Which of the following is not true about relational tables?

Choose an answer

Column values are of the same kind

Each row is unique

Each column must have a unique name.

The sequence of rows is significant.

In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?

Choose an answer

StudentID

StudentID, CourseID

StudentID, CourseID, InstructorID

StudentID, CourseSectionID

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Choose an answer

primary key

foreign key

index

determinant

If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?

Choose an answer

If (X, Z) -> Y then X -> Y and Z -> Y.

If X -> Y and X -> Z then X -> (Y, Z)

If XY then Y -> X

If X -> Y then (X, Z) -> (Y,W).

Materialized views and Indexes are NOT similar by the following way(s).

Choose an answer

hey consume storage space

They must be refreshed when the data in their master tables changes

They can be accessed directly using a SELECT statement

All of the Given

Browser based forms are developed in the following tools EXCEPT

Choose an answer

HTML

Scripting language

Front Page

Web-based Forms

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

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