3/16/2019 Midterms

Question 1 This is use to Selects the columns in a table that are returned by a query. Selects a
Not yet few or as many of the columns as required.
answered

Marked out of Select one:

1.00
a. Joins

b. Inclusion

c. Selection

d. Projection

Question 2 It is a character, a number, or a date that is included in the SELECT statement.

Not yet
answered
Select one:
Marked out of
a. Table name
1.00
b. Literal

c. String
d. Alias

Question 3 This is used to restrict the rows that are returned by a query.
Not yet
answered
Select one:
Marked out of
1.00
a. Select
b. Where

c. Delete
d. Insert

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 1/23
3/16/2019 Midterms
Question 4 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM
PARTS WHERE CLASS = ‘SG’;

b. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM

PARTS WHERE PARTNUM IN (‘BV06,’KV29’)

c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM

PARTS WHERE CLASS = SG;
d. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE
CLASS = ‘SG’;

Question 5 This is used to display rows based on a range of values.

Not yet
answered
Select one:
Marked out of
1.00
a. Like

b. Comparison

c. IN

d. Between

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 2/23
3/16/2019 Midterms
Question 6 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report that will list only the column
DESCRIPTION, PARTNUM, CLASS, and PRICE of all PART whose CLASS is
equal to HW.

SELECT DESCRIPTION, PARTNUM, CLASS, PRICE FROM PARTS WHERE

CLASS=’HW’;

SELECT DESCRIPTION, PARTNUM, CLASS, PRICE FROM PARTS WHERE

class="HW";

SELECT ‘DESCRIPTION’, ‘PARTNUM’, ‘CLASS’, ‘PRICE’ FROM PARTS

WHERE CLASS=’HW’;
SELECT COLUMN DESCRIPTION, PARTNUM, CLASS, PRICE FROM
PARTS WHERE CLASS=’HW’;

Question 7 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered
Marked out of
1.00

Which of the following is the correct report that will display the distinct value for
CLASS and WAREHOUSE limit the rows by getting only the parts under
WAREHOUSE 3?

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = 3;

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = ‘3’;

SELECT CLASS, WAREHOUSE FROM PARTS WHERE WAREHOUSE = =3;

SELECT CLASS, WAREHOUSE =3 FROM PARTS WHERE WAREHOUSE =
3;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 3/23
3/16/2019 Midterms
Question 8 Which of the following is not true about writing SQL statements?
Not yet
answered
Select one:
Marked out of
1.00
a. Indents should be used to make code more readable.

b. Keywords cannot be split across lines or abbreviated.

c. SQL statements are not case sensitive.

d. Clauses are usually placed on separate lines for readability and ease
of editing.

Question 9 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE
PRICE >10000;

b. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE

PRICE <10000;

c. SELECT DESCRIPTION, PRICE *.5 +(PRICE-100) FROM PARTS WHERE

PRICE <10000;
d. SELECT DESCRIPTION, (PRICE *.5 )+PRICE-100 FROM PARTS WHERE
PRICE >10000;

Question 10 This is used to perform wildcard searches of valid search string values.
Not yet
answered
Select one:
Marked out of
1.00
a. IN
b. Comparison

c. Like

d. Between

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 4/23
3/16/2019 Midterms
Question 11 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column CLASS,
DESCRIPTION and PRICE of all PARTS where price range is between 200 to 500.
Sort the Price in descending order.

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE

BETWEEN 200 AND 500;

SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE

BETWEEN 500 AND 500;
SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE
BETWEEN =200 AND 500;
SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE
BETWEEN 200 AND BETWEEN 500;

Question 12 This is used to test for values in a specified set of values.

Not yet
answered
Select one:
Marked out of
1.00
a. Like
b. IN

c. Between

d. Comparison

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 5/23
3/16/2019 Midterms
Question 13 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column DESCRIPTION,
CLASS and PRICE of all PARTS where class is not equal to AP.

SELECT DESCRIPTION, CLASS, PRICE FROM PARTS WHERE CLASS

NOT LIKE ‘%AP%’;

SELECT DESCRIPTION, CLASS, PRICE FROM PARTS WHERE CLASS

NOT LIKE ‘%AP’;

SELECT DESCRIPTION, CLASS, PRICE FROM PARTS WHERE CLASS !=

AP;

SELECT DESCRIPTION, CLASS, PRICE FROM PARTS WHERE CLASS <>

AP;

Question 14 This is used to restrict the rows that are returned by a query.
Not yet
answered
Select one:
Marked out of
1.00
a. Insert
b. Delete

c. Select

d. Where

Question 15 True/False. The != not equal to symbol is also equal to this symbol<>.
Not yet
answered
Answer: True
Marked out of
1.00

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 6/23
3/16/2019 Midterms
Question 16 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report showing all rows and columns sort the
description in ascending order.

SELECT * FROM PARTS ORDER BY DESCRIPTION DESC;

SELECT * FROM PARTS ORDER BY DESCRIPTION;

SELECT * FROM PARTS ORDER BY DESCRIPTION ASC;

SELECT * FROM PARTS ORDER BY DESC;

Question 17 This is used to selects the rows in a table that are returned by a query. Various
Not yet criteria can be used to restrict the rows that are retrieved.
answered
Marked out of Select one:
1.00
a. Joins

b. Inclusion

c. Selection

d. Projection

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 7/23
3/16/2019 Midterms
Question 18 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing the DESCRIPTION and Price
(Note that in column PRICE add ADDITIONAL 10000). Get only the prices with no
digit that is equal to ‘5’. Note that you have to concatenate the said column and
rename the merge column as “New Price Lists”. Sort the data in DESC order by
Price.

SELECT DESCRIPTION, PRICE + 10000 AS “NEW PRICE LISTS” FROM

PARTS ORDER BY PRICE DESC;

SELECT DESCRIPTION, PRICE + 10000 AS NEW PRICE LISTS FROM

PARTS ORDER BY PRICE DESC;

SELECT DESCRIPTION, PRICE + 10000 AS “NEW PRICE LISTS” FROM

PARTS ORDER BY PRICE;

SELECT DESCRIPTION, PRICE + 10000 + PRICE AS “NEW PRICE LISTS”

FROM PARTS ORDER BY PRICE DESC;

Question 19 True/False. Character strings and date values are enclosed with double quotation
Not yet marks.
answered
Marked out of
1.00 Answer: False

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 8/23
3/16/2019 Midterms
Question 20 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, ONHAND,CLASS
FROM PARTS
WHERE ONHAND >=21;

b. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS
WHERE ONHAND IN(50,21,22);

c. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS
WHERE CLASS = ‘HW’;

d. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS
WHERE CLASS = HW;

Question 21 This is use to create expression with number and date values.
Not yet
answered
Select one:
Marked out of
a. MDAS operator
1.00
b. Arithmetic expression

c. Logical Condition

d. Numerical Values

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 9/23
3/16/2019 Midterms
Question 22 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN
(‘AP’,’SG’,’HW’);

b. SELECT WAREHOUSE, CLASS FROM PARTS;

c. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS WHERE
WAREHOUSE >=1;
d. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS;

Question 23 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS IN (‘HW’,’AP’);

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR CLASS = ‘HW’;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE DESCRIPTION LIKE ‘R%’;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE DESCRIPTION LIKE ‘%R’;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 10/23
3/16/2019 Midterms
Question 24 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND ONHAND BETWEEN 8 AND 12;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEN 8 AND 12;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘%ER’;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘%ER’;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 11/23
3/16/2019 Midterms
Question 25 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing the column PARTNO,
DESCRIPTION and WAREHOUSE. Get only that description that does not ends
with ‘ER’. Note that you have to merge the said three columns, rename the merge
column as “Parts Record”. Below is the sample output for column.
Parts Record
AT94is the part number ofIRONwhich belong to warehouse3

SELECT (PARTNUM || ‘is the part number of’|| DESCRIPTION || ‘which

belongs to’ || WAREHOUSE FROM PARTS WHERE PARTNUM NOT LIKE
‘%ER’;

SELECT (PARTNUM || ‘is the part number of’ ||DESCRIPTION || ‘which

belongs to’ || WAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE
‘ER%’;

SELECT (PARTNUM ‘is the part number of’ DESCRIPTION‘which belongs

to’WAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE ‘%ER’;
SELECT (PARTNUM || ‘is the part number of’ ||DESCRIPTION || ‘which
belongs to’ || WAREHOUSE) FROM PARTS WHERE PARTNUM LIKE ‘%ER’;

Question 26 True/False. This symbol % denotes zero or many characters.

Not yet
answered
Answer: True
Marked out of
1.00

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 12/23
3/16/2019 Midterms
Question 27 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT * FROM TABLE PARTS;

b. SELECT ALL COLUMN FROM PARTS;

c. SELECT ALL FROM PARTS;
d. SELECT * FROM PARTS;

Question 28 Given the output below. Which of the following is the correct PL/SQL to be used
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT WAREHOUSE, CLASS FROM PARTS;
b. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN
(‘AP’,’SG’,’HW’);

c. SELECT DISTINCT WAREHOUSE FROM PARTS;

d. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE
WAREHOUSE >=1;

Question 29 This is used to display rows based on a range of values.

Not yet
answered
Select one:
Marked out of
1.00
a. Between

b. Like

c. IN

d. Comparison

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 13/23
3/16/2019 Midterms
Question 30 This is used to perform wildcard searches of valid search string values.
Not yet
answered
Select one:
Marked out of
a. Comparison
1.00
b. Between
c. IN
d. Like

Question 31 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report that will merge the column
DESCRIPTION and PRICE put a literal character string of = “ with a price of ” in
between the two columns. Limit the rows returned by getting only the partnum that
starts with letter ‘K’.

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS

WHERE PARTNUM LIKE ‘K%’;

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS

WHERE PARTNUM LIKE ‘%K’;

SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS

WHERE PARTNUM LIKE ‘%K%’;
SELECT (DESCRIPTION|| ‘WITH A PRICE OF’ || PRICE) FROM PARTS
WHERE PARTNUM LIKE ‘__K%’;

Question 32 A system used to concatenate one column to another column.

Not yet
answered
Select one:
Marked out of
1.00
a. ||
b. *

c. ( )
d. AS

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 14/23
3/16/2019 Midterms
Question 33 This is used to in conditions that compare one expression with another value or
Not yet expression.
answered

Marked out of Select one:

1.00
a. Logical Condition

b. Add

c. Subtraction
d. Comparison

Question 34 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column DESCRIPTION,
ONHAND and WAREHOUSE of all PARTS where ONHAND is greater than or
equal to 21.

SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE

ONHAND >=21;
SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE
ONHAND <=21;

SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE

ONHAND =21;
SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE
ONHAND >21;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 15/23
3/16/2019 Midterms
Question 35 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE DESCRIPTION LIKE ‘%L’;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE ONHAND >=9;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE DESCRIPTION LIKE ‘%L%’;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS IN (‘HW’,’SG’);

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 16/23
3/16/2019 Midterms
Question 36 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column PARTNUM,
CLASS and ONHAND of all parts where partnum is equal to AT94, DR93 and
KV29. (Note 1 query only and do not use logical condition)

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM

IN (‘AT94’,’DR93’,’KV29’);

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM

IN (AT94,DR93,KV29);

SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM =

(‘AT94’,’DR93’,’KV29’);
SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM
NOT IN (‘AT94’,’DR93’,’KV29’);

Question 37 It is a value that is unavailable, unassigned, unknown, or inapplicable.

Not yet
answered
Select one:
Marked out of
1.00
a. Zero

b. Space

c. NULL

d. Blank

Question 38 This character is used to override the default precedence or to clarify the
Not yet statement.
answered

Marked out of Select one:

1.00
a. AS

b. *

c. ||
d. ( )

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 17/23
3/16/2019 Midterms
Question 39 Supposed that the user uses the ff SELECT statement: what will be the possible
Not yet output.
answered

Marked out of SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT;

1.00

Select one:
a. Error because of the keyword AS.

b. Will display all rows and columns.

c. Will display the column GRADE rename as STUDENT MARK
d. Error because of missing “” mark.

Question 40 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report that will display the DESCRIPTION,
WAREHOUSE AND distinct value for CLASS.

SELECT DESCRIPTION, WAREHOUSE, DISTINCT (CLASS) FROM PARTS;

SELECT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

SELECT DISTINCT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

SELECT DESCRIPTION, WAREHOUSE, DISTINCT ‘CLASS ‘ FROM PARTS;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 18/23
3/16/2019 Midterms
Question 41 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column PARTNUM,
DESCRIPTION and PRICE of all PARTS where price is less than 500. Sort the
PRICE in ascending order.

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE <

500;

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE >

500;

SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE

<=500;
SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE
>= 500;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 19/23
3/16/2019 Midterms
Question 42 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column DESCRIPTION,
PARTNUM, CLASS and PRICE of all parts where the description fourth letter
starting from the first is equal to ‘D’.

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS

WHERE DESCRIPTION LIKE ‘___D%’;

SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS

WHERE DESCRIPTION LIKE ‘%D___’;
SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS
WHERE DESCRIPTION LIKE ‘D%’;
SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS
WHERE DESCRIPTION LIKE ‘%D’;

Question 43 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered
Marked out of
1.00

Which of the following is the correct report listing only the column DESCRIPTION,
ONHAND, CLASS and PRICE of all price where the description ends with letter ‘N’.

SELECT DESCRIPTION, ONHAND, CLASSS FROM PARTS WHERE

DESCRIPTION LIKE ‘%N’;
SELECT DESCRIPTION, ONHAND, CLASSS FROM PARTS WHERE
DESCRIPTION LIKE ‘N%’;

SELECT DESCRIPTION, ONHAND, CLASSS FROM PARTS WHERE

DESCRIPTION LIKE ‘%N%’;

SELECT DESCRIPTION, ONHAND, CLASSS FROM PARTS WHERE

DESCRIPTION NOT LIKE ‘%N’;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 20/23
3/16/2019 Midterms
Question 44 True/False. A null value means that the value is unavailable, unassigned, unknown,
Not yet or inapplicable.
answered

Marked out of
1.00
Answer: True

Question 45 This is used to in conditions that compare one expression with another value or
Not yet expression.
answered

Marked out of Select one:

1.00
a. Logical Condition

b. Comparison

c. Subtraction
d. Add

Question 46 This is used to test for values in a specified set of values.

Not yet
answered
Select one:
Marked out of
a. IN
1.00
b. Between

c. Like
d. Comparison

Question 47 True/False Character values are format sensitive and date values are case
Not yet sensitive-sensitive.
answered
Marked out of
1.00 Answer: False

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 21/23
3/16/2019 Midterms
Question 48 Choose the letter of the correct answer based on table PARTS as shown
Not yet below
answered

Marked out of
1.00

Which of the following is the correct report listing only the column DESCRIPTION,
WAREHOUSE, CLASS and PRICE of all parts where the description contains
keyword ‘SHE’.

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS

WHERE DESCRIPTION LIKE ‘%SHE%’;

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS

WHERE DESCRIPTION LIKE ‘SHE%’;

SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS

WHERE DESCRIPTION LIKE ‘%SHE’;
SELECT DESCRIPTION, WAREHOUSE, CLASS, PRICE FROM PARTS
WHERE DESCRIPTION LIKE ‘SHE’;

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 22/23
3/16/2019 Midterms
Question 49 Given the output below. Which of the following is the correct PL/SQL to be used?
Not yet
answered

Marked out of
1.00

Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘__S%’;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘__S%’;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND >=8;

Question 50 This is used to brings together data that is stored in different tables by specifying
Not yet the link between them.
answered

Marked out of Select one:

1.00
a. Inclusion

b. Joins

c. Selection
d. Projection

https://blended.amauonline.com/mod/quiz/attempt.php?attempt=34797331 23/23