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);

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

None of these

Both A and B

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

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In SQL, which of the following is not a data definition language commands?

RENAME

GRANT

UPDATE

REVOKE

RENAME

GRANT

UPDATE

REVOKE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which one of the following sorts rows in SQL?

GROUP BY

SORT BY

ORDER BY

ALIGN BY

GROUP BY

SORT BY

ORDER BY

ALIGN BY

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

False

True

ANSWER DOWNLOAD EXAMIANS APP

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

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Select the right statement to insert values to the student table.

INSERT student VALUES (

INSERT VALUES INTO student (

INSERT VALUES (

INSERT INTO student VALUES (

INSERT student VALUES (

INSERT VALUES INTO student (

INSERT VALUES (

INSERT INTO student VALUES (

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 In SQL, which of the following is not a data definition language commands?

Introduction to SQL Which one of the following sorts rows in SQL?

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

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

Introduction to SQL Select the right statement to insert values to the student table.

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
In SQL, which of the following is not a data definition language commands?

Introduction to SQL
Which one of the following sorts rows in SQL?

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

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

Introduction to SQL
Select the right statement to insert values to the student table.