Database Management System Mock Test 3

10%

Question 1 of 10

1. What are the different in triggers?

All of the mentioned

Drop, Comment

Define, Create

Insert, Update, Delete

Question 1 of 10

Question 2 of 10

2. The Rectangles divided into two parts represents

Attributes of a relationship set

Relationship set

Entity set

Primary key

Question 2 of 10

Question 3 of 10

3. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

Procedural

Structural

Fundamental

Relational

Question 3 of 10

Question 4 of 10

4. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

One-to-one

One-to-many

Many-to-one

Many-to-many

Question 4 of 10

Question 5 of 10

5. Which is a unary operation:

Generalized selection

Primitive operation

Projection operation

Selection operation

Question 5 of 10

Question 6 of 10

6. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

Derived

Multi valued

Composite

Single valued

Question 6 of 10

Question 7 of 10

Create procedure dept_count proc(in dept name varchar(20),
out d count integer)
begin
select count(*) into d count
from instructor
where instructor.dept name= dept count proc.dept name
end

Which of the following is used to call the procedure given above ?

   Declare d_count integer;
   call dept_count proc(’Physics’, d_count);

   Declare d_count; 
   call dept_count proc(’Physics’, d_count);

Declare d_count integer;

   Declare d_count integer;
   call dept_count proc(’Physics’);

Question 7 of 10

Question 8 of 10

Select ID, GPA
from student grades
order by GPA
____________;

Inorder to give only 10 rank on the whole we should use

Limit 10

Only 10

Max 10

Upto 10

Question 8 of 10

Question 9 of 10

9. Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year. The query that computes averages over the 3 preceding tuples in the specified sort order is

Select year, avg(num credits)
over (order by year rows 3 preceding)
as avg total credits
from tot credits;

Select year, avg(num credits)
over (order by year rows 3 unbounded preceding)
as avg total credits
from tot credits;

None of the mentioned

All of the mentioned

Question 9 of 10

Question 10 of 10

10. Not applicable condition can be represented in relation entry as

Blank Space

NULL

Question 10 of 10