Question # 1

Which of the following is true for the relational model?

Choose an answer

Degree of a relation is the number of rows in a relation

Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown

Complex key is a key consisting of more than one attribute.

Constraint is a rule that restricts the values in a database.

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

Which of the following is NOT a feature of Context DFD?

Choose an answer

one process (which represents the entire system)

all sources/sinks (external entities)

data flows linking the process to the sources and sinks (external entities)

sub-processes (which explain and decomposed the major process into small processes)

If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?

Choose an answer

If (X, Z) -> Y then X -> Y and Z -> Y.

If X -> Y and X -> Z then X -> (Y, Z)

If XY then Y -> X

If X -> Y then (X, Z) -> (Y,W).

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

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

What is the impact of setting multiple indexes for the same key, in index sequential file

Choose an answer

Multiple indexes for the same key can not be set

It increases efficiency

It decreases efficiency

It will increase complexity as the access time will be increased

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?

Choose an answer

the number of columns in the first table multiplied by the number of columns in the second table.

the number of columns in the first table multiplied by the number of rows in the second table

the number of rows in the first table multiplied by the number of columns in the first table

the number of rows in the first table multiplied by the number of rows in the second table

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

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