Question # 1

A collection of related data is

Choose an answer

Logical model

Database

Data

Relational model

_______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

An entity can be logically connected to another by defining a ____.

Choose an answer

hyperlink

common attribute

primary key

superkey

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

Which of the following statements is true about the views?

Choose an answer

view is always a complete set of all the tables in a database

View can not be used for retrieving data

The results of using a view are not permanently stored in the database.

Rows can not be updated or deleted in the view

Which key word is available in SQL to enforce referential integrity?

Choose an answer

Check

Primary Key

Set Default

Unique

Which of the following is NOT one of the ways of resolving deadlocks?

Choose an answer

Undoing all the updates made by the particular transaction which is the cause of deadlock.

A message is passed to the victim and depending on the system the transaction may or may not be started again automatically

Picking a list of all previously completed transactions and undoing all the updates.

Rollback `victim' transaction and restart it

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

Choose an answer

Join

Union

Cartesian Product

Set Difference

You can’t modify more than one table at a time through a view.

Choose an answer

True

False

Not Sure

Which one is true regarding relation?

Choose an answer

Every attribute value Non atomic

Attribute in table may not have unique name

table order of the column is relevant

the order of the rows is irrelevant

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.

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