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
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

10

5

0

9

10

5

0

9

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

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.

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

None of these

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.

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL WHERE clause:

limits the row data are returned.

Both A and B are correct.

limits the column data that are returned.

Neither A nor B are correct.

limits the row data are returned.

Both A and B are correct.

limits the column data that are returned.

Neither A nor B are correct.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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 The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL What is a view?

Introduction to SQL The SQL WHERE clause:

Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

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
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL
What is a view?

Introduction to SQL
The SQL WHERE clause:

Introduction to SQL
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.