Question # 1

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 true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

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 NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

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.

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

Choose an answer

Atomicity

Isolation

Durability

Divergence

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

Choose an answer

True

False

Not Sure

Select the correct statement among the following on proper naming of schema constructs:

Choose an answer

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.

In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.

The nouns arising from a database requirement description can be considered as names of attributes

Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

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.

How many clustered index(es) do each database table have?

Choose an answer

2

3

4

1

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