Which of the following is valid SQL for an Index?

Introduction to SQL
Which of the following is valid SQL for an Index?

REMOVE INDEX ID;

CHANGE INDEX ID;

ADD INDEX ID;

CREATE INDEX ID;

REMOVE INDEX ID;

CHANGE INDEX ID;

ADD INDEX ID;

CREATE INDEX ID;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the names of the countries whose condition is sunny.

SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE condition = 'sunny';

SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE condition = 'sunny';

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What operator tests column for the absence of data?

None of these

EXISTS operator

NOT operator

IS NULL operator

None of these

EXISTS operator

NOT operator

IS NULL operator

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY temperature;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which SQL statement is used to delete data FROM a database?

REMOVE

COLLAPSE

ALTER

DELETE

REMOVE

COLLAPSE

ALTER

DELETE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following is valid SQL for an Index?

Introduction to SQL Find the names of the countries whose condition is sunny.

Introduction to SQL What operator tests column for the absence of data?

Introduction to SQL Find the temperature in increasing order of all cities

Introduction to SQL Which SQL statement is used to delete data FROM a database?

Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

Introduction to SQL
Which of the following is valid SQL for an Index?

Introduction to SQL
Find the names of the countries whose condition is sunny.

Introduction to SQL
What operator tests column for the absence of data?

Introduction to SQL
Find the temperature in increasing order of all cities

Introduction to SQL
Which SQL statement is used to delete data FROM a database?

Introduction to SQL
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.