Quiz Discussion

A relational database consists of a collection of

Course Name: SQL -Structured Query Language

  • 1]

    Tables

  • 2]

    Fields

  • 3]

    Records

  • 4]

    Keys

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 ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

  • 1]

    Where, from

  • 2]

    From, select

  • 3]

    Select, from

  • 4]

    From, where

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

The tuples of the relations can be of ________ order.

  • 1]

    Any

  • 2]

    Same

  • 3]

    Sorted

  • 4]

    Constant

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

The term _______ is used to refer to a row.

  • 1]

    Attribute

  • 2]

    Tuple

  • 3]

    Field

  • 4]

    Instance

Solution
6
Discuss

The _______operation performs a set union of two “similarly structured” tables

  • 1]

    Union

  • 2]

    Join

  • 3]

    Product

  • 4]

    Intersect

Solution
7
Discuss

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  • 1]

    Domain

  • 2]

    Relation

  • 3]

    Set

  • 4]

    Schema

Solution
8
Discuss

The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

  • 1]

    Join

  • 2]

    Cartesian product

  • 3]

    Intersection

  • 4]

    Set difference

Solution
9
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
10
Discuss

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

  • 1]

    Attributes of common

  • 2]

    Tuple of common

  • 3]

    Tuple of distinct

  • 4]

    Attributes of distinct

Solution
# Quiz