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
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

True

False

ANSWER DOWNLOAD EXAMIANS APP

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

None

Data Manipulation Language(DML)

Both of above

Data Definition Language(DDL)

None

Data Manipulation Language(DML)

Both of above

Data Definition Language(DDL)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL commands is used to retrieve data?

SELECT

JOIN

DELETE

INSERT

SELECT

JOIN

DELETE

INSERT

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 The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

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

Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Introduction to SQL Find the name of all cities with their temperature, humidity and countries.

Introduction to SQL Which of the following SQL commands is used to retrieve data?

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
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

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

Introduction to SQL
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

Introduction to SQL
Which of the following SQL commands is used to retrieve data?