Database Management System Practice Test 2

1. Which of the following is used to store movie and image files?

Blob

Binary

Clob

Image

2. A transaction completes its execution is said to be

Failed

Rolled back

Aborted

Committed

3. Which of the following is a basic form of grant statement?

   Grant 'privilege list'
   on 'user/role list'
   to 'relation name or view name';

   Grant 'privilege list'
   to 'user/role list'

   Grant 'privilege list'
   on 'relation name or view name'
   on 'user/role list';

   Grant 'privilege list'
   on 'relation name or view name'
   to 'user/role list';

Create function dept count(dept_name varchar(20))
begin
declare d count integer;
select count(*) into d count
from instructor
where instructor.dept_name= dept_name
return d count;
end

Find the error in the the above statement.

Reference relation is not mentioned

Return type missing

Dept_name is mismatched

All of the mentioned

5. Consider the two relations instructor and department
Instructor:

ID	Name	Dept_name	Salary
1001	Ted	Finance	10000
1002	Bob	Music	20000
1003	Ron	Physics	50000

Department:

Dept_name	Building	Budget
Biology	Watson	40000
Chemistry	Painter	30000
Music	Taylor	50000

Which of the following is used to create view for these relations together?

Create view instructor_info 
select ID, name, building
from instructor, department;

Create view instructor_info as
select ID, name, building
from instructor, department
where instructor.dept name= department.dept name;

Create view instructor_info as
select ID, name, building
from department;

Create view instructor_info as
select ID, name, building
from instructor;

6. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

Group by, where

Having, where

Where, having

Group by, having

Create table Manager(ID numeric,Name varchar(20),budget numeric,Details varchar(30));

Inorder to ensure that the value of budget is non-negative which of the following should be used?

Alter(budget<0)

Alter(budget>0)

Check(budget>0)

Check(budget<0)

8. Which of the following can be addressed by enforcing a referential integrity constraint?

Information on the customer must be known before anything can be sold to that customer

When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

9. Which of the following is used to access large objects from a database ?

getClob()

all of the mentioned

getBlob()

setBlob()

10. How can you find rows that do not match some specified condition?

NOT EXISTS

None of the mentioned

Double use of NOT EXISTS

EXISTS