Question # 1

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

Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies. FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo FD3 : StaffNo, InterviewDate -> RoomNo 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

Select the correct statement among the following.

Choose an answer

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

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

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.

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.

Choose an answer

Text input

Report

Button

List box

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

_______ 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

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

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

Choose an answer

ALTER

HAVING

SELECT

THEN

A description on a particular collection of data using the given data model

Choose an answer

Database

Schema

None of the above

Relation

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.

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Identify which of the above statements is/are correct.

Choose an answer

Only A

Only B

Only B and C

Only A and B

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

Which of the following is not a benefit of normalization?

Choose an answer

Minimize insertion anomolies

Minimize deletion anomolies

Minimize updation anomolies

Maximize redundancy

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer