adplus-dvertising
frame-decoration

Question

Consider the following three tables R, S and T. In this question, all the join operations are natural joins (⨝). (π) is the projection operation of a relation. Possible answer tables for this question are also given as below.
What is the resulting table of πA,B(R⨝T) ⨝ πB,C(S⨝T) ?

a.

(a)

b.

(b)

c.

(c)

d.

(d)

Answer: (a).(a)

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Consider the following three tables R, S and T. In this question, all the join operations are natural joins (⨝). (π) is the projection operation of a relation. Possible answer...

Similar Questions

Discover Related MCQs

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

Q. Given an open address hash table with load factor a < 1, the expected number of probes in a successful search is