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 _______operation performs a set union of two “similarly structured” tables 1] Union 2] Join 3] Product 4] Intersect Solution
2 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
3 Discuss	The tuples of the relations can be of ________ order. 1] Any 2] Same 3] Sorted 4] Constant Solution
4 Discuss	A domain is atomic if elements of the domain are considered to be ____________ units. 1] Different 2] Indivisbile 3] Constant 4] Divisible Solution
5 Discuss	`SELECT name FROM instructor WHERE dept name = ’Physics’ ORDER BY name;` By default, the order by clause lists items in ______ order. 1] Descending 2] Any 3] Same 4] Ascending Solution
6 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
7 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
8 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
9 Discuss	The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match. 1] Join 2] Cartesian product 3] Intersection 4] Set difference Solution
10 Discuss	The term attribute refers to a ___________ of a table. 1] Record 2] Column 3] Tuple 4] Key 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