Question 1 Question text Given the output below. Which of the following is the c
ID: 3894991 • Letter: Q
Question
Question 1
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;
b. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = SG;
c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;
d. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (‘BV06,’KV29’)
Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.33/1.00.
Question 2
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
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 CLASS IN (‘HW’,’SG’);
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE DESCRIPTION LIKE ‘%L’;
Question 3
Question text
Given the output below. Which of the following is the correct PL/SQL to be used
Select one:
a. SELECT WAREHOUSE, CLASS FROM PARTS;
b. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;
c. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’);
d. SELECT DISTINCT WAREHOUSE FROM PARTS;
Question 4
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12
b. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND >=8;
c. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘__S%’;
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘__S%’;
Question 5
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE DESCRIPTION LIKE ‘%R’;
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 CLASS IN (‘HW’,’AP’);
Question 6
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT ALL COLUMN FROM PARTS;
b. SELECT * FROM TABLE PARTS;
c. SELECT * FROM PARTS;
d. SELECT ALL FROM PARTS;
Question 7
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘%ER’;
b. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND ONHAND BETWEEN 8 AND 12;
c. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEN 8 AND 12;
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘%ER’;
Question 8
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
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 9
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DESCRIPTION, ONHAND,CLASS
FROM PARTS
WHERE CLASS = ‘HW’;
b. SELECT DESCRIPTION, ONHAND,CLASS
FROM PARTS
WHERE CLASS = HW;
c. SELECT DESCRIPTION, ONHAND,CLASS
FROM PARTS
WHERE ONHAND >=21;
d. SELECT DESCRIPTION, ONHAND,CLASS
FROM PARTS
WHERE ONHAND IN(50,21,22);
Question 10
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;
b. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’);
c. SELECT WAREHOUSE, CLASS FROM PARTS;
d. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS;
Table 2.0 PARTS ONHAND CLASS WAREHOUSE PRICE 50 45 PARTNUM DESCRIPTION AT94 BVO6 CD52 DL71 DR93 DW11 FD21 KL62 KT03 KV29 IRON HOME GYM MICROWAVE OVEN | 32 CORDLESS DRILL 21 GAS RANGE WASHER STAND MIXER DRYER DISHWASHER TREADMILL HW SG AP HW AP AP HW AP AP SG 2495 79495 165 12995 495 399 159 349 595 1390 21 12 9Explanation / Answer
Question 1
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;
b. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = SG;
c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;
d. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (‘BV06,’KV29’)
Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.33/1.00.
Answer)
c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’;
Output:
BV06 belongs to HOME GYM
KV29 belongs to TREADMILL
Question 2
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
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 CLASS IN (‘HW’,’SG’);
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE DESCRIPTION LIKE ‘%L’;
Answer)
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE DESCRIPTION LIKE ‘%L’;
Question 3
Question text
Given the output below. Which of the following is the correct PL/SQL to be used
Select one:
a. SELECT WAREHOUSE, CLASS FROM PARTS;
b. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;
c. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’);
d. SELECT DISTINCT WAREHOUSE FROM PARTS;
Answer)
d. SELECT DISTINCT WAREHOUSE FROM PARTS;
Question 4
Question text
Given the output below. Which of the following is the correct PL/SQL to be used?
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12;
b. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND >=8;
c. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘__S%’;
d. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘__S%’;
Answer)
a. SELECT DESCRIPTION, ONHAND, CLASS
FROM PARTS
WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.