Select one: a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS
ID: 3894902 • Letter: S
Question
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’)
2. Given the output below. Which of the following is the correct PL/SQL to be used?
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’;
3. 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;
4. 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%’;
5. 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’);
6. 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;
7. Given the output below. Which of the following is the correct PL/SQL to be used?
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’;
8.Given the output below. Which of the following is the correct PL/SQL to be used?
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;
9. Given the output below. Which of the following is the correct PL/SQL to be used?
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);
10. Given the output below. Which of the following is the correct PL/SQL to be used?
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;
Explanation / Answer
Quest: 1
Select one:
a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’; False
b. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = SG; False, error
c. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE CLASS = ‘SG’; True, rows displayed with condition where class = 'SG'.
d. SELECT (PARTNUM|| ‘belong to’||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (‘BV06,’KV29’) - False, wrong format
Quest: 2
a. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE DESCRIPTION LIKE ‘L%’; - False, letter startin with L will be displayed
b. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE ONHAND >=9; - False, displays different output
c. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS IN (‘HW’,’SG’); - False, error
d. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE DESCRIPTION LIKE ‘%L’; True, letter ends with L will e shown
Quest: 3
Select one:
a. SELECT WAREHOUSE, CLASS FROM PARTS; - False, produces different output
b. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1; - False - produces different output
c. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’); - False, error
d. SELECT DISTINCT WAREHOUSE FROM PARTS; True
Quest: 4:
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR ONHAND BETWEEEN 8 AND 12 - False, syntax error
b. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR ONHAND >=8; - False, produces different output
c. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘__S%’; - True diplays same output
d. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘__S%’; - False, produces different output
Quest: 5
Select one:
a. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE DESCRIPTION LIKE ‘%R’; - True
b. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR CLASS = ‘HW’; - False
c. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE DESCRIPTION LIKE ‘R%’; - False
d. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS IN (‘HW’,’AP’); - False
Quest: 6
a. SELECT ALL COLUMN FROM PARTS; - False, syntax eror
b. SELECT * FROM TABLE PARTS; - False, syntax error
c. SELECT * FROM PARTS; - True, perfect output
d. SELECT ALL FROM PARTS; - False, syntax error
Quest: 7
a. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR DESCRIPTION LIKE ‘%ER’; - False
b. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ AND ONHAND BETWEEN 8 AND 12; - False
c. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ OR ONHAND BETWEEN 8 AND 12; - False
d. SELECT DESCRIPTION, ONHAND, CLASS FROM PARTS WHERE CLASS = ‘AP’ AND DESCRIPTION LIKE ‘%ER’; - True
Quest: 8
a. SELECT DESCRIPTION, (PRICE *.5 )+PRICE-100 FROM PARTS WHERE PRICE >10000; - True
b. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE >10000; - False
c. SELECT DESCRIPTION, PRICE *.5 +(PRICE-100) FROM PARTS WHERE PRICE <10000; - False
d. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE <10000; - False
Quest: 9
a. SELECT DESCRIPTION, ONHAND,CLASS FROM PARTS WHERE CLASS = ‘HW’; True
b. SELECT DESCRIPTION, ONHAND,CLASS FROM PARTS WHERE CLASS = HW; - False, syntax error
c. SELECT DESCRIPTION, ONHAND,CLASS FROM PARTS WHERE ONHAND >=21; - False, only 2 rows are shown output is differs.
d. SELECT DESCRIPTION, ONHAND,CLASS FROM PARTS WHERE ONHAND IN(50,21,22); - False, error in (50,21,22) format
Quest: 10
a. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1; - False, output is dfferent
b. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (‘AP’,’SG’,’HW’); - False, error
c. SELECT WAREHOUSE, CLASS FROM PARTS; - False, entire warehouse and class will e displayed
d. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS; True, only distinct warehouse and class will e shown
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.