The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

Introduction to SQL
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

456789

2345

6789

1234

456789

2345

6789

1234

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In SQL, which of the following is not a data definition language commands?

RENAME

UPDATE

GRANT

REVOKE

RENAME

UPDATE

GRANT

REVOKE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

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
In SQL, which command(s) is(are) used to change a table's storage characteristics?

All of these

CHANGE TABLE

ALTER TABLE

MODIFY TABLE

All of these

CHANGE TABLE

ALTER TABLE

MODIFY TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

Introduction to SQL In SQL, which of the following is not a data definition language commands?

Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

Introduction to SQL What is a view?

Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics?

Introduction to SQL
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

Introduction to SQL
In SQL, which of the following is not a data definition language commands?

Introduction to SQL
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

Introduction to SQL
What is a view?

Introduction to SQL
In SQL, which command(s) is(are) used to change a table's storage characteristics?