Quiz Discussion

The intersection operator is used to get the _____ tuples.

Course Name: SQL -Structured Query Language

• 1]

Different

• 2]

Common

• 3]

All

• 4]

Repeating

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

The _____________ is essentially used to search for patterns in target string.

• 1]

Like Predicate

• 2]

Null Predicate

• 3]

In Predicate

• 4]

Out Predicate

Solution
2
Discuss

If we want to retain all duplicates, we must write ________ in place of union.

• 1]

Union all

• 2]

Union some

• 3]

Intersect all

• 4]

Intersect some

Solution
3
Discuss

The number of attributes in relation is called as its

• 1]

Cardinality

• 2]

Degree

• 3]

Tuples

• 4]

Entity

Solution
4
Discuss

The union operation is represented by

• 1]

• 2]

U

• 3]

-

• 4]

*

Solution
5
Discuss

The union operation automatically __________ unlike the select clause.

• 1]

• 2]

Eliminates unique tuples

• 3]

• 4]

Eliminates duplicate

Solution
6
Discuss

_____ clause is an additional filter that is applied to the result.

• 1]

Select

• 2]

Group-by

• 3]

Having

• 4]

Order by

Solution
7
Discuss
(SELECT course id
FROM SECTION
WHERE semester = ’Fall’ AND YEAR= 2009)
EXCEPT
(SELECT course id
FROM SECTION
WHERE semester = ’Spring’ AND YEAR= 2010);

This query display

• 1]

Only tuples from second part

• 2]

Only tuples from the first part which has the tuples from second part

• 3]

Tuples from both the parts

• 4]

Tuples from first part which do not have second part

Solution
8
Discuss

For like predicate which of the following is true.

i) % matches zero OF more characters.
ii) _ matches exactly one CHARACTER.

• 1]

i-only

• 2]

ii-only

• 3]

i & ii

• 4]

None of the mentioned

Solution
9
Discuss

_________ joins are SQL server default

• 1]

Outer

• 2]

Inner

• 3]

Equi

• 4]

None of the mentioned

# Quiz