The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Introduction to SQL
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
ON UPDATE CASCADE ensures which of the following?

Normalization

Materialized Views

All of these

Data Integrity

Normalization

Materialized Views

All of these

Data Integrity

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

5

0

10

9

5

0

10

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Indexes may be created or dropped at any time.

True

False

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

Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Introduction to SQL Find all the cities whose humidity is 89

Introduction to SQL ON UPDATE CASCADE ensures which of the following?

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 Indexes may be created or dropped at any time.

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
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Introduction to SQL
Find all the cities whose humidity is 89

Introduction to SQL
ON UPDATE CASCADE ensures which of the following?

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
Indexes may be created or dropped at any time.

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.