# Quiz Discussion

SELECT * FROM student JOIN takes USING (ID);

The above query is equivalent to

Course Name: SQL -Structured Query Language

• 1]
SELECT *
FROM student INNER JOIN takes USING (ID);

• 2]
SELECT *
FROM student OUTER JOIN takes USING (ID);

• 3]
SELECT *
FROM student LEFT OUTER JOIN takes USING (ID);

• 4]

None of the mentioned

##### Solution
No Solution Present Yet

#### Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

Which of the join operations do not preserve non-matched tuples?

• 1]

Left outer join

• 2]

Right outer join

• 3]

Inner join

• 4]

Natural join

##### Solution
2
Discuss

How many tables may be included with a join?

• 1]

One

• 2]

Two

• 3]

Three

• 4]

All of the mentioned

##### Solution
3
Discuss

What type of join is needed when you wish to include rows that do not have matching values?

• 1]

Equi-join

• 2]

Natural join

• 3]

Outer join

• 4]

All of the mentioned

##### Solution
4
Discuss

How many join types in join condition:

• 1]

2

• 2]

3

• 3]

4

• 4]

5

##### Solution
5
Discuss

Which are the join types in join condition:

• 1]

Cross join

• 2]

Natural join

• 3]

Join with USING clause

• 4]

All of the mentioned

##### Solution
6
Discuss

The operation which is not considered a basic operation of relational algebra is

• 1]

Join

• 2]

Selection

• 3]

Union

• 4]

Cross product

##### Solution
7
Discuss

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

• 1]

Left outer join

• 2]

Right outer join

• 3]

Full outer join

• 4]

Half outer join

##### Solution
8
Discuss

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

• 1]

Select * from R natural join S

• 2]

Select * from R cross join S

• 3]

Select * from R union join S

• 4]

Select * from R inner join

##### Solution
9
Discuss

The____condition allows a general predicate over the relations being joined.

• 1]

On

• 2]

Using

• 3]

Set

• 4]

Where

# Quiz