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	Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations. 1] Attributes of common 2] Tuple of common 3] Tuple of distinct 4] Attributes of distinct Solution
2 Discuss	`SELECT name ____ instructor name, course id FROM instructor, teaches WHERE instructor.ID= teaches.ID;` Which keyword must be used here to rename the field name? 1] From 2] Rename 3] As 4] Join Solution
3 Discuss	A domain is atomic if elements of the domain are considered to be ____________ units. 1] Different 2] Indivisbile 3] Constant 4] Divisible 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	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
6 Discuss	The most commonly used operation in relational algebra for projecting a set of tuple from a relation is 1] Join 2] Projection 3] Select 4] Union Solution
7 Discuss	The _______operation performs a set union of two “similarly structured” tables 1] Union 2] Join 3] Product 4] Intersect Solution
8 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
9 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
10 Discuss	In SQL the spaces at the end of the string are removed by _______ function. 1] Upper 2] String 3] Trim 4] Lower 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