adplus-dvertising
frame-decoration

Question

In SQL the statement select * from R, S is equivalent to

a.

Select * from R natural join S

b.

Select * from R cross join S

c.

Select * from R union join S

d.

Select * from R inner join S

Posted under SQL DBMS

Answer: (b).Select * from R cross join S

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. In SQL the statement select * from R, S is equivalent to
Add Comment

Similar Questions

Discover Related MCQs

Q. Which join condition contains an equality operator:

View solution

Q. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

View solution

Q. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

View solution

Q. What are the after triggers ?

View solution

Q. The variables in the triggers are declared using

View solution

Q. The default extension for an Oracle SQL*Plus file is:

View solution

Q. Triggers ________ enabled or disabled.

View solution

Q. To include integrity constraint in a existing relation use :

View solution

Q. Which of the following is not a integrity constraint ?

View solution

Q. Which of the following is the right syntax for assertion?

View solution

Q. Which of the following can be addressed by enforcing a referential integrity constraint?

View solution

Q. Drop Table cannot be used to drop a table referenced by a _________ constraint.

View solution

Q. ____________ is preferred method for enforcing data integrity.

View solution

Q. SQL stands for ________ .

View solution

Q. The SQL command to create a table is:

View solution

Q. A ________ is a stored program that is attached to a table or a view.

View solution

Q. The DROP TABLE statement:

View solution

Q. SQL views can be used to hide:

View solution

Q. The SQL statement to create a view is:

View solution

Q. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

View solution
View All MCQs on SQL

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...