Oracle
1Z0-146 · Question #10
1Z0-146 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
You executed the following command: SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for the PACK1 package specification and body. You issue the following query to see all unique identifiers with a name, such as %1: SQL> SELECT NAME, SIGNATURE, TYPE FROM USER_IDENTIFIERS WHERE NAME LIKE '%1' AND USAGE='DECLARATION' ORDER BY OBJECT_TYPE, USAGE_ID; View Exhibit2 to examine the output of the query. Which two statements are true about the output of the query? (Choose two.)
Exhibits
Options
- AThe SIGNATURE column has a unique value for an identifier except for identifiers with the same name.
- BThe TYPE column has the value of packages, function or procedures, object types, PL/SQL types,
- CThe query shows the output for only those identifiers for PL/SQL objects, which are created by the
- DThe ALTER SESSION command automatically collects identifier data and the query shows the output
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.