Find the names of the countries whose condition is sunny.

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

SELECT country FROM location WHERE condition = 'sunny';

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather 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 condition = 'sunny';

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather 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');

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

None of these

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints

9

10

0

5

9

10

0

5

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

NON-EQUIJOIN

EQUIJOIN

OUTER JOIN

NATURAL JOIN

NON-EQUIJOIN

EQUIJOIN

OUTER JOIN

NATURAL JOIN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Count function in SQL returns the number of

distinct values.

groups.

values.

columns.

distinct values.

groups.

values.

columns.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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

Introduction to SQL What is a view?

Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

Introduction to SQL Count function in SQL returns the number of

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

Introduction to SQL
What is a view?

Introduction to SQL
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Introduction to SQL
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

Introduction to SQL
Count function in SQL returns the number of