Preguntas Tipo Certificación Oracle PL/SQL Developer

Buen día, hoy les comparto preguntas del examen de certificación Oracle PL/SQL del 2015, es bastante probable que esas preguntas cambien con el tiempo, pero les dará una idea de como son estos exámenes.

Puse las preguntas en un archivo TXT porque el archivo pesaba demasiado, a continuación el enlace.

Desacargar Examen PL/SQL Oracle Certification 2015

Muestro un par de preguntas para ver su formato:
1.- Numero de Item (Pregunta)
2.- Alternativas y respuestas
3.- Explicación de la respuesta

Item: 47 (Ref:1Z0-147.6.8.1)

You want to retrieve all the rows and columns from the employee table, store them in a variable, and process them in a PL/SQL block. 

Which type of variable should you create in the PL/SQL block to retrieve all the rows and columns by using a single SELECT statement from the employee table?
_______________________________________________________________________________

a PL/SQL record 
a %ROWTYPE variable 
a PL/SQL table of records 
a PL/SQL table of scalar values

Answer:
  a PL/SQL table of records
________________________________________________________________________________

Explanation:
You should create a PL/SQL table of records because a PL/SQL table of records is similar to a data table and can be used to store records that contain multiple rows of a table. In this scenario, you require storing information retrieved from multiple rows and columns of the employee table and therefore, a PL/SQL table of records should be used.

The PL/SQL record cannot be used in this scenario because the PL/SQL record stores only a single record of a table. In this scenario, you are required to store all the columns and rows of the employee table.

The %ROWTYPE variable cannot be used in this scenario because %ROWTYPE is not a variable but an attribute that can be defined for a variable. The %ROWTYPE attribute does not store data in it but is used to define the variable in which the columns of a table will be retrieved.

The PL/SQL table of scalar values cannot be used in this scenario because you are required to store columns and rows in the table. A PL/SQL table of scalar values can be used to store single values.

Item: 48 (Ref:1Z0-147.7.4.2)

A procedure must insert rows into a table. The name of this table is not known until runtime. Which Oracle supplied package must you use to accomplish this task?
________________________________________________________________________________

DBMS_SQL 
DBMS_PIPE 
DBMS_INSERT 
DBMS_DYNAMIC

Answer:
  DBMS_SQL
________________________________________________________________________________

Explanation:
DBMS_SQL is an Oracle supplied package that allows you to perform Data Definition Language commands (DDL) within a PL/SQL construct. It also allows you to create dynamic SQL. Dynamic SQL is a statement that is not complete in the source code. It is not completed until runtime. For example, the name of a table could be passed through a parameter and used to complete the INSERT statement within this procedure.

DBMS_PIPE is used for communications between sessions in the same instance.

DBMS_INSERT and DBMS_DYNAMIC are not valid Oracle-supplied packages.

Saludos.[full_width]