Question # 1

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

Choose an answer

Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.

Grant permission to Hiruni in order to grant, select and update permission to Amali.

Grant permission to Amali & Hiruni to update designation of employees in the Employee table

Grant permission to Amali and Hiruni to update all data except designation in Employee table

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

Which of the following is not true regarding Indexes?

Choose an answer

Index can be defined even when there is no data in the table

It support Range selections

It can be created using ‘Create Index’ statement

It can not be created on composite attributes

Which of the following is not true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

Which of the following gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

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.

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

Which of the following constraints enforces entity integrity?

Choose an answer

PRIMARY KEY

FOREIGN KEY

CHECK

NOT NULL

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

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

Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 columns in TABLE2; what is the size of the Cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24

54

6

1

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