# 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

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
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
3
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
4
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

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

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

Using which language can a user request information from a database?

• 1]

Query

• 2]

Relational

• 3]

Structural

• 4]

Compiler

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

# Quiz