# Quiz Discussion

A domain is atomic if elements of the domain are considered to be ____________ units.

Course Name: SQL -Structured Query Language

• 1]

Different

• 2]

Indivisbile

• 3]

Constant

• 4]

Divisible

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

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

• 1]

Query

• 2]

Relational

• 3]

Structural

• 4]

Compiler

##### Solution
4
Discuss

The term _______ is used to refer to a row.

• 1]

Attribute

• 2]

Tuple

• 3]

Field

• 4]

Instance

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

Which one of the following is procedural language?

• 1]

Domain relational calculus

• 2]

Tuple relational calculus

• 3]

Relational algebra

• 4]

Query language

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

# Quiz