Quiz Discussion

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?

Course Name: SQL -Structured Query Language

• 1]

Ascending, Descending

• 2]

Asc, Desc

• 3]

Desc, Asc

• 4]

Descending, Ascending

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

_____ operator is used for appending two strings.

• 1]

&

• 2]

%

• 3]

||

• 4]

_

Solution
2
Discuss

Which one of the following is procedural language?

• 1]

Domain relational calculus

• 2]

Tuple relational calculus

• 3]

Relational algebra

• 4]

Query language

Solution
3
Discuss

A relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

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

The term attribute refers to a ___________ of a table.

• 1]

Record

• 2]

Column

• 3]

Tuple

• 4]

Key

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

The term _______ is used to refer to a row.

• 1]

Attribute

• 2]

Tuple

• 3]

Field

• 4]

Instance

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

The ________ clause is used to list the attributes desired in the result of a query.

• 1]

Where

• 2]

Select

• 3]

From

• 4]

Distinct

# Quiz