The Microsoft Access wildcards are ____ and ____ .

Introduction to SQL
The Microsoft Access wildcards are and .

underscore(_); question mark (?)

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

underscore(_); question mark (?)

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

CAPITAL LETTERS.

brackets -- [...].

braces -- {...}.

parenthesis -- (...) .

CAPITAL LETTERS.

brackets -- [...].

braces -- {...}.

parenthesis -- (...) .

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

Both A and B

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

Both A and B

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;

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
Which operator performs pattern matching?

BETWEEN operator

EXISTS operator

None of these

LIKE operator

BETWEEN operator

EXISTS operator

None of these

LIKE operator

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The Microsoft Access wildcards are ____ and ____ .

Introduction to SQL A subquery in an SQL SELECT statement is enclosed in:

Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"?

Introduction to SQL What is a view?

Introduction to SQL Which operator performs pattern matching?

Introduction to SQL
The Microsoft Access wildcards are and .

Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

Introduction to SQL
What is a view?

Introduction to SQL
Which operator performs pattern matching?