Page: 1
/ 5
Total 65 questions
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It is deprecated in Oracle 12c.
- B. It can be used to obtain information about all identifiers when compiling a procedure.
- C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- D. It can be used to control a user's privileges on PL/SQL objects at run time.
Answer : B
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. DECLARE
- B. OPEN
- C. INTO
- D. OPEN-FOR
- E. FETCH
- F. WHEN
- G. CLOSE
Answer : DEG
Which is true about counter variables in a FOR loop?
- A. It must explicitly be declared.
- B. It can be modified in the body of the loop.
- C. It cannot be NULL.
- D. It is accessible outside the body of the loop.
Answer : C
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:
EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)
- A. Call HR.HELPER.H1 from the HR schema.
- B. Call HR.HELPER.H1 from the SH schema.
- C. Call HR.API.P1 from the HR schema.
- D. Call HR.API.P1 from the SH schema.
- E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
Answer : BD
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
-
A.
-
B.
-
C.
-
D.
Answer : D
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure can be a nested subprogram.
- B. Each procedure's formal parameters can differ in data type or name.
- C. Each procedure must use named notation to specify the corresponding actual parameters.
- D. Each procedure's formal parameters must differ in name.
- E. Each procedure can be a packaged subprogram.
- F. Each procedure must use positional notation to specify the corresponding actual parameters.
- G. Each procedure can be a standalone subprogram.
Answer : BEF
Which two are true about packages? (Choose two.)
- A. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- C. Package specifications can be compiled without their bodies.
- D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
- E. A package definition must have a specification and body.
Answer : AC
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- B. The RETURNING INTO clause and bulk binds may not be used together.
- C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- D. The RETURNING INTO clause returns column values for rows affected by DML statements.
- E. The RETURNING clause can be used for remote or parallel deletes.
Answer : CE
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:
What is true about the result?
- A. It returns an error in line 2.
- B. It returns an error in line 4.
- C. It returns an error in line 9.
- D. It executes and displays output.
Answer : B
Which two are true about lexical units? (Choose two.)
- A. Character literals are case-sensitive.
- B. Spaces can be embedded in delimiters.
- C. Identifiers include labels.
- D. A character literal with zero characters has the BOOLEAN value NULL.
- E. All user-defined identifiers must start with an alphabet.
Answer : AE
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- C. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
- D. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
- E. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- F. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- G. CBAC cannot be used to secure definer's rights.
Answer : BEF
Examine this code:
What will be the outcome?
- A. It will execute successfully and will display the user-defined error message.
- B. It will result in an error as the range of the error code can only be from “-20000 to -20999.”
- C. It will result in an error as the range of the error code can only be from “-1000 to -2000.”
- D. It will result in an error as the range of the error code can only be from “-2000 to -2999."
Answer : B
Which block of code displays the error message “Incorrect price value”?
-
A.
-
B.
-
C.
-
D.
Answer : B
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
- B. Only the PRICE column can be updated in the PRODUCTS table.
- C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
Answer : AD
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
- B. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
- C. It will fail at lines 6 and 7.
- D. It will fail only at line 7.
Answer : D
30 days access 