adplus-dvertising
frame-decoration

Question

The following SQL is which type of join:
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID
FROM CUSTOMER_T,ORDER_T
WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

a.

Equi-join

b.

Natural join

c.

Outer join

d.

Cartesian join

Posted under DBMS

Answer: (a).Equi-join

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T....
Add Comment

Similar Questions

Discover Related MCQs

Q. Embedded SQL is which of the following?

View solution

Q. The following SQL is which type of join:
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID
FROM CUSTOMER_T,ORDER_T ;

View solution

Q. How many tables may be included with a join?

View solution

Q. Which of the following is one of the basic approaches for joining tables?

View solution

Q. Which of the following statements is true concerning subqueries?

View solution

Q. Which of the following is a correlated subquery?

View solution

Q. A UNION query is which of the following?

View solution

Q. Which of the following is true concerning triggers?

View solution

Q. Which of the following is true concerning a procedure?

View solution

Q. Which of the following is true concerning systems information in an RDBMS?

View solution

Q. A CASE SQL statement is which of the following?

View solution

Q. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

View solution

Q. In SQL, which command(s) is(are) used to enable/disable a database trigger?

View solution

Q. Which command is used to remove an index from the database in SQL?

View solution

Q. Which command is used to remove a table from the database in SQL?

View solution

Q. In SQL, GRANT command is used to

View solution

Q. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

View solution

Q. In SQL, which command is used to add new rows to a table?

View solution

Q. An operation that will increase the length of a list is

View solution

Q. In SQL, which command is used to add a column/integrity constraint to a table

View solution
View All MCQs on DBMS

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!

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Cryptography and Network Security

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

HTML

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

Compiler Design

Unravel the process of translating source code into executable programs with our...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Digital Communication

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

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...