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

Identify the INCORRECT statement among the given.

Choose an answer

An entity may be an object with a physical existence like a car, a house or an Employee

One cannot consider something which has conceptual existence like a course in a degree program as an entity

Age can be considered as a single value attribute of a person.

An entity type describes the schema or intension for a set of entities which share the same structure.

In SQL queries, while creating tables or relations in database, key columns may be specified by

Choose an answer

Data type

Null

Not Null

Owner

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

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

Choose an answer

NOT NULL

CHECK

FOREIGN KEY

UNIQUE

Which of the following will be deleted relating to a table if you use TRUNCATE command?

Choose an answer

all rows in a table

indexes

table structure and its columns

constraints

ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

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.

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

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 Amali & Hiruni to retrieve data from Employee table

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

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

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