Back to Top

Quiz Discussion

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

This query can be replaced by which of the following ?

Course Name: SQL -Structured Query Language

  • 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
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
10
Discuss

The term attribute refers to a ___________ of a table.

  • 1]

    Record

  • 2]

    Column

  • 3]

    Tuple

  • 4]

    Key

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

_____ operator is used for appending two strings.

  • 1]

    &

  • 2]

    %

  • 3]

    ||

  • 4]

    _

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

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

  • 1]

    Union

  • 2]

    Join

  • 3]

    Product

  • 4]

    Intersect

Solution
#Quiz
Showing 1 to 10 of 10 entries