ISRO 2018: DBMS Booster Quiz- 1

Attempt now to get your rank among 1021 students!

Question 1

What does the data dictionary identify?

• AField names
• BField formats
• CField Types
• DAll of these

Question 2

Which symbol denote derived attributes in ER Model?

• ADouble ellipse
• BDashed ellipse
• CSquared ellipse
• DEllipse with attribute name underlined

Question 3

A B-Tree used as an index for a large database table has four levels including the root node. If a new key is inserted in this index, then the maximum number of nodes that could be newly created in the process are

• A5
• B4
• C1
• D2

Question 4

An aggregation association is drawn using which symbol?

• AA line which loops back on to the same table
• BA small open diamond at the end of a line connecting two tables
• CA small closed diamond at the end of a line connecting two tables
• DA small closed triangle at the end of a line connecting two tables

Question 5

Database table by name Overtime_allowance is given below:

What is the output of the following SQL query?
select count(*) from ((select Employee, Department from Overtime_allowance) as S natural join (select Department, OT_allowance from Overtime_allowance) as T);

• A16
• B4
• C8
• DNone of the above

Question 6

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 ?

• AFind the names of all suppliers who have supplied a non-blue part
• BFind the names of all suppliers who have not supplied a non-blue part
• CFind the names of all suppliers who have supplied only non-blue parts
• DFind the names of all suppliers who have not supplied only non-blue parts

Question 7

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)

• Apid of Parts supplied by all except sachin
• Bpid of Parts supplied only by sachin
• Cpid of Parts available in catalog supplied by sachin
• Dpid of Parts available in catalogs supplied by all except scahin

Question 8

Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and, then apply a 5% interest
i. T1 start
ii. T1 B old = 12000 new = 10000
iii. T1 M old = 0 new = 2000
iv. T1 commit
v. T2 start
vi. T2 B old = 10000 new = 10500
vii. T2 commit
Suppose the database system crashed just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?

• Awe must redo log record 6 set B to 10500
• Bwe must undo log records 6 to set B to 10000 and then redo log record 2 and 3
• Cwe need not redo log records 2 and 3 because transaction T1 has committed
• Dwe can apply redo and undo operations in arbitrary order because they are idempotent

• 1021 attempts
• 5 upvotes
• 11 comments