Quiz Discussion

The union operation is represented by

Course Name: SQL -Structured Query Language

  • 1]

  • 2]

    U

  • 3]

    -

  • 4]

    *

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

_________ joins are SQL server default

  • 1]

    Outer

  • 2]

    Inner

  • 3]

    Equi

  • 4]

    None of the mentioned

Solution
4
Discuss

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

  • 1]

    Select

  • 2]

    Group-by

  • 3]

    Having

  • 4]

    Order by

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

The number of attributes in relation is called as its

  • 1]

    Cardinality

  • 2]

    Degree

  • 3]

    Tuples

  • 4]

    Entity

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

The union operation automatically __________ unlike the select clause.

  • 1]

    Adds tuples

  • 2]

    Eliminates unique tuples

  • 3]

    Adds common tuples

  • 4]

    Eliminates duplicate

Solution
9
Discuss

The intersection operator is used to get the _____ tuples.

  • 1]

    Different

  • 2]

    Common

  • 3]

    All

  • 4]

    Repeating

Solution
# Quiz