12/13/2020 Performance Task 1: Attempt review

Home / My courses / BAED-PROG3114-2022S / Week 2-4: Introduction to PLSQL / Performance Task 1

Started on Sunday, 13 December 2020, 10:34 AM

Question 1
Complete

Mark 1.00 out of 1.00

Which of the following SELECT statement is the correct PL/SQL that will display eliminate the duplicate rows for column class and
warehouse.

Select one:
a. SELECT DISTINCT CLASS, WAREHOUSE FROM PARTS;

b. SELECT DISTINCT CLASS, DISTINCT WAREHOUSE FROM PARTS;

c. SELECT DISTINCT CLASS AND DISTINCT WAREHOUSE FROM PARTS;

d. SELECT DISTINCT CLASS AND WAREHOUSE FROM PARTS;

Question 2
Complete

Mark 0.00 out of 1.00

Which of the following SELECT statement is the correctreport that will combine the column PARTNUM and DESCRIPTION put a literal
character string "belongs to" in between the two columns then rename the column as "NUMBER TITLE". Note put space before and after the
character literal string to avoid no spaces in the report.

Select one:
a. SELECT (PARTNUM||' THAT BELONGS TO '||DESCRIPTION) AS NUMBER TITLE FROM PARTS;

b. SELECT (PARTNUM|| THAT BELONGS TO ||DESCRIPTION) AS "NUMBER TITLE" FROM PARTS;

c. SELECT (;PARTNUM'||' THAT BELONGS TO '||'DESCRIPTION;) AS "NUMBER TITLE" FROM PARTS;

d. SELECT (PARTNUM||' THAT BELONGS TO '||DESCRIPTION) AS "NUMBER TITLE" FROM PARTS;

https://shs.amaesonline.com/2022/mod/quiz/review.php?attempt=126870&cmid=3663 1/4
12/13/2020 Performance Task 1: Attempt review

Question 3
Complete

Mark 1.00 out of 1.00

Display all the employee's id and salary whose annual salary is from 100,000 to 200,000. Arrange the output by salary in descending order.

Select one:
a. SELECT employee_id, salary, salary *12 FROM employees WHERE 12* salary = 100000 AND 12 *salary = 200000 ORDER BY salary

b. SELECT employee_id, salary FROM employees WHERE salary *12 >= 100000 AND salary *12 <= 200000 ORDER BY salary

c. SELECT employee_id, salary FROM employees WHERE salary *12 >= 100000 AND salary *12 <= 200000 ORDER BY salary desc

d. SELECT employee_id, salary FROM employees WHERE salary >= 100000 AND salary <= 200000 ORDER BY salary

Question 4
Complete

Mark 1.00 out of 1.00

Which of the following is the correct report

Select one:
a. SELECT * CLASS FROM PARTS;

b. SELECT 'CLASS' FROM PARTS;

c. SELECT CLASS AS CLASS FROM PARTS;

d. SELECT CLASS FROM PARTS;

Question 5
Complete

Mark 1.00 out of 1.00

Display part number description and warehouse number whose part number starts with letter K.

Select one:
a. SELECT partnum, description, warehouse FROM parts WHERE partnum = LIKE ‘K%’;

b. SELECT partnum, description, warehouse FROM parts WHERE partnum LIKE '*K*';

c. SELECT partnumber, description, warehouse FROM parts WHERE partnum = LIKE ‘K%’;

d. SELECT partnum, description, warehouse FROM parts WHERE partnum LIKE 'K%';

e. SELECT * FROM parts WHERE partnum LIKE 'K_';

f. SELECT partnumber, description, warehouse FROM parts WHERE partnum LIKE 'K*';

g. SELECT * FROM parts WHERE partnum LIKE 'K%';

https://shs.amaesonline.com/2022/mod/quiz/review.php?attempt=126870&cmid=3663 2/4
12/13/2020 Performance Task 1: Attempt review

Question 6
Complete

Mark 0.00 out of 1.00

Display the first 3 letter in the first name of all the employees.

Select one:
a. SELECT SUBSTRING(first_name,1,3) FROM employees;

b. SELECT SUBSTRING(first_name,1,3) FROM employees;

c. SELECT SUBSTR(first_name,3) FROM employees;

d. SELECT SUBSTR(first_name,1,3) FROM employees;

Question 7
Complete

Mark 0.00 out of 1.00

Which of the following SELECT statement is the correctreport the will merge the column CLASS and PRICE rename the COLUMN as "CLASS
PRICE".

Select one:
a. SELECT (CLASS||PRICE) AS CLASS PRICE FROM PARTS;

b. SELECT ('CLASS'||'PRICE') AS "CLASS PRICE" FROM PARTS;

c. SELECT (CLASS||PRICE) CLASS PRICE FROM PARTS;

d. SELECT (CLASS||PRICE) AS "CLASS PRICE" FROM PARTS;

Question 8
Complete

Mark 0.00 out of 1.00

Display the first 5 letter in the surname of all the employees whose firstname starts with letter 'D'

Select one:
a. SELECT SUBSTR(last_name,1,5), first_name FROM employees WHERE SUBSTR(first_name,1,1) = 'D'

b. SELECT SUBSTR(last_name,1,5), first_name FROM employees WHERE first_name IN 'D'

c. SELECT SUBSTR(surname,1,5), first_name FROM employees WHERE first_name = 'D'

d. SELECT SUBSTR(last_name,1,5), first_name FROM employees WHERE SUBSTR(first_name,1,1) IN 'D'

e. SELECT SUBSTR(surname,1,5), first_name FROM employees WHERE SUBSTR(first_name,1,1) IN 'D'

https://shs.amaesonline.com/2022/mod/quiz/review.php?attempt=126870&cmid=3663 3/4
12/13/2020 Performance Task 1: Attempt review

Question 9
Complete

Mark 1.00 out of 1.00

Using Data Manipulation Language, you can ADD columns in the table.

Select one:
True

False

Question 10
Complete

Mark 1.00 out of 1.00

Using CREATE SQL Command, you can add new records in the table.

Select one:
True

False

◄ Week 002-004 Declaring Variables

Jump to...

Written Work 1 ►

https://shs.amaesonline.com/2022/mod/quiz/review.php?attempt=126870&cmid=3663 4/4