Question # 1

In SQL queries, while creating tables or relations in database, key columns may be specified by

Choose an answer

Data type

Null

Not Null

Owner

Select the correct statement among the following

Choose an answer

When different entity types participate only once in a single relationship type it is called a recursive relationship

Role names are not technically necessary in relationship types when all the participating entity types are distinct

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship .

Identify the factor which enforces a relation in 3NF?

Choose an answer

Every non-key attribute is fully functionally dependent on primary key

Every non-key attribute is partially dependent on super key

The domain of attribute must include only atomic values.

Every non-key attribute is non-transitively dependent on primary key.

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

Choose an answer

12

9

16

7

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

Choose an answer

Database

Schema

None of the above

Relation

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values.

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

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 are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

Choose an answer

User accessible catalog

Data processing

Authorization service

Recovery service

Which of following is not the feature of Indexes?

Choose an answer

consume storage space

must be refreshed when the data in their master tables changes

improve the performance of SQL execution when they are used for query rewrites

can be accessed directly using a SELECT statement

Identify which of the above statements is/are correct.

Choose an answer

Only A

Only B

Only B and C

Only A and B

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