# Quiz Discussion

The number of attributes in relation is called as its

Course Name: SQL -Structured Query Language

• 1]

Cardinality

• 2]

Degree

• 3]

Tuples

• 4]

Entity

##### 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

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
2
Discuss

_________ joins are SQL server default

• 1]

Outer

• 2]

Inner

• 3]

Equi

• 4]

None of the mentioned

##### Solution
3
Discuss

The intersection operator is used to get the _____ tuples.

• 1]

Different

• 2]

Common

• 3]

All

• 4]

Repeating

##### Solution
4
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
5
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
6
Discuss

The union operation automatically __________ unlike the select clause.

• 1]

• 2]

Eliminates unique tuples

• 3]

• 4]

Eliminates duplicate

##### Solution
7
Discuss

The union operation is represented by

• 1]

• 2]

U

• 3]

-

• 4]

*

##### Solution
8
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
9
Discuss

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

• 1]

Select

• 2]

Group-by

• 3]

Having

• 4]

Order by

# Quiz