Quiz Discussion

The ________ clause is used to list the attributes desired in the result of a query.

Course Name: SQL -Structured Query Language

  • 1]

    Where

  • 2]

    Select

  • 3]

    From

  • 4]

    Distinct

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

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

  • 1]

    Schema diagram

  • 2]

    Relational algebra

  • 3]

    Database diagram

  • 4]

    Schema flow

Solution
2
Discuss

Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?

  • 1]

    Name

  • 2]

    Dept

  • 3]

    Tot_cred

  • 4]

    ID

Solution
3
Discuss

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

  • 1]

    Schematic representation

  • 2]

    Relational algebra

  • 3]

    Scheme diagram

  • 4]

    Relation flow

Solution
4
Discuss

The term attribute refers to a ___________ of a table.

  • 1]

    Record

  • 2]

    Column

  • 3]

    Tuple

  • 4]

    Key

Solution
5
Discuss

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

  • 1]

    Join

  • 2]

    Projection

  • 3]

    Select

  • 4]

    Union

Solution
6
Discuss

Which one of the following is procedural language?

  • 1]

    Domain relational calculus

  • 2]

    Tuple relational calculus

  • 3]

    Relational algebra

  • 4]

    Query language

Solution
7
Discuss

_____ operator is used for appending two strings.

  • 1]

    &

  • 2]

    %

  • 3]

    ||

  • 4]

    _

Solution
8
Discuss

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

  • 1]

    Select

  • 2]

    Join

  • 3]

    Union

  • 4]

    Intersection

Solution
9
Discuss
SELECT name
FROM instructor
WHERE dept name = ’Physics’
ORDER BY name;

By default, the order by clause lists items in ______ order.

  • 1]

    Descending

  • 2]

    Any

  • 3]

    Same

  • 4]

    Ascending

Solution
10
Discuss
SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

Which keyword must be used here to rename the field name?

  • 1]

    From

  • 2]

    Rename

  • 3]

    As

  • 4]

    Join

Solution
# Quiz