Call Support +91-85588-96644
TCYonline

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Please enter your name
Please enter your mobile number
You can't leave Captcha Code empty
By submitting this form, you agree to the Terms & Privacy Policy.
OR

Sign Up via Facebook

Sign Up via Google

Sign Up via Twitter

Download Software
Tests given

Download TCY App

App Image

Consider the relations r(A, B) and s (B, C), where s.B is a primary key and r.B is a foreign key referencing s. B. Consider the query
Q : r

Let LOJ denote the natural left outer-join operation. Assume that r and s contain no null values. Which one of the following queries is NOT equivalent to Q?

 
(r s)
(rLOJs)
rLOJ
(r)LOJs

Reply


Please type your answer before submitting.
Submit

There is some mistake in question. Consider the relations r(A, B) and s(B, C), where s.B is a primary key and r.B is a foreign key referencing s.B. Consider the query Q: r⋈(σB<5(s)) Let LOJ denote the natural left outer-join operation. Assume that r and s contain no null values. Which one of the following is NOT equivalent to Q? (A) σB<5(r ⋈ s) (B) σB<5(r LOJ s) (C) r LOJ (σB<5(s)) (D) σB<5(r)LOJ s