Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Both A and B

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

Both A and B

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
________ was adopted as a national standard by ANSI in 1992.

DBase

SQL

Oracle

Microsoft Access

DBase

SQL

Oracle

Microsoft Access

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
There is an equivalent join expression that can be substituted for all subquery expressions.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

READ

SELECT

None of these

QUERY

READ

SELECT

None of these

QUERY

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A subquery in an SQL SELECT statement:

can always be duplicated by a join.

can only be used with two tables.

cannot have its results sorted using ORDER BY.

has a distinct form that cannot be duplicated by a join.

can always be duplicated by a join.

can only be used with two tables.

cannot have its results sorted using ORDER BY.

has a distinct form that cannot be duplicated by a join.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL ________ was adopted as a national standard by ANSI in 1992.

Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions.

Introduction to SQL The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL Find the name of cities with all entries whose temperature is in the range of 71 and 89

Introduction to SQL A subquery in an SQL SELECT statement:

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL
________ was adopted as a national standard by ANSI in 1992.

Introduction to SQL
There is an equivalent join expression that can be substituted for all subquery expressions.

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

Introduction to SQL
A subquery in an SQL SELECT statement: