Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Upper

  • 2]

    String

  • 3]

    Trim

  • 4]

    Lower

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 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
2
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
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

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

  • 1]

    Instance, Schema

  • 2]

    Relation, Schema

  • 3]

    Relation, Domain

  • 4]

    Schema, Instance

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

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

_____ operator is used for appending two strings.

  • 1]

    &

  • 2]

    %

  • 3]

    ||

  • 4]

    _

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

The term attribute refers to a ___________ of a table.

  • 1]

    Record

  • 2]

    Column

  • 3]

    Tuple

  • 4]

    Key

Solution
# Quiz