Question # 1

Which of the following is a correct way of selecting all the columns from a table called PERSONS?

Choose an answer

SELECT FROM * Persons

SELECT * FROM Persons

SELECT * WHERE Persons

SELECT WHERE * Persons

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

What is the maximum limit of keys in context with Indexed sequential files?

Choose an answer

7

255

1

235

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

ALTER TABLE exams

RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

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

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

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

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

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