31-60

4) When using the SELECT statement in PL/SQL, the INTO clause is required and queries can return one or more row.

There are three types of loops: Basic, FOR, and WHILE

7) Implicit cursors are declared by PL/SQL implicitly for all DML and PL/SQL SELECT statements. The Oracle server implicitly opens a cursor to process each SQL statement that is not associated with an explicitly declared cursor.

What kind of attribute needs to be written in the statement below instead of XXXXXXXX? OPEN c_emp_cursor; LOOP FETCH c_emp_cursor INTO v_empno, v_lname; EXIT WHEN c_emp_cursor%XXXXXXXX; DBMS_OUTPUT.PUT_LINE( v_empno ||' '||v_lname); END LOOP;

64) What command prints out value of variable?

65) Which type of an exception below does not exist?

73) What keyword shows the section of program which traps use-defined exceptions?

74) What type of function is used to associate the declared exception with the standard Oracle server error number?

76) Which of the following is NOT an iteration statement supported by PL/SQL:

77) The common SQL*Plus command which enables the results of PL/SQL statements to be displayed is:

78) In a stored procedure, when specifying a string parameter you should use which of these data types:

79) The INTO clause of the SELECT statement:

80) For more complex procedures and functions involving iteration through multiple rows,

81) Which of the following is not a common cursor attribute?

82) The effect of the ROLLBACK command in a transaction is the following:

83) Which of the following is a transaction?

84) What are the characteristics of an anonymous block?

85. Which sections of a PL/SQL block are optional?

Which statements is mandatory in a PL/SQL block?

Which lines of code will correctly display the message "Hello World"?

2) If you must use dynamic SQL, avoid using input concatenation to build the dynamic SQL.

3) By default, a stored procedure executes with the privileges of its owner (definer’s rights).

4) Code that is most vulnerable to SQL Injection attack contains:

5) Application context for a user is fixed and does not change with change of session.

7) Which of the following statements is not true about fine-grained access control?

Call specifications does not:

Use static SQL to avoid SQL injection when all Oracle identifiers are known at the time of code execution.

Statistical Code analysis provides an efficient technique to trace application vulnerability by using ideal and expected parameter values.

Fuzz tool technique is a harsh and rigorous format of testing which uses raw inputs and checks a program's sanctity.

Identify the nature of a table name in the following SELECT statement SELECT TOTAL FROM "ORDERS" WHERE ORD_ID = P_ORDID