# Quiz Discussion

The term attribute refers to a ___________ of a table.

Course Name: SQL -Structured Query Language

• 1]

Record

• 2]

Column

• 3]

Tuple

• 4]

Key

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

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

The tuples of the relations can be of ________ order.

• 1]

Any

• 2]

Same

• 3]

Sorted

• 4]

Constant

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

The term _______ is used to refer to a row.

• 1]

Attribute

• 2]

Tuple

• 3]

Field

• 4]

Instance

##### Solution
5
Discuss

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

• 1]

Schematic representation

• 2]

Relational algebra

• 3]

Scheme diagram

• 4]

Relation flow

##### Solution
6
Discuss
SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

• 1]
SELECT name
FROM instructor
WHERE salary BETWEEN 90000 AND 100000;

• 2]
SELECT name
FROM employee
WHERE salary <= 90000 AND salary>=100000;

• 3]
SELECT name
FROM employee
WHERE salary BETWEEN 90000 AND 100000;

• 4]
SELECT name
FROM instructor
WHERE salary BETWEEN 100000 AND 90000;

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

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

• 1]

Column

• 2]

Key

• 3]

Row

• 4]

Entry

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

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

# Quiz