Back to Top

Quiz Discussion

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?

Course Name: SQL -Structured Query Language

  • 1]

    From

  • 2]

    Rename

  • 3]

    As

  • 4]

    Join

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 * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error.

  • 1]

    Dept_name

  • 2]

    Employee

  • 3]

    “Comp Sci”

  • 4]

    From

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

A relational database consists of a collection of

  • 1]

    Tables

  • 2]

    Fields

  • 3]

    Records

  • 4]

    Keys

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

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

  • 1]

    Union

  • 2]

    Intersect

  • 3]

    Difference

  • 4]

    Projection

Solution
6
Discuss

The tuples of the relations can be of ________ order.

  • 1]

    Any

  • 2]

    Same

  • 3]

    Sorted

  • 4]

    Constant

Solution
7
Discuss

’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.

  • 1]

    Atleast, Exactly

  • 2]

    Exactly, Atleast

  • 3]

    Atleast, All

  • 4]

    All, Exactly

Solution
8
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
9
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
#Quiz
Showing 1 to 10 of 10 entries