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?

None of these

Both A and B

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

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

None of these

Both A and B

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

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

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
Which of the following are the five built-in functions provided by SQL?

SUM, AVG, MIN, MAX, NAME

SUM, AVG, MIN, MAX, MULT

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

SUM, AVG, MIN, MAX, MULT

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MULT, DIV, MIN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Both of above

None

Data Manipulation Language(DML)

Data Definition Language(DDL)

Both of above

None

Data Manipulation Language(DML)

Data Definition Language(DDL)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which operator performs pattern matching?

EXISTS operator

BETWEEN operator

LIKE operator

None of these

EXISTS operator

BETWEEN operator

LIKE operator

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which SQL keyword is used to sort the result-set?

SORT

SORT BY

ORDER BY

ORDER

SORT

SORT BY

ORDER BY

ORDER

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 Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL Which of the following are the five built-in functions provided by SQL?

Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Introduction to SQL Which operator performs pattern matching?

Introduction to SQL Which SQL keyword is used to sort the result-set?

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
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL
Which of the following are the five built-in functions provided by SQL?

Introduction to SQL
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Introduction to SQL
Which operator performs pattern matching?

Introduction to SQL
Which SQL keyword is used to sort the result-set?