Joins Operations - GATE CSE (CSE) Database Management System Free MCQ Test

Test: Joins Operations - Question 1

Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

A.
Join view
B.
Datable join view
C.
Updatable join view
D.
All of the mentioned

Detailed Solution: Question 1

The DELETE statement is used to delete rows in a table. The UPDATE statement is used to update existing records in a table. The INSERT INTO statement is used to insert new records in a table.

Test: Joins Operations - Question 2

Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

A.
Left outer join
B.
Right outer join
C.
Full outer join
D.
Half outer join

Detailed Solution: Question 2

A right outer join will return all the rows that an inner join returns plus one row for each of the other rows in the second table that did not have a match in the first table. It is the same as a left outer join with the tables specified in the opposite order.

Join for Free

Test: Joins Operations - Question 3

Which product is returned in a join query have no join condition:

A.
Equijoins
B.
Cartesian
C.
Both Equijoins and Cartesian
D.
None of the mentioned

Detailed Solution: Question 3

A Cartesian coordinate system is a coordinate system that specifies each point uniquely in a plane by a pair of numerical coordinates.

Test: Joins Operations - Question 4

How many join types in join condition:

A.
2
B.
3
C.
4
D.
5

Detailed Solution: Question 4

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, EQUIJOIN.

Test: Joins Operations - Question 5

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

Detailed Solution: Question 5

An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining fields from two tables by using values common to each.

Test: Joins Operations - Question 6

Which operation are allowed in a join view:

A.
UPDATE
B.
INSERT
C.
DELETE
D.
All of the mentioned

Detailed Solution: Question 6

The DELETE statement is used to delete rows in a table. The UPDATE statement is used to update existing records in a table. The INSERT INTO statement is used to insert new records in a table.

Test: Joins Operations - Question 7

Which is a join condition contains an equality operator:

A.
Equijoins
B.
Cartesian
C.
Both Equijoins and Cartesian
D.
None of the mentioned

Detailed Solution: Question 7

An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate.

Test: Joins Operations - Question 8

Which are the join types in join condition:

A.
Cross join
B.
Natural join
C.
Join with USING clause
D.
All of the mentioned

Detailed Solution: Question 8

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, EQUIJOIN are the types of joins.

Test: Joins Operations - Question 9

Which oracle is the join condition is specified using the WHERE clause:

A.
Oracle 9i
B.
Oracle 8i
C.
Pre-oracle 9i
D.
Pre-oracle 8i

Detailed Solution: Question 9

Oracle 9i is a version of the Oracle Database. The i stands for “Internet” to indicate that 9i is “Internet ready”.

Test: Joins Operations - Question 10

Which of the following Relational Algebra operations can be used when you want to keep all the tuples of the first relation irrespective of whether or not they have matching tuples in the second relation?

A.
Natural join
B.
Left-outer join
C.
Right-outer-join
D.
Theta join

Detailed Solution: Question 10

The answer to the above question is Option (b) Left-outer Join
A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
Here are the different types of the JOINs in SQL:

(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

We can see that left join keeps all the elements from the first relation irrespective of their presence in second relation.
Diagram to visualize joins:

	Database Management System (DBMS) 62 videos\|101 docs\|35 tests

Information about Test: Joins Operations Page

In this test you can find the Exam questions for Test: Joins Operations solved & explained in the simplest way possible. Besides giving Questions and answers for Test: Joins Operations, EduRev gives you an ample number of Online tests for practice

Joins Operations - Free MCQ Practice Test with solutions, GATE CSE (CSE)

MCQ Practice Test & Solutions: Test: Joins Operations (10 Questions)