Examine this code:

Examine this query:
SELECT ename, d.dname, job, sal, comm FROM emp e, dept d WHERE d.deptno = e.deptno; Which statement is correct regarding the execution of this SQL query?

• A. The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.
• B. The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.
• C. The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.
• D. The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
  "xxxxx".

You are designing and developing a complex database application and implementing fine-grained access control using security policies.
Which statement is true with respect to attaching security policies to database objects?

• A. You implement security policies through database procedures.
• B. You can use different security policies for SELECT, INSERT, UPDATE, INDEX and DELETE statements.
• C. Column-masking policies can be applied to SELECT, INSERT, UPDATE and DELETE statements.
• D. You can use only one security policy per database object.

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.
There are six employees in DEPARTMENT_ID, 20. Examine this code:

What will be the outcome on execution?

• A. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.
• B. The execution of this code will fail with an invalid cursor error and not display either output message.
• C. The number of employees will be displayed as six for both output messages.
• D. The number of employees will be displayed as six for the first output message and zero for the second output message.

Your company's executive team voted to give a one-time special bonus, the amount of which is to be based on number of years of service. The bonus table will be updated using a procedure called update_bonus().
Examine this PL/SQL block which shows the logic to calculate the bonus:

Consider these possible optimization actions:
1.Remove the service_days calculation statement.
2.Move bonus1 and bonus2 initializations out of the loop.
3.Inline the update_bonus() subprogram.
4.Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables.
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?

• A. 1 and 3 only
• B. 1 and 2 only
• C. 1, 2, 3, and 4
• D. 3 and 4 only
• E. 1, 2, and 4 only

In your schema, the DEPARTMENTS table contains the columns DEPARTMENT_ID and DEPARTMENT_NAME.
You want to display the department name for existing department id 10.
With SERVEROUTPUT enabled, which two blocks of code will give the required output?

• A. DECLARETYPE names_t IS TABLE OF SYS_REFCURSOR INDEX BY PLS_INTEGER;cv1 names_t;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;
• B. DECLARETYPE dept_cur IS REF CURSOR;cv1 dept_cur;v_dept_name departments.
  department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;IF cv1 IS NOT NULL THENFETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);END IFCLOSE cv1;END;
• C. DECLARETYPE dept_cur IS REF CURSOR RETURN departments%ROWTYPE;cv1
  dept_cur;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT * FROM departments WHERE department_id=10;FETCH cv1. department_name INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;
• D. DECLAREcv1 SYS_REFCURSOR;v_dept_name
  departments.department_name%TYPE;BEGINEXECUTE IMMEDIATE 'BEGIN OPEN: cv1 FORSELECT department_name FROM departmnets WHERE department_id=10: END;'USING IN cv1;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;