Question # 1

Which of the following statements is true about the views?

Choose an answer

view is always a complete set of all the tables in a database

View can not be used for retrieving data

The results of using a view are not permanently stored in the database.

Rows can not be updated or deleted in the view

Consider a transaction which includes following operations Z= Z + 10 Write Z ... Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be What does Z reflects in the above entry?

Choose an answer

Object being updated

Identity of the transaction

Object value

Identity of the next transaction to be executed

A ____ relationship exists when an association is maintained within a single entity.

Choose an answer

unary

ternary

binary

weak

Which key word is available in SQL to enforce referential integrity?

Choose an answer

Check

Primary Key

Set Default

Unique

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

An entity type is

Choose an answer

defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

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;

Identify the constraint that limits the values that can be placed in a column.

Choose an answer

NOT NULL

CHECK

FOREIGN KEY

UNIQUE

Incase of Context-level Diagram, the system is represented by

Select correct option:

Choose an answer

One process atleast

Two processes atleast

One process only

Any number of processes

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

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