Question # 1

A relation (from the relational database model) consists of a set of tuples, which implies th

Choose an answer

Relational model supports multi-valued attributes whose values can be represented in sets.

for any two tuples, the values associated with all of their attributes may be the same

for any two tuples, the values associated with one or more of their attributes must differ.

all tuples in a particular relation may have different attributes.

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 following is NOT generally the aim of data partitioning and placement of data?

Choose an answer

Reduce Workload

Balance Workload

Merging different relations

Speed up rate of useful works.

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

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

Choose an answer

Database

Schema

None of the above

Relation

The Entity Relation Model models

Choose an answer

Entities, Relationships and Processes

Entities and Relationships

Relationships

Entities

A ______ is used to maintain a connection between the users of the database system.

Choose an answer

Mail server

File Server

Client-serve

None of the given.

Which of the following is NOT a feature of HASH ACCESS?

Choose an answer

indexes to search or maintain

Very fast direct access

Inefficient sequential access

Use when direct access is needed, but sequential access is not.

Which of the following concepts is applicable with respect to 3NF

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Partial functional dependency

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

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