The wildcard in a WHERE clause is useful when?

Introduction to SQL
The wildcard in a WHERE clause is useful when?

An exact match is not possible in a SELECT statement.

An exact match is not possible in a CREATE statement.

An exact match is necessary in a SELECT statement.

An exact match is necessary in a CREATE statement.

An exact match is not possible in a SELECT statement.

An exact match is not possible in a CREATE statement.

An exact match is necessary in a SELECT statement.

An exact match is necessary in a CREATE statement.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A subquery in an SQL SELECT statement:

has a distinct form that cannot be duplicated by a join.

can always be duplicated by a join.

cannot have its results sorted using ORDER BY.

can only be used with two tables.

has a distinct form that cannot be duplicated by a join.

can always be duplicated by a join.

cannot have its results sorted using ORDER BY.

can only be used with two tables.

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

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.

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.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The wildcard in a WHERE clause is useful when?

Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

Introduction to SQL A subquery in an SQL SELECT statement:

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

Introduction to SQL What is a view?

Introduction to SQL Find the temperature in increasing order of all cities

Introduction to SQL
The wildcard in a WHERE clause is useful when?

Introduction to SQL
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

Introduction to SQL
A subquery in an SQL SELECT statement:

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

Introduction to SQL
What is a view?

Introduction to SQL
Find the temperature in increasing order of all cities