Quiz Discussion

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.

Course Name: SQL -Structured Query Language

• 1]

Attributes of common

• 2]

Tuple of common

• 3]

Tuple of distinct

• 4]

Attributes of distinct

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

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

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

• 1]

Query

• 2]

Relational

• 3]

Structural

• 4]

Compiler

Solution
5
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
6
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
7
Discuss

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

• 1]

Union

• 2]

Join

• 3]

Product

• 4]

Intersect

Solution
8
Discuss

In SQL the spaces at the end of the string are removed by _______ function.

• 1]

Upper

• 2]

String

• 3]

Trim

• 4]

Lower

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

# Quiz