SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

What is the use of Full Join in SQL?


 

 

 

 



C


Solution:-

The SQL FULL JOIN combines the results of both left and right outer joins.

The joined table will contain all records from both the tables and fill in NULLs for missing matches on either side.

The basic syntax of a FULL JOIN is as follows:

SELECT tableA.columnA, tableB.columnB...FROM tableA FULL JOIN tableB ON tableA.common_field = tableB.common_field;

Now, let us join SLIGHTBOOK and ORDERS tables using FULL JOIN is as follows:

SELECT CourseID, CourseNAME, CourseAMOUNT, CourseDURATION FROM SLIGHTBOOK FULL JOIN ORDERS ON SLIGHTBOOK.CourseID = ORDERS.CourseID;

 




Next 5 multiple choice(s)

1

What are the properties of a transaction in SQL?

2

Which is not the properties of a transaction in SQL?

3

What is the use of Session Control Statement(SCS) in SQL?

4

What is the use of the Transaction Control Statement(TCS) in SQL?

5

What is the use of Data Control Language(DCL) in SQL?

Comments