Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Name

  • 2]

    Dept

  • 3]

    Tot_cred

  • 4]

    ID

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 domain is atomic if elements of the domain are considered to be ____________ units.

  • 1]

    Different

  • 2]

    Indivisbile

  • 3]

    Constant

  • 4]

    Divisible

Solution
2
Discuss

The tuples of the relations can be of ________ order.

  • 1]

    Any

  • 2]

    Same

  • 3]

    Sorted

  • 4]

    Constant

Solution
3
Discuss

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

  • 1]

    Upper

  • 2]

    String

  • 3]

    Trim

  • 4]

    Lower

Solution
4
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
5
Discuss
SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;

Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?

  • 1]

    %

  • 2]

    _

  • 3]

    ||

  • 4]

    $

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

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

_____ operator is used for appending two strings.

  • 1]

    &

  • 2]

    %

  • 3]

    ||

  • 4]

    _

Solution
10
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
# Quiz