The SQL -92 wildcards are ____ and ____ .

Introduction to SQL
The SQL -92 wildcards are and .

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE '_r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '_r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

ANSWER DOWNLOAD EXAMIANS APP

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
What is a view?

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

A view is a database diagram.

None of these

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.

A view is a database diagram.

None of these

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.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
To define what columns should be displayed in an SQL SELECT statement:

use SELECT to name the source table(s) and list the columns to be shown after USING.

use USING to name the source table(s) and list the columns to be shown after SELECT.

use FROM to name the source table(s) and list the columns to be shown after SELECT.

use USING to name the source table(s) and list the columns to be shown after WHER

use SELECT to name the source table(s) and list the columns to be shown after USING.

use USING to name the source table(s) and list the columns to be shown after SELECT.

use FROM to name the source table(s) and list the columns to be shown after SELECT.

use USING to name the source table(s) and list the columns to be shown after WHER

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

Hi

TRUE

FLASE

Nothing

Hi

TRUE

FLASE

Nothing

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The SQL -92 wildcards are ____ and ____ .

Introduction to SQL How to select all data from student table starting the name from letter 'r'?

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 What is a view?

Introduction to SQL To define what columns should be displayed in an SQL SELECT statement:

Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

Introduction to SQL
The SQL -92 wildcards are and .

Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

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
What is a view?

Introduction to SQL
To define what columns should be displayed in an SQL SELECT statement:

Introduction to SQL
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs