Question # 1

_______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 the following is true about TRUNCATE?

Choose an answer

Can be Rolled back.

Activates Triggers

is DML Command.

Resets identity of the table

Which of the following is NOT a component of a DFD?

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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

Choose an answer

Atomicity

Isolation

Durability

Divergence

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.

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

Which of the following is not true regarding Indexes?

Choose an answer

Index can be defined even when there is no data in the table

It support Range selections

It can be created using ‘Create Index’ statement

It can not be created on composite attributes

An entity type is

Choose an answer

defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

_______ 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

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

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