Quiz Discussion

SELECT * FROM employee WHERE dept_name="Comp Sci";

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

Course Name: SQL -Structured Query Language

  • 1]

    Dept_name

  • 2]

    Employee

  • 3]

    “Comp Sci”

  • 4]

    From

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

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

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

  • 1]

    Upper

  • 2]

    String

  • 3]

    Trim

  • 4]

    Lower

Solution
3
Discuss

A ________ in a table represents a relationship among a set of values.

  • 1]

    Column

  • 2]

    Key

  • 3]

    Row

  • 4]

    Entry

Solution
4
Discuss
SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

  • 1]
    SELECT name
    FROM instructor
    WHERE salary BETWEEN 90000 AND 100000;

     

  • 2]
    SELECT name
    FROM employee
    WHERE salary <= 90000 AND salary>=100000;

     

  • 3]
    SELECT name
    FROM employee
    WHERE salary BETWEEN 90000 AND 100000;

     

  • 4]
    SELECT name
    FROM instructor
    WHERE salary BETWEEN 100000 AND 90000;

     

Solution
5
Discuss
SELECT *
FROM instructor
ORDER BY salary ____, name ___;

To display the salary from greater to smaller and name in ascending order which of the following options should be used?

  • 1]

    Ascending, Descending

  • 2]

    Asc, Desc

  • 3]

    Desc, Asc

  • 4]

    Descending, Ascending

Solution
6
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
7
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
8
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
9
Discuss

The term attribute refers to a ___________ of a table.

  • 1]

    Record

  • 2]

    Column

  • 3]

    Tuple

  • 4]

    Key

Solution
10
Discuss

Which one of the following is procedural language?

  • 1]

    Domain relational calculus

  • 2]

    Tuple relational calculus

  • 3]

    Relational algebra

  • 4]

    Query language

Solution
# Quiz