Question # 1

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

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?

Choose an answer

6

9

5

4

Laser records data by burning microscopic holes in the surface of the disk with a

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

The information regarding ‘views’ and ‘Integrity constraints’ are found in

Choose an answer

Both Data Dictionary and System Catalog

System Catalog

Data Dictionary

Indexes

Which of the following is correct?

Choose an answer

The relation Interview is in 3NF

The relation Interview is in BCNF.

The FD3 violates 3NF.

The FD2 violates 2NF

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

_______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 SQL keywords is not used with DDL statements?

Choose an answer

Table

Update

Create

Alter

Which of the following will be deleted relating to a table if you use TRUNCATE command?

Choose an answer

all rows in a table

indexes

table structure and its columns

constraints

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

Select the correct statement among the following

Choose an answer

When different entity types participate only once in a single relationship type it is called a recursive relationship

Role names are not technically necessary in relationship types when all the participating entity types are distinct

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship .

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