# Quiz Discussion

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

Course Name: SQL -Structured Query Language

• 1]

Column

• 2]

Key

• 3]

Row

• 4]

Entry

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

A domain is atomic if elements of the domain are considered to be ____________ units.

• 1]

Different

• 2]

Indivisbile

• 3]

Constant

• 4]

Divisible

##### Solution
5
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
6
Discuss
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?

• 1]

From

• 2]

Rename

• 3]

As

• 4]

Join

##### 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 tuples of the relations can be of ________ order.

• 1]

Any

• 2]

Same

• 3]

Sorted

• 4]

Constant

##### Solution
9
Discuss

A relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

##### Solution
10
Discuss

The term attribute refers to a ___________ of a table.

• 1]

Record

• 2]

Column

• 3]

Tuple

• 4]

Key

# Quiz