Question # 1

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

Which of the following is not true with respect to denormalization ?

Choose an answer

A denormalized data model is not the same as a data model that has not been normalized

Denormalization takes place before the normalization process

It is an attempt to optimize the performance of database

Denormalization process can not be initiated before the Database design

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 concept is applicable with respect to 2NF?

Choose an answer

Non-transitive dependency

Full functional dependency

Partial dependency

Transitive dependency

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

Choose an answer

ALTER

HAVING

SELECT

THEN

Which of following is not the feature of Indexes?

Choose an answer

consume storage space

must be refreshed when the data in their master tables changes

improve the performance of SQL execution when they are used for query rewrites

can be accessed directly using a SELECT statement

Identify the correct statement about ANSI/SPARC architecture.

Choose an answer

The external level is not concerned with individual user perceptions

The internal level, in a database system, will always be relational

Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas.

A data definition language is used to define the internal schema

A collection of concepts that can be used to describe the structure of a database

Choose an answer

Database

DBMS

Data model

Data

Which of the following is NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

Identify the correct statement.

Choose an answer

Referential integrity constraints check whether the primary key values are unique

Referential integrity constraints check whether an attribute value lies in the given range

Referential integrity constraints are specified between entities having recursive relationships

When Referential 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 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

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