adplus-dvertising
frame-decoration

Question

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 :

a.

2 and 6 respectively

b.

6 and 2 respectively

c.

2 and 4 respectively

d.

4 and 2 respectively

Answer: (d).4 and 2 respectively

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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...

Similar Questions

Discover Related MCQs

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) ?

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

Q. Which of the following statements is false ?

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

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 ?

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

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

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

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

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

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

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.

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

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 ?

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)

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

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

Q. A Network Schema

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

Q. If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of