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?

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;

Both A and B

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
'AS' clause is used in SQL for

Join operation.

Selection operation.

Projection operation.

Rename operation.

Join operation.

Selection operation.

Projection operation.

Rename operation.

ANSWER DOWNLOAD EXAMIANS APP

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

None of these

SELECT

READ

QUERY

None of these

SELECT

READ

QUERY

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is the original purpose of SQL?

To specify the syntax and semantics of SQL manipulation language

To define the data structures

To specify the syntax and semantics of SQL data definition language

All of these

To specify the syntax and semantics of SQL manipulation language

To define the data structures

To specify the syntax and semantics of SQL data definition language

All of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

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 'AS' clause is used in SQL for

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

Introduction to SQL Which of the following is the original purpose of SQL?

Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL If a query involves NOT, AND, OR with no parenthesis

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
'AS' clause is used in SQL for

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

Introduction to SQL
Which of the following is the original purpose of SQL?

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis