Quiz Discussion

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Course Name: SQL -Structured Query Language

  • 1]

    Where, from

  • 2]

    From, select

  • 3]

    Select, from

  • 4]

    From, where

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

_____ operator is used for appending two strings.

  • 1]

    &

  • 2]

    %

  • 3]

    ||

  • 4]

    _

Solution
2
Discuss

The tuples of the relations can be of ________ order.

  • 1]

    Any

  • 2]

    Same

  • 3]

    Sorted

  • 4]

    Constant

Solution
3
Discuss

Course(course_id,sec_id,semester)

Here the course_id,sec_id and semester are __________ and course is a _________

  • 1]

    Relations, Attribute

  • 2]

    Attributes, Relation

  • 3]

    Tuple, Relation

  • 4]

    Tuple, Attributes

Solution
4
Discuss

Using which language can a user request information from a database?

  • 1]

    Query

  • 2]

    Relational

  • 3]

    Structural

  • 4]

    Compiler

Solution
5
Discuss

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

  • 1]

    Where

  • 2]

    Select

  • 3]

    From

  • 4]

    Distinct

Solution
6
Discuss

A relational database consists of a collection of

  • 1]

    Tables

  • 2]

    Fields

  • 3]

    Records

  • 4]

    Keys

Solution
7
Discuss

The term _______ is used to refer to a row.

  • 1]

    Attribute

  • 2]

    Tuple

  • 3]

    Field

  • 4]

    Instance

Solution
8
Discuss

In SQL the spaces at the end of the string are removed by _______ function.

  • 1]

    Upper

  • 2]

    String

  • 3]

    Trim

  • 4]

    Lower

Solution
9
Discuss

Which one of the following is procedural language?

  • 1]

    Domain relational calculus

  • 2]

    Tuple relational calculus

  • 3]

    Relational algebra

  • 4]

    Query language

Solution
10
Discuss
SELECT instructor.*
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

This query does which of the following operation?

  • 1]

    All attributes of instructor and teaches are selected

  • 2]

    All attributes of instructor are selected on the given condition

  • 3]

    All attributes of teaches are selected on given condition

  • 4]

    Only the some attributes from instructed and teaches are selected

Solution
# Quiz