# 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

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

Using which language can a user request information from a database?

• 1]

Query

• 2]

Relational

• 3]

Structural

• 4]

Compiler

##### Solution
3
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
4
Discuss

The term attribute refers to a ___________ of a table.

• 1]

Record

• 2]

Column

• 3]

Tuple

• 4]

Key

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

A relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

##### Solution
7
Discuss

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

• 1]

Upper

• 2]

String

• 3]

Trim

• 4]

Lower

##### Solution
8
Discuss

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

• 1]

Where

• 2]

Select

• 3]

From

• 4]

Distinct

##### Solution
9
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

’_____’ 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

# Quiz