SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;
This query can be replaced by which of the following ?
SELECT name
FROM instructor
WHERE salary BETWEEN 90000 AND 100000;
SELECT name
FROM employee
WHERE salary <= 90000 AND salary>=100000;
SELECT name
FROM employee
WHERE salary BETWEEN 90000 AND 100000;
SELECT name
FROM instructor
WHERE salary BETWEEN 100000 AND 90000;
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
| # | Quiz |
|---|---|
|
1
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
|
2
Discuss
|
The term _______ is used to refer to a row.
Solution |
|
3
Discuss
|
The tuples of the relations can be of ________ order.
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.
Solution |
|
5
Discuss
|
_____ operator is used for appending two strings.
Solution |
|
6
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
|
7
Discuss
|
A ________ in a table represents a relationship among a set of values.
Solution |
|
8
Discuss
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
|
9
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.
Solution |
|
10
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
| # | Quiz |
Copyright © 2020 Inovatik - All rights reserved