100% Real & Accurate 1Z0-149 Questions and Answers with Free and Fast Updates [Q38-Q60]

100% Real & Accurate 1Z0-149 Questions and Answers with Free and Fast Updates

Get Unlimited Access to 1Z0-149 Certification Exam Cert Guide

Oracle 1z1-149 exam is a 150-minute computer-based test that consists of 70 multiple-choice questions. 1Z0-149 exam covers a broad range of topics, including PL/SQL program structure, data types, control structures, collections, error handling, and debugging techniques. To pass the exam, candidates must score at least 63% of the total marks.

NEW QUESTION # 38
Which is true about counter variables in a FOR loop?

A. It cannot be NULL.
B. It is accessible outside the body of the loop.
C. It must explicitly be declared.
D. It can be modified in the body of the loop.

Answer: A

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

A. It can be used to obtain information about all identifiers when compiling a procedure.
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 is deprecated in Oracle 12c.

Answer: A

NEW QUESTION # 40
Examine these statements from a block of code:

Which two are true? (Choose two.)

A. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
B. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
C. Only the PRICE column can be updated in the PRODUCTS table.
D. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
E. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

Answer: D,E

NEW QUESTION # 41
Examine these statements which execute successfully:

Which anonymous block executes successfully?

Answer: C

NEW QUESTION # 42
Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

A. A severe compilation warning is generated.
B. It fails compilation.
C. A performance compilation warning is generated.
D. There are no compilation warnings or errors.
E. An information compilation warning is generated.

Answer: C

NEW QUESTION # 43
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

A. an associative array indexed by PLS_INTEGER
B. a record declared in a package specification
C. a predefined PL/SQL-only data type like BOOLEAN
D. an associative array indexed by VARCHAR2
E. a record declared in a procedure
F. a record declared in an anonymous block

Answer: A,B,D

NEW QUESTION # 44
Examine this code:

What will be the outcome?

A. It will result in an error as the range of the error code can only be from "-1000 to -2000."
B. It will result in an error as the range of the error code can only be from "-2000 to -2999."
C. It will execute successfully and will display the user-defined error message.
D. It will result in an error as the range of the error code can only be from "-20000 to -20999."

Answer: D

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

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

Answer: A,B,E

NEW QUESTION # 46
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. DEP_VU must be manually recompiled to successfully run this code.
B. It will run successfully producing a result of 5.
C. It will result in an error because table depts has been altered.
D. It will run successfully producing a result of 4.

Answer: D

NEW QUESTION # 47
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

A. It executes successfully.
B. It results in an error because USERB doesn't have select privilege on USERA.EMP.
C. It results in an error because Authid Current_User is missing from MYPROC.
D. It results in an error because Authid Definer is missing from MYPROC.

Answer: A

NEW QUESTION # 48
Which three are true about DDL triggers? (Choose three.)

A. They can be fired when a privilege is granted to a user.
B. They fire only when a DDL statement is executed by the owner of the trigger.
C. They must be created in a disabled state.
D. They can be fired either before or after a DDL statement executes.
E. They cannot include the WHEN clause.
F. They can be fired when a table is truncated.
G. They must be created in an enabled state.

Answer: B,D,F

NEW QUESTION # 49
Examine this DECLARE section:

Which line will cause an error upon execution?

A. line 5
B. line 3
C. line 4
D. line 6
E. line 2

Answer: D

NEW QUESTION # 50
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

A. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
B. It will fail only at line 7.
C. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
D. It will fail at lines 6 and 7.

Answer: B

NEW QUESTION # 51
Examine these statements:

Which is true?

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

Answer: D

NEW QUESTION # 52
Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
B. Initialization of loan_amount can be done while using this packaged variable in another program.
C. This program unit will compile successfully.
D. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
E. Initialization of min_bal can be done while using this packaged constant in another program.
F. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
G. This will not compile successfully because the min_bal constant must be initialized.

Answer: D,F,G

NEW QUESTION # 53
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It might return a run time error depending on who invokes it.
B. It will always return a run time error because v_raise is not initialized.
C. It will always return a compile time error because it lacks an EXCEPTION section.
D. It will always automatically initialize v_raise.
E. It will set all salaries to 0 if it executes successfully.
F. It will set all salaries to NULL if it executes successfully.

Answer: D,F

NEW QUESTION # 54
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A. 0
B. 1
C. 2
D. 3

Answer: B

NEW QUESTION # 55
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

A. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
B. The RETURNING INTO clause returns column values for rows affected by DML statements.
C. The RETURNING INTO clause and bulk binds may not be used together.
D. The RETURNING clause can be used for remote or parallel deletes.
E. When using the RETURNING INTO clause, the data returned can be only single column or expression.

Answer: A,D

NEW QUESTION # 56
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 2.
B. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
C. It will return an error at line 3.
D. It will return an error at line 8.
E. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

Answer: B

NEW QUESTION # 57
Which three are true about anonymous blocks and subprograms? (Choose three.)

A. FUNCTION subprograms must be called and passed through one or more parameters.
B. Anonymous blocks cannot use packaged variables.
C. A FUNCTION subprogram must return one or more values.
D. Anonymous blocks must always start with the Declare keyword.
E. PROCEDURE subprograms can accept parameters.
F. Named subprograms are stored in the database server.
G. Named subprograms cannot be called from other packages.

Answer: C,E,F

NEW QUESTION # 58
Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?