# Quiz Discussion

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?

Course Name: SQL -Structured Query Language

• 1]

From

• 2]

Rename

• 3]

As

• 4]

Join

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

_____ operator is used for appending two strings.

• 1]

&

• 2]

%

• 3]

||

• 4]

_

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

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

• 1]

Instance, Schema

• 2]

Relation, Schema

• 3]

Relation, Domain

• 4]

Schema, Instance

##### Solution
6
Discuss

A relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

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

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

• 1]

Column

• 2]

Key

• 3]

Row

• 4]

Entry

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

\$

# Quiz