Time Left - 10:00 mins
ISRO Exam CS 2017 Daily Topic Quiz Database (Tuple Calculus / SQL /FO)
Attempt now to get your rank among 455 students!
Question 1
Consider the following relational query on the above database:
Assume that relations corresponding to the above schema are not empty . Which of the following is the correct interpretation of the above query ?
Assume that relations corresponding to the above schema are not empty . Which of the following is the correct interpretation of the above query ?
Question 2
Consider the following schema:
Emp (Empcode, Name, Sex, Salary, Deptt)
A simple SQL query is executed as follows:
SELECT Deptt FROM Emp
WHERE sex =’M’
GROUP by Dept
Having avg (Salary) >{select avg (Salary)from Emp}
The output will be
Emp (Empcode, Name, Sex, Salary, Deptt)
A simple SQL query is executed as follows:
SELECT Deptt FROM Emp
WHERE sex =’M’
GROUP by Dept
Having avg (Salary) >{select avg (Salary)from Emp}
The output will be
Question 3
The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list?
select title
from book as B
where (select count(*)
from book as T
where T.price > B.price) < 5
select title
from book as B
where (select count(*)
from book as T
where T.price > B.price) < 5
Question 4
Given the relations
Employee (name, salary, deptno) and
Department (deptno, deptname, address)
Which of the following queries cannot be expressed using the basic relational algebra
operations (U, -, x, π, σ, p)?
Employee (name, salary, deptno) and
Department (deptno, deptname, address)
Which of the following queries cannot be expressed using the basic relational algebra
operations (U, -, x, π, σ, p)?
Question 5
Which operation is used to extract Specified columns from a table?
Question 6
Which commands are use to control access over objects in relational database?
Question 7
The join operation can be defined as
Question 8
Skolmization is the process of
Question 9
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by
Question 10
Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?
(a) 2-phase Locking
(b) Time stamp - ordering
(a) 2-phase Locking
(b) Time stamp - ordering
- 455 attempts
- 5 upvotes
- 18 comments
Tags :
GATE & PSU CSDatabasesMar 23GATE & PSU CS
