• Author / Uploaded
• Dorin Chioibas

• Categories
• Pl / Sql
• SQL
• Datos de computadora
• Áreas de informática
• Software de gestión de datos

Citation preview

Test: Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 Quiz (Answer all questions in this section) 1. data in PL/SQL? (1) Points

Which of the following is NOT a good guideline for retrieving Mark for Review

Declare the receiving variables using %TYPE Specify the same number of variables in the INTO clause as database columns in the SELECT clause. THE SELECT statement should fetch exactly one row. The WHERE clause is optional in nearly all cases. (*)

Correct

Correct

2. Which one of these SQL statements can be directly included in a PL/SQL executable block? Mark for Review (1) Points CREATE TABLE new_emps (last_name VARCHAR2(10), first_name VARCHAR2(10)); SELECT salary FROM employees WHERE department_id=60; DROP TABLE locations; DELETE FROM employees WHERE department_id=60; (*)

Correct

Correct

3. A variable is declared as: DECLARE v_holdit employees.last_name%TYPE; BEGIN ...

Which of the following is a correct use of the INTO clause? Mark for Review (1) Points SELECT last_name INTO v_holdit FROM employees WHERE employee_id=100; (*)

SELECT last_name INTO v_holdit FROM employees; SELECT * INTO v_holdit FROM employees; SELECT salary INTO v_holdit FROM employees WHERE employee_id=100;

Correct

Correct

4. exactly one row? (1) Points

When used in a PL/SQL block, which SQL statement must return Mark for Review

SELECT (*) MERGE DELETE UPDATE INSERT

Correct

Correct

5. data in PL/SQL? (1) Points

Which of the following is NOT a valid guideline for retrieving Mark for Review

Specify the same number of variables in the INTO clause as database columns in the SELECT clause. Where possible, declare variables using the %TYPE attribute. Terminate the SQL statement with a semicolon (;) Do NOT use a WHERE clause in SELECT statements. (*)

Correct

Correct

Page 1 of 3 Next

Summary

Test: Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 Quiz (Answer all questions in this section) 6.

In a PL/SQL block, where can you code a COMMIT statement?

Mark

for Review (1) Points In any section of the block: Declaration, Executable, or Exception. Only the Executable section. Nowhere; the COMMIT statement must be outside the block. In the Executable and/or the Exception sections. (*)

Correct

Review (1) Points

Correct 7.

How many INSERTs can you have in one transaction?

Mark for

One As many as you can execute before the database does an AUTOSAVE. As many as you want until you do a COMMIT or ROLLBACK. (*) As many as you want until a different DML statement (UPDATE, DELETE or MERGE) is executed.

Correct

Correct

8. A PL/SQL block includes the following statement: SELECT last_name INTO v_last_name FROM employees WHERE employee_id=100; What is the value of SQL%FOUND immediately after the SELECT statement is executed? Mark for Review (1) Points False Null Error. That attribute does not apply for implicit cursors. True (*)

Correct

Correct

9. You declare an implicit cursor in the DECLARE section of a PL/SQL block. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

10. There are no employees in Department 77. What will happen when the following block is executed? BEGIN DELETE FROM employees WHERE department_id=77; DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT) END; Mark for Review (1) Points A zero (0) is displayed. (*) A NO_DATA_FOUND exception is raised. A NULL is displayed. An exception is raised because the block does not contain a COMMIT statement.

Correct Previous

Correct Page 2 of 3 Next

Summary

Test: Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 Quiz (Answer all questions in this section) 11. The following table has been created: CREATE TABLE student_table (stud_id NUMBER(6), last_name VARCHAR2(20), first_name VARCHAR2(20), lunch_num NUMBER(4)); Which one of the following INSERT statements will fail? Mark for Review (1) Points INSERT INTO student_table (stud_id, last_name, lunch_num) VALUES (143354, 'Roberts', 6543, 'Cameron'); (*)

INSERT INTO student_table (stud_id, last_name, first_name, lunch_num) VALUES (143354, 'Roberts', 'Cameron', 6543);

INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, 'Cameron', 'Roberts'); INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543);

Correct

statement. (1) Points

Correct 12. To modify an existing row in a table, you can use the ________ Mark for Review

INSERT ALTER MODIFY UPDATE (*)

Correct

Correct

13. Which of the following will delete all employees who work in the Sales department? Mark for Review (1) Points DELETE FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales'); (*)

DELETE FROM employees WHERE department_id = SELECT department_id FROM departments WHERE department_name = 'Sales'; DELETE FROM employees e, departments d WHERE e.department_id = d.department_id AND department_name = 'Sales';

DELETE (SELECT department_id FROM departments WHERE department_name = 'Sales') FROM employees;

Incorrect

Incorrect. Refer to Section 3 Lesson 1.

14. What keyword goes at the beginning of the following SQL statement? _____ INTO test1 a USING all_objects b ON (a.object_id = b.object_id) WHEN MATCHED THEN UPDATE SET a.status = b.status WHEN NOT MATCHED THEN INSERT (object_id, status) VALUES (b.object_id, b.status); Mark for Review (1) Points UPDATE MERGE (*) DELETE INSERT

Incorrect

Incorrect. Refer to Section 3 Lesson 1.

15. When explicitly inserting a row into a table, the VALUES clause must include a value for every column of the table. True or False? Mark for Review (1) Points True False (*)

Incorrect Previous

Incorrect. Refer to Section 3 Lesson 1. Page 3 of 3 Summary