Time Left - 15:00 mins

Mission ISRO 2017 Day-23: Database Quiz -2

Attempt now to get your rank among 539 students!

Question 1

An aggregation association is drawn using which symbol?

Question 2

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 ?

Question 3

If a node has K children in B tree, then the node contains exactly________ keys.

Question 4

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

Question 5

Which of the following is aggregate function in SQL?

Question 6

Consider the following relational schema:
Suppliers (sid:inteqer, sname:strinq, saddress:strinq)
Parts (pid:inteqer, pname:strinq, pcolor:strinq)
Cataloq (sid:inteqer, pid:inteqer, pcost:real)

What is the result of the following query?

(SELECT Catalog.pid from Suppliers, CatalogWHERE Suppliers.sid = Catalog.pid)MINUS
(SELECT Catalog.pid from Suppliers, Catalog
WHERE Suppliers.sname <> ’sachin’ and Suppliers.sid = Catalog.sid)

Question 7

Which operation is used to extract Specified columns from a table?

Question 8

Which commands are use to control access over objects in relational database?

Question 9

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

Question 10

The ‘command’ used to change contents of one Databases using the contents of another Databases by linking them on a common key field is called

Question 11

A clustering index is defined on the fields which are of type_______

Question 12

Embedded pointer provides

Question 13

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

Question 14

Calculate the order of leaf (pleaf) and non leaf (p) nodes of a B+tree based on the information given below
Search key field = 12 bytes
Record pointer =10 bytes
Block pointer = 8 bytes
Block size = 1 KB

Question 15

The order of a leaf node in a B+ tree is the maximum number of (value, data record pointer) pairs it can hold. Given that the block size is 1K bytes, data record pointer is 7 bytes long, the value field is 9 bytes long and a block pointer is 6 bytes long, what is the order of the leaf node?
  • 539 attempts
  • 1 upvote
  • 9 comments
Jul 19GATE & PSU CS