Question # 1

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

Select the correct statement among the following.

Choose an answer

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

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

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.

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.

Which of the following is not a benefit of normalization?

Choose an answer

Minimize insertion anomolies

Minimize deletion anomolies

Minimize updation anomolies

Maximize redundancy

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

Choose an answer

SELECT * FROM CUST WHERE last_name='ALI';

SELECT * FROM CUST WHERE last_name=ALI;

SELECT * FROM CUSTOMER WHERE name=ALI;

SELECT * FROM CUSTOMER WHERE last_name=ALI;

In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?

Choose an answer

StudentID

StudentID, CourseID

StudentID, CourseID, InstructorID

StudentID, CourseSectionID

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).

Which of the following is a feature of PRIMARY KEY constraint?

Choose an answer

unique identifier for a row within a database table.

allow any actions that would destroy links between tables

limit the values that can be placed in a column.

enforces that the column will only accept null values.

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

Choose an answer

candidate key

primary key

superkey

secondary key

Which of the following should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

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

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