ISRO Scientist/Engineer Question Paper Computer Science 2013

21. Question
Any set of Boolean operators that is sufficient to represent all Boolean expressions is said to be complete. Which of the following is not complete?




Answer
22. Question
Which of the following is the highest isolation level in transaction management?




Answer
23. Question
Consider the following relational schema:
Suppliers (sid:integer, sname:string, saddress:string)
Parts (pid:integer, pname:string, pcost:real)
Catalog (sid:integer,pid:integer,pcost:real)
What is the result of the following query?
(SELECT Catalog.pid from Suppliers, Catalog
WHERE Suppliers.sid = Catalog.pid)
MINUS
(SELECT Catalog.pid form Suppliers, Catalog
WHERE Suppliers.sname <> “sachin” and Suppliers.sid=Catalog.sid)




Answer
24. Question
Consider the following dependencies and the BOOK table in the relational database design. Determine the normal form of the given relation.
ISBN -> Title
ISBN -> Publisher
Publiser -> Address




Answer
25. Question
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




Answer