Q. Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 :

SQ1 : Select *
From R Full Join S
On R.B=S.B;
SQ2 : Select *
From R Inner Join S
On R.B=S.B;

The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by :

View solution

Q. Consider the following three SQL queries (Assume the data in the people table) :

(a) Select Name from people where Age>21;
(b) Select Name from people where Height>180;
(c) Select Name from people where (Age>21) or (Height>180);

If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ?

View solution

Q. Manager's salary details are hidden from the employee. This is called as

View solution

Q. Which of the following statements is false ?

View solution

Q. A clustering index is created when ................

View solution

Q. Let R ={A, B, C, D, E, F} be a relation schema with the following dependencies C→F,E→A,EC→D,A→B
Which of the following is a key for R ?

View solution

Q. Match the following:

List-I                                          List-II
a. DDL                                        i. LOCK TABLE
b. DML                                       ii. COMMIT
c. TCL                                        iii. Natural Difference
d. BINARY Operation             iv. REVOKE

​Codes:
      a    b    c    d

View solution

Q. The student marks should not be greater than 100. This is

View solution

Q. Usage of Preemption and Transaction Rollback prevents ..................

View solution

Q. Views are useful for ................. unwanted information, and for collecting together information from more than one relation into a single view.

View solution

Q. Cross_tab displays permit users to view ................ of multidimensional data at a time.

View solution

Q. Thoma’s-write rule is .................

View solution

Q. .................. constraints ensure that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.

View solution

Q. The SQL expression

Select distinct T, branch_name from branch T, branch S where T.assets>S.assets and S.branch_city=”Mumbai”

finds the names of

View solution

Q. Consider the following schemas :

Branch_Schema = (branch_name, assets, city)
Customer_Schema = (cutstomer_name, street, city)
Deposit_Schema = (branch_name, account_number, customer_name, balance)
Borrow_Schema = (branch_name, loan_number, customer_name, amount)

Which of the following tuple relational calculus finds all customers who have loan amount more than Rs 12,000 ?

View solution

Q. Match the following :

(a) Create          (i) The E-R Model
(b) Select           (ii) Relationship Model
(c) Rectangle    (iii) DDL
(d) Record         (iv) DML

Codes :
      (a)   (b)  (c)  (d)

View solution

Q. Which of the following is not a type of Database Management System?

View solution

Q. Manager's salary details are to be hidden from Employee Table. This Technique is called as

View solution

Q. A Network Schema

View solution

Q. Which normal form is considered as adequate for usual database design?

View solution