Free Oracle 1Z0-149 Exam 2023 Practice Materials Collection [Q33-Q48]

Free Oracle 1Z0-149 Exam 2023 Practice Materials Collection

1Z0-149 Exam Info and Free Practice Test All-in-One Exam Guide Oct-2023

Oracle 1z1-149 exam is designed for individuals who have experience with developing and programming applications using PL/SQL. 1Z0-149 exam focuses on testing the proficiency level of professionals in creating efficient and scalable database applications using Oracle Database 19c. 1Z0-149 exam consists of 70 multiple-choice questions, and candidates have 105 minutes to complete it.

NEW QUESTION # 33
Which three are true about the procedure overloading feature? (Choose three.)

A. Each procedure's formal parameters must differ in name.
B. Each procedure's formal parameters can differ in data type or name.
C. Each procedure can be a packaged subprogram.
D. Each procedure must use named notation to specify the corresponding actual parameters.
E. Each procedure can be a nested subprogram.
F. Each procedure can be a standalone subprogram.
G. Each procedure must use positional notation to specify the corresponding actual parameters.

Answer: B,C,G

NEW QUESTION # 34
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

A. Conditional compilation is disabled by default.
B. The PL/SQL compiler can conditionally include selected parts of a program.
C. PL/SQL code can be compiled and executed based on different versions of Oracle.
D. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
E. PL/SQL code can be compiled and executed based on different versions of the operating system.

Answer: B,C

NEW QUESTION # 35
Which three statements can process a dynamic multi-row query? (Choose three.)

A. INTO
B. WHEN
C. OPEN-FOR
D. OPEN
E. FETCH
F. CLOSE
G. DECLARE

Answer: C,E,F

NEW QUESTION # 36
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

A. It will result in an error because table depts has been altered.
B. DEP_VU must be manually recompiled to successfully run this code.
C. It will run successfully producing a result of 4.
D. It will run successfully producing a result of 5.

Answer: C

NEW QUESTION # 37
Which three are true about functions and procedures? (Choose three.)

A. In a procedure the RETURN statement cannot specify an expression.
B. Both can have only constants as actual parameters for IN mode parameters.
C. Both can be invoked from within SQL statements.
D. In a function every RETURN statement must specify an expression.
E. The ACCESSIBLE BY clause can be used only for procedures.
F. In a function, every execution path must lead to a RETURN statement.

Answer: A,D,F

NEW QUESTION # 38
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 SH schema.
B. Call HR.API.P1 from the HR schema.
C. Call HR.HELPER.H1 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: A,D

NEW QUESTION # 39
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 9.
C. It returns an error in line 4.
D. It executes and displays output.

Answer: C

NEW QUESTION # 40
Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

Answer: C

NEW QUESTION # 41
Which two are true about exception handling? (Choose two.)

A. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
B. All declared exceptions are raised implicitly by the runtime system.
C. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
D. Internally defined exceptions can be handled only by the OTHERS exception handler.
E. Predefined exceptions are globally declared in the standard package.

Answer: A,E

NEW QUESTION # 42
Examine these statements:

Which is true?

A. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
B. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
C. It will result in a compilation error for protected_proc because calling_proc does not exist.
D. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

Answer: C

NEW QUESTION # 43
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

A. The default value is NATIVE.
B. If set to NATIVE, programs are stored in platform dependent machine code.
C. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
D. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

Answer: B,E

NEW QUESTION # 44
Which is true about the PLSCOPE_SETTINGS parameter?

A. It is deprecated in Oracle 12c.
B. It can be used to control a user's privileges on PL/SQL objects at run time.
C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
D. It can be used to obtain information about all identifiers when compiling a procedure.

Answer: D

NEW QUESTION # 45
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

A. It will return an error at line 8.
B. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
C. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
D. It will return an error at line 3.
E. It will return an error at line 2.

Answer: B

NEW QUESTION # 46
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

Answer: D

NEW QUESTION # 47
Which two are true about INDEX-BY tables? (Choose two.)

A. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
B. INDEX-BY table types can be created in PL/SQL blocks only.
C. The index can be integer or string.
D. INDEX-BY table types can be created with the CREATE TYPE statement.
E. The index can be integer only.

Answer: B,C

NEW QUESTION # 48
......

Pass Oracle 1Z0-149 Actual Free Exam Q&As Updated Dump: https://www.actual4labs.com/Oracle/1Z0-149-actual-exam-dumps.html

Latest 1Z0-149 Actual Free Exam Updated 67 Questions: https://drive.google.com/open?id=1sphdaRKbGgmDUHEPRHWdS-f0uUzi8xZM