# Quiz Discussion

The term _______ is used to refer to a row.

Course Name: SQL -Structured Query Language

• 1]

Attribute

• 2]

Tuple

• 3]

Field

• 4]

Instance

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

A relational database consists of a collection of

• 1]

Tables

• 2]

Fields

• 3]

Records

• 4]

Keys

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

\$

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

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

• 1]

Domain

• 2]

Relation

• 3]

Set

• 4]

Schema

##### Solution
10
Discuss

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

• 1]

Upper

• 2]

String

• 3]

Trim

• 4]

Lower

# Quiz