Question # 1

Which of the following is NOT a component of a DFD? Select correct option:

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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

Identify the constraint that limits the values that can be placed in a column.

Choose an answer

NOT NULL

CHECK

FOREIGN KEY

UNIQUE

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

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Choose an answer

primary key

foreign key

index

determinant

A collection of related data is

Choose an answer

Logical model

Database

Data

Relational model

A database system allows the following EXCEPT

Choose an answer

management and control of data towards an efficient working of an organisation

more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased.

any user to access all its data

integration of data across multiple applications into a single application.

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

Choose an answer

True

False

Not Sure

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.

Laser records data by burning microscopic holes in the surface of the disk with a

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

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