Question # 1

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

Identify the correct statement

Choose an answer

Entity integrity constraints specify that primary key values can be composite

Entity integrity constraints are specified on individual relations.

Entity integrity constraints are specified between weak entities.

When entity integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.

Which of the following is NOT a component of a DFD? Select correct option:

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

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;

A collection of concepts that can be used to describe the structure of a database

Choose an answer

Database

DBMS

Data model

Data

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 not a feature of TRANSACTION?

Choose an answer

Users should be able to regard the execution of each transaction as atomic

Each transaction, run by itself

must preserve the consistency of the database

dependant on other concurrent transactions

A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a

Choose an answer

superkey

candidate key

primary key

secondary key

Which of the following is INCORRECT about VIEWS?

Choose an answer

It is not possible to left out the data which is not required for a specific view.

A database view displays one or more database records on the same page.

Views can be used as security mechanisms

Views are generally used to focus the perception each user has of the database.

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.

Materialized views and Indexes are NOT similar by the following way(s).

Choose an answer

hey consume storage space

They must be refreshed when the data in their master tables changes

They can be accessed directly using a SELECT statement

All of the Given

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