Question # 1

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

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 statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

Which of the following is NOT a component of a DFD?

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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.

Which of the following is NOT a feature of Context DFD?

Choose an answer

one process (which represents the entire system)

all sources/sinks (external entities)

data flows linking the process to the sources and sinks (external entities)

sub-processes (which explain and decomposed the major process into small processes)

Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct

Choose an answer

Only A

Only B

B and C

A and B

Only one type of constraint can be enforced in any table by CREATE command

Choose an answer

True

False

Not Sure

Which of the following is not true about relational tables?

Choose an answer

Column values are of the same kind

Each row is unique

Each column must have a unique name.

The sequence of rows is significant.

ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct

Choose an answer

True

False

Not Sure

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

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