# Quiz Discussion

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

Course Name: SQL -Structured Query Language

• 1]

Schematic representation

• 2]

Relational algebra

• 3]

Scheme diagram

• 4]

Relation flow

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

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

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

• 1]

Schema diagram

• 2]

Relational algebra

• 3]

Database diagram

• 4]

Schema flow

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

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

• 1]

Where, from

• 2]

From, select

• 3]

Select, from

• 4]

From, where

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

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

• 1]

Union

• 2]

Join

• 3]

Product

• 4]

Intersect

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

The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

• 1]

Join

• 2]

Cartesian product

• 3]

Intersection

• 4]

Set difference

# Quiz