Question # 1

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.

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 .

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Identify the correct statement with respect to normalization

Choose an answer

Normalization is a formal technique that can be used only at the starting phase of the database design

Normalization can be used as a top-down standalone database design technique

The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.

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.

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 feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss? Select correct option:

Choose an answer

User accessible catalog

Data processing

Recovery service

Authorization service

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

Choose an answer

Join

Union

Cartesian Product

Set Difference

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

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

A super key that does not contain a subset of attributes that is itself a super key is called a ____.

Choose an answer

candidate key

primary key

superkey

secondary key

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