M

Mr. Dubey • 52.30K Points
Coach 

Q. Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow)

(A) Selects all tuples from the Cartesian product of book and borrow
(B) Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
(C) Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
(D) Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009
Correct : Option (B)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. The assembler stores the object code in

Q. If a developer of ASP.NET defines style information in a common location. Then that location is called as

Q. The additional duplicate register used in ARM machines are called as

Q. Identify the error in the section relation

Q. AES is at least 6-times faster than 3-DES.

Q. What defines the restrictions on employees such as usage?

Q. If processes p and q both receive messages m and m', then p receives m before m' if and only if q receives m before m'.The order delivery is called

Q. __________ is used for encrypting data at network level

Q. __________entity does not have a value for an attribute.

Q. The first line of HTTP request message is called ____