Get the Oracle SQL and PL-SQL 1z0-148 Certification Exam.
” Oracle Database 12c: Advanced PL/SQL “: https://www.pass4itsure.com/1z0-148.html (Q&As: 211). Free Oracle SQL and PL-SQL 1z0-148 exam practice test. Improve your skills and exam experience!
Get the latest Oracle SQL and PL-SQL 1z0-148 pdf
[PDF] Free Oracle 1z0-148 pdf dumps download from Google Drive: https://drive.google.com/open?id=1YbIpcFpcOsi0RbzlyAHF62PoBlbjQkZI
Valid information provided by Oracle officials
Oracle Database: Advanced PL/SQL | 1Z0-148: https://education.oracle.com/oracle-database-advanced-pl-sql/pexam_1Z0-148
The latest Oracle SQL and PL-SQL 1z0-148 exam practice questions test your strength
QUESTION 1
Which two statements are correct in Oracle Database 12c?
A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.
B. Native compilation is the default compilation method
C. Native compilation should be used during development.
D. Natively compiles code is stored in the SYSTEM tablespace.
E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile
it.
Correct Answer: DE
QUESTION 2
Examine this external function declaration:
CREATE FUNCTION compare_and_sum(p1 PLS_INTEGER, p2 IN PLS_INTEGER, p3 IN OUT NUMBER)
RETURN PLS_INTEGER
AS LANGUAGE C LIBRARY mylib
NAME “compareAndSum” WITH CONTEXT;
Which C function does it publish?
A. OCINumber * compareAndSum (OCIExtProcContext *ctx, OCINumber *p1, OCINumber *p2, OCINumber *p3);
B. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber *p3);
C. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber *p3);
D. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber p3);
E. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int p3);
F. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int* p3);
G. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber p3);
Correct Answer: F
QUESTION 3
Identify three guidelines for the DBMS_ASSERT package. (Choose three.)
A. Prefix all calls to DBMS_ASSERT with the SYS schema name.
B. Embed DBMS_ASSERT verification routines inside the injectable string.
C. Escape single quotes when you use the ENQUOTE_LITERAL procedure.
D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.
E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT
package.
Correct Answer: ACD
QUESTION 4
DATA_FILES is a directory object that contains the DETAILS.TXT text file.
You have the required permissions to access the directory object.
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that
currently has no rows. The PL/SQL block results in an error.
What correction must be done to ensure the PL/SQL block executes successfully?
A. The L_OUT variable must be initialized to an empty locator.
B. The L_OUT variable has to be declared as a temporary LOB.
C. The A_CLOB variable has to be declared as a temporary LOB.
D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the
locator.
Correct Answer: D
QUESTION 5
You issue this command to create a table called LOB_STORE:
CREATE TABLE lob_store
(lob_id NUMBER(3),
photo BLOB DEFAULT EMPTY_BLOB(),
cv CLOB DEFAULT NULL,
ext_file BFILE DEFAULT NULL)
/
What is the outcome?
A. The table is created successfully.
B. It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
C. It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
D. It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.
Correct Answer: A
QUESTION 6
Which statement is true about internal and external LOBs?
A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.
B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
C. Internal and external LOBs can be written using DBMS_LOB.
D. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
E. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.
Correct Answer: DE
QUESTION 7
View the Exhibit and examine the PL/SQL code.
The code takes a long time to execute. What would you recommend to improve performance?
A. using NOT NULL constraint when declaring the variables
B. using the BULK COLLECT option for query instead of cursor
C. using WHILE.. END LOOP instead of FOR .. END LOOP
D. using the SIMPLE_INTEGER data type instead of the NUMBER data type
Correct Answer: B
QUESTION 8
View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an
associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = \\’SA_REP\\’;
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?
A. Replace EMP_CV in line 3 with employees.salary%TYPE.
B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
Correct Answer: A
QUESTION 9
Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a
temporary LOB? (Choose two.)
A. It can be used for transforming data in permanent internal LOBs.
B. It is used only for the migration of BasicFile to the SecureFile format.
C. It is used only for the migration of the LONG column to the LOB column.
D. It creates a LOB variable that is not associated with any table and is stored in the user\\’s temporary tablespace.
E. It creates a LOB variable that is associated with a specific table and is temporarily stored in the user\\’s default
tablespace.
Correct Answer: AD
QUESTION 10
You have an external C procedure stored in a dynamic-link library (DLL). The C procedure takes an integer as argument
and returns an integer. You want to invoke the C procedure through a PL/SQL program.
View the Exhibit.
Which statement is true about the C_OUTPUT PL/SQL program?
A. It invokes the external C procedure.
B. It only publishes the external C procedure.
C. It fails because the external C procedure is not published.
D. It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.
Correct Answer: C
QUESTION 11
View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an
associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = \\’SA_REP\\’;
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?
A. Replace EMP_CV in line 3 with employees.salary%TYPE.
B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
Correct Answer: A
QUESTION 12
Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure?
(Choose two.)
A. You can describe remote objects.
B. You can describe anonymous PL/SQL blocks.
C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D. You can obtain information about the position, name, and data type of the arguments of a procedure.
Correct Answer: CD
QUESTION 13
View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the
procedure. Which three statements are appropriate for protecting the code in the procedure from SQL injection?
(Choose three.)
A. Explicitly validate the identifier length limit.
B. Add AUTHID DEFINER to the definition of the procedure.
C. Use PRAGMA RESTRICT_REFERENCES in the procedure.
D. Filter out control characters in user-supplied identifier names.
E. Use the object ID of the table from the data dictionary to build the trigger name.
Correct Answer: ADE
Follow Pass4itsure free sharing of YouTube channels
We offer more ways to make it easier for everyone to learn, and YouTube is the best tool in the video. Follow channels: https://www.youtube.com/channel/UCTP5RClZrtMxtRkSvIag0DQ/videos get more useful exam content.
Watch the Oracle SQL and PL-SQL 1z0-148 video tutorial online
Share Pass4itsure coupons for free
Reasons to choose Pass4itsure
Pass4itsure offers the latest exam practice questions and answers free of charge! Update all exam questions throughout the year,
with a number of professional exam experts! To make sure it works! Maximum pass rate, best value for money!
Helps you pass the exam easily on your first attempt.
This maybe you’re interested
Summarize:
The latest Oracle SQL and PL-SQL 1z0-148 dumps, online 1z0-148 practice test questions, pass the 1z0-148 exam: https://www.pass4itsure.com/1z0-148.html (Q&As: 211). Boost exam skills Share 1z0-148 pdf and 1z0-148 Youtube videos for free