Question # 1

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

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

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.

ALTER TABLE exams

RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

Identify the correct statement

Choose an answer

Entity integrity constraints specify that primary key values can be composite

Entity integrity constraints are specified on individual relations.

Entity integrity constraints are specified between weak entities.

When entity 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 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.

In SQL queries, while creating tables or relations in database, key columns may be specified by

Choose an answer

Data type

Null

Not Null

Owner

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 constraints enforces referential integrity?

Choose an answer

FOREIGN KEY

CHECK

PRIMARY KEY

UNIQUE

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values.

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

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

Every non-key attribute is partially dependent on super key

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.

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