Database Questions and Answers

This set of Database Questions & Answers focuses on “Join Operations – 2”

1. A_____ is a query that retrieves rows from more than one table or view:
a) Start
b) End
c) Join
d) All of the mentioned

2.Which product is returned in a join query have no join condition:
a) Equijoins
b) Cartesian
c) Both
d) None of the mentioned

3.Which is a join condition contains an equality operator:
a) Equijoins
b) Cartesian
c) Both and b
d) None of the mentioned

4.Which operation are allowed in a join view:
a) UPDATE
b) INSERT
c) DELETE
d) All of the mentioned

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s