# Quiz Discussion

_____ operator is used for appending two strings.

Course Name: SQL -Structured Query Language

• 1]

&

• 2]

%

• 3]

||

• 4]

_

##### 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 relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

##### Solution
2
Discuss

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

• 1]

Domain

• 2]

Relation

• 3]

Set

• 4]

Schema

##### Solution
3
Discuss

Which one of the following is procedural language?

• 1]

Domain relational calculus

• 2]

Tuple relational calculus

• 3]

Relational algebra

• 4]

Query language

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

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

• 1]

Union

• 2]

Join

• 3]

Product

• 4]

Intersect

##### Solution
6
Discuss

Course(course_id,sec_id,semester)

Here the course_id,sec_id and semester are __________ and course is a _________

• 1]

Relations, Attribute

• 2]

Attributes, Relation

• 3]

Tuple, Relation

• 4]

Tuple, Attributes

##### Solution
7
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
8
Discuss

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

• 1]

Column

• 2]

Key

• 3]

Row

• 4]

Entry

##### Solution
9
Discuss

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

• 1]

Schematic representation

• 2]

Relational algebra

• 3]

Scheme diagram

• 4]

Relation flow

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

# Quiz