Question # 1

Which of the following constraints enforces referential integrity?

Choose an answer

FOREIGN KEY

CHECK

PRIMARY KEY

UNIQUE

Which of the following concepts is applicable with respect to 3NF

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Partial functional dependency

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

Select the correct statement about the ANSI/SPARC architecture

Choose an answer

The conceptual level is a level of indication between the internal level and the external level.

The internal level in a database system will definitely be relational.

Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.

The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.

_______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 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

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

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

Choose an answer

ALTER

HAVING

SELECT

THEN

Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct

Choose an answer

Only A

Only B

B and C

A and B

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24

32

12

16

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