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
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
10
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
2
Discuss
|
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
3
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
4
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
5
Discuss
|
_____ operator is used for appending two strings.
Solution |
6
Discuss
|
By default, the order by clause lists items in ______ order.
Solution |
7
Discuss
|
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?
Solution |
8
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 |
9
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved