Question # 1

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24

32

12

16

A software package designed to store and manage databases

Choose an answer

Database

DBMS

Data model

Data

Which of the following concept is applicable with respect to 2NF?

Choose an answer

Non-transitive dependency

Full functional dependency

Partial dependency

Transitive dependency

_______ 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

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 correct with respect to the two relations given above?

Choose an answer

The two relations are not union-compatible since their attribute names differ.

The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.

To find out those students who work as instructors, it is necessary to perform the operation Student ∩ Instructor.

CS403-MIDTERM SOLVED MCQS with references by MOAAZ(2).pdf

Which of the following is not true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

Incase of Context-level Diagram, the system is represented by

Select correct option:

Choose an answer

One process atleast

Two processes atleast

One process only

Any number of processes

What is the alternate name of Data Dictionary?

Choose an answer

Index

Metadata

Data

System Catalog

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

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