ISRO CSE 2016 PYQ

Goals for the design of the logical scheme include

Given the relations:
employee (name, salary, dept-no), and
department (dept-no, dept-name, address),
Which of the following queries cannot be expressed using the basic relational algebra operations ($\sigma , \pi , \times , ⋈, ∪, ∩, -$)?

Trigger is

The order of a leaf node in a B+ tree is the maximum number of (value, data record pointer) pairs it can hold. Given block size = 1K bytes, data record pointer = 7 bytes, value field = 9 bytes, block pointer = 6 bytes, what is the order of the leaf node?

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