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	Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key? 1] Name 2] Dept 3] Tot_cred 4] ID Solution
2 Discuss	’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters. 1] Atleast, Exactly 2] Exactly, Atleast 3] Atleast, All 4] All, Exactly Solution
3 Discuss	Which one of the following is procedural language? 1] Domain relational calculus 2] Tuple relational calculus 3] Relational algebra 4] Query language 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	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
6 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
7 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
8 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
9 Discuss	`SELECT instructor.* FROM instructor, teaches WHERE instructor.ID= teaches.ID;` This query does which of the following operation? 1] All attributes of instructor and teaches are selected 2] All attributes of instructor are selected on the given condition 3] All attributes of teaches are selected on given condition 4] Only the some attributes from instructed and teaches are selected 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