A to Z View - All Upwork Test Answers

Upwork Oracle SQL 9i Test Answer

1. Which of the following constitute the correct guidelines for naming
database tables?Answers: • Must be 1-30 characters long --or--- • Should not be an Oracle Server
reserved word --or--- • Must contain only A-Z, a-z, 0-9, _, $, and # --or--- •
Must begin with a letter

2. Which of the following are DML statements?Answers: • MERGE ---- or ---- • UPDATE ---- or ---- • DELETE

3. An outer join is used when:Answers: • The columns being joined have NULL values ---- or ---- • The tables
being joined have both matched and unmatched data

4. Which of the following components are required to run iSQL*plus on PC?Answers: • HTTP Server --- or --- • iSQL*PLUS Server

5. Which of the following constitute the attributes of /SQL*Plus?Answers: • /SQL*Plus commands are accessed from a browser ----- or ----- •
/SQL*Plus commands manipulate table definitions in the database

6. Which component is a literal in the following select statement?
Select 'Emp name :'||ename from emp where deptno=20;Answers: • 20 ---- or ---- • Emp name:

7. Which of the following statements is a complete transaction?Answers: • ROLLBACK TO SAVEPOINT C; ---- or ----- • ALTER TABLE employees SET
UNUSED COLUMN sal;

8. Which of the following tasks can be performed by using the TO_CHAR function?Answers: • Convert 10 to '10' ---- or ---- • Convert a date to a character
expression

9. What kinds of commands can you enter at the command prompt in 9i Sql Plus?Answers: • PL/SQL Blocks ----- or ----- • SQL commands

10. Which of the following statements are correct with regard to WHERE and
HAVING clauses?Answers: • A WHERE clause can be used to restrict rows only --- or ---- • A
HAVING clause can be used to restrict groups only

Which of the following Subqueries work?Answers: • SELECT distinct department_id FROM employees Where salary > ANY
(SELECT AVG(salary) FROM employees GROUP BY department_id); ----- OR ------- •
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM
employees GROUP BY department_id);

13. You have to calculate the value 12* salary* commission_pct for all the
employees in the EMP table. Which of the following statements ensures that a
value is displayed in the calculated column for all the employees?Answers: • SELECT last_name, 12 * salary* (nvl(commission_pct,0) )FROM emp;

====================================================

You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees?