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.)

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.)

Accepted Answer

B. The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, C. The query shows the output for only those identifiers for PL/SQL objects, which are created by the

Answer

A. The SIGNATURE column has a unique value for an identifier except for identifiers with the same name.

Answer

D. The ALTER SESSION command automatically collects identifier data and the query shows the output

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…

Question

Exhibits

Options

How the community answered

Community Discussion