Time Left - 05:00 mins
NIELIT 2017 Quiz-15 (Database)
Attempt now to get your rank among 568 students!
Question 1
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)
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 2
Which commands are use to control access over objects in relational database?
Question 3
A view of a database that appears to an application program is known as
Question 4
The maximum number of super keys for the relation schema R (E, F, G, H) with E as the key is ______.
Question 5
SELECT operation in SQL is equivalent to?
- 568 attempts
- 7 upvotes
- 13 comments
Tags :
GATE & PSU CSDatabasesSep 26GATE & PSU CS
