Question # 1

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?

Choose an answer

6

9

5

4

Which of the following is true for the relational model?

Choose an answer

Degree of a relation is the number of rows in a relation

Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown

Complex key is a key consisting of more than one attribute.

Constraint is a rule that restricts the values in a database.

Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965?

Choose an answer

SELECT * FROM WORKER WHERE joining_Year>1965;

SELECT * FROM WORKER WHERE joining_Year>'1965';

SELECT * FROM WORKER AND joining_Year>'1965';

SELECT * WHERE joining_Year>1965;

Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type: Select the correct statement among the following on the above diagram

Choose an answer

The relationship type Y is of cardinality ratio 1 : N

The diagram depicts existence dependencies

The participation of X in the Y relationship type is total

The participation of Z in the Y relationship type is partial.

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

Which of the following is true about DELETE command?

Choose an answer

is DDL Command

Resets identity of the table

cannot activate a trigger

Can be Rolled back

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

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.

If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?

Choose an answer

If (X, Z) -> Y then X -> Y and Z -> Y.

If X -> Y and X -> Z then X -> (Y, Z)

If XY then Y -> X

If X -> Y then (X, Z) -> (Y,W).

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

Which of the following is a correct way to implement one-to-many relationship while designing tables?

Choose an answer

by splitting the data into two tables with primary key and foreign key relationships

using a junction table with the keys from both the tables forming the composite primary key of the junction table.

by splitting each table into three

as a single table and rarely as two tables with primary and foreign key relationships

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