# Quiz Discussion

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

Course Name: SQL -Structured Query Language

• 1]

Select

• 2]

Join

• 3]

Union

• 4]

Intersection

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

The tuples of the relations can be of ________ order.

• 1]

Any

• 2]

Same

• 3]

Sorted

• 4]

Constant

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

##### Solution
6
Discuss

Which one of the following is procedural language?

• 1]

Domain relational calculus

• 2]

Tuple relational calculus

• 3]

Relational algebra

• 4]

Query language

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

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

• 1]

Attributes of common

• 2]

Tuple of common

• 3]

Tuple of distinct

• 4]

Attributes of distinct

# Quiz