PROG-113A-LAB-1812S / (47/50)► Week
10: Quarterly Examination / ► First Quarter
Exam
Question
1
Answer saved
Marked out of 1.00
Remove flag
Question text
You can relate data to multiple tables using a foreign
key.
Select one:TrueFalse
Question
2
Answer saved
Marked out of 1.00
Remove flag
Question text
Which of the following SELECT statement is the
correct report that will deduct 5 from ONHAND,
multiply 5 in WAREHOUSE, after getting the value on
both ONHAND and WAREHOUSE add their data: as
shown below: ONHAND - 5 + 5 * WAREHOUSE
Note that you have to force the Oracle to prioritize first
the Subtraction over Multiplication. List only the
column DESCRIPTION, ONHAND and
WAREHOUSE.
Select one:
a. SELECT (ONHAND-5) + 5(* WAREHOUSE), b. SELECT ONHAND-5 + 5 * WAREHOUSE,
DESCRIPTION FROM PARTS;
DESCRIPTION FROM PARTS;
c. SELECT (ONHAND-5) + 5 * WAREHOUSE,
DESCRIPTION FROM PARTS;
d. SELECT ONHAND-5 + 5 (* WAREHOUSE),
DESCRIPTION FROM PARTS;
Question
3
Answer saved
Marked out of 1.00
Flag question
Question text
INSERT, DELETE, UPDATE are ________________
commands
Select one:
Question
4
Answer saved
Marked out of 1.00
Flag question
Question text
What will be the SQL command if every employee will
be given a productivity bonus which is equivalent to
3% of the monthly salary?Display the employee id, salary and the productivity bonus.Select one:
FROM employees
FROM employees
FROM employees
03) FROM employees
employees WHERE salary)
Question
5
Answer saved
Marked out of 1.00
Flag question
Question text
You
want to display the employee’s last name
whose salary is below 10,000 and whose lastname
starts with letter K.
Which SQL statement give the required output
format of the salary?
Select one:
'$999,999.99') AS "MONTHLY SALARY" FROM
employees WHERE salary < 10000WHERE
last_name LIKE ‘K%’
'$999,999.99') AS "MONTHLY SALARY" FROM
employees WHERE salary < 10,000WHERE
last_name = ‘K%’
$999,999.99) AS "MONTHLY SALARY" FROM
employees WHERE salary < 10000 WHERE
last_name IN 'K%'
'$999,999.99') AS "MONTHLY SALARY" FROM
employees WHERE salary < 10,000 WHERE
last_name STARTS 'K%'
Question
6
Answer saved
Marked out of 1.00
Remove flag
Question text
Which of the following is the correct report that will
display the CLASS from table PARTS.
