SELECT name FROM instructor WHERE salary <= 100000 AN...

SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

Course Name: SQL -Structured Query Language

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;

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 ________ clause is used to list the attributes desired in the result of a query. 1] Where 2] Select 3] From 4] Distinct Solution
2 Discuss	The term _______ is used to refer to a row. 1] Attribute 2] Tuple 3] Field 4] Instance Solution
3 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
4 Discuss	`SELECT * FROM instructor ORDER BY salary ____, name ___;` To display the salary from greater to smaller and name in ascending order which of the following options should be used? 1] Ascending, Descending 2] Asc, Desc 3] Desc, Asc 4] Descending, Ascending Solution
5 Discuss	A relational database consists of a collection of 1] Tables 2] Fields 3] Records 4] Keys Solution
6 Discuss	The term attribute refers to a ___________ of a table. 1] Record 2] Column 3] Tuple 4] Key Solution
7 Discuss	In SQL the spaces at the end of the string are removed by _______ function. 1] Upper 2] String 3] Trim 4] Lower Solution
8 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
9 Discuss	The _______operation performs a set union of two “similarly structured” tables 1] Union 2] Join 3] Product 4] Intersect Solution
10 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
#	Quiz

Quiz Discussion

Solution

Top 5 Similar Quiz - Based On AI&ML

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

About Fresherbell

Important Links

Social Media