Updated Mar-2024 Exam Engine or PDF for the 1Z0-149 Tests Free Updated Today!
Ultimate Guide to Prepare 1Z0-149 with Accurate PDF Questions
NEW QUESTION # 17
Which three are true about PL/SQL subprograms? (Choose three.)
- A. A PL/SQL procedure can invoke an external code block written in a different programming language.
- B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- C. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
- D. Host variables can be referenced inside any PL/SQL subprogram.
- E. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- F. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- G. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
Answer: A,C,E
NEW QUESTION # 18
Examine these statements and output:
The procedure is created successfully.
User ora2 has password ora2 in pdb1.
Which script will execute successfully?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 19
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
- A.
- B.
- C.
- D.
- E.
Answer: D,E
NEW QUESTION # 20
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 return an error at line 3.
- D. It will return an error at line 2.
- E. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
Answer: B
NEW QUESTION # 21
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 22
Which two are true about implicit data type conversion? (Choose two.)
- A. RAW data types are always implicitly converted to a CLOB when used in a query.
- B. Collections can be implicitly converted to records.
- C. ROWIDS are always implicitly converted to a number when used in a query.
- D. Implicit data type conversion can negatively impact performance.
- E. Comparison between character value and a number value always implicitly converts the character value to the number data type.
Answer: D,E
NEW QUESTION # 23
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. It must be specified in the heading of a package body.
- B. It can be used in the declaration of object types.
- C. It must be specified in the heading of a package specification.
- D. The check is enforced by this clause for direct access and access through dynamic SQL.
- E. It can be used for individual procedures and functions declared in a package specification.
Answer: B,E
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 24
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. CLOSE
- B. OPEN-FOR
- C. WHEN
- D. FETCH
- E. OPEN
- F. INTO
- G. DECLARE
Answer: A,B,D
NEW QUESTION # 25
Which three are true about user-defined functions? (Choose three.)
- A. They need not return any values.
- B. They must be defined with at least one parameter.
- C. They can be used in CONNECT BY and START WITH clauses.
- D. They can be executed as standalone commands.
- E. They can appear in the select list of a SELECT statement.
- F. They can be used in ORDER BY and GROUP BY clauses.
- G. Functions can call only other functions.
Answer: C,E,F
NEW QUESTION # 26
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. ERROR
- B. SEVERE
- C. DISABLE
- D. ENABLE
- E. ALL
Answer: B,E
NEW QUESTION # 27
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)
- A. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
- B. The actual parameters must be specified in the same order as the formal parameters are declared.
- C. Any optional parameters can be omitted in the invocation call.
- D. Only trailing optional parameters can be omitted in the invocation call.
- E. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
Answer: B,C
NEW QUESTION # 28
Examine these statements:
Which two are true? (Choose two.)
- A. Neither table will have a row inserted and committed.
- B. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
- C. Only one table will have a row inserted and committed.
- D. The bank_activity_proc will not compile because of the commit.
- E. Both tables will have a row inserted and committed.
Answer: B,C
NEW QUESTION # 29
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 6
- B. line 3
- C. line 2
- D. line 5
- E. line 4
Answer: A
NEW QUESTION # 30
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.API.P1 from the SH schema.
- B. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- C. Call HR.HELPER.H1 from the HR schema.
- D. Call HR.API.P1 from the HR schema.
- E. Call HR.HELPER.H1 from the SH schema.
Answer: A,E
NEW QUESTION # 31
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
- A. The PL/SQL compiler can conditionally include selected parts of a program.
- B. Conditional compilation is disabled by default.
- C. PL/SQL code can be compiled and executed based on different versions of Oracle.
- D. PL/SQL code can be compiled and executed based on different versions of the operating system.
- E. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
Answer: A,C
NEW QUESTION # 32
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 33
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)
- A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
- B. No update happens even though the procedure executes successfully.
- C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
- D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- E. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
Answer: A,E
NEW QUESTION # 34
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 execution of specific portions of the PL/SQL code conditionally.
- C. It is deprecated in Oracle 12c.
- D. It can be used to control a user's privileges on PL/SQL objects at run time.
Answer: A
NEW QUESTION # 35
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. The index can be integer only.
- C. INDEX-BY table types can be created in PL/SQL blocks only.
- D. The index can be integer or string.
- E. INDEX-BY table types can be created with the CREATE TYPE statement.
Answer: C,D
NEW QUESTION # 36
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. Predefined exceptions are globally declared in the standard package.
- D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- E. Internally defined exceptions can be handled only by the OTHERS exception handler.
Answer: A,C
NEW QUESTION # 37
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause returns column values for rows affected by DML statements.
- B. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- C. The RETURNING clause can be used for remote or parallel deletes.
- D. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- E. The RETURNING INTO clause and bulk binds may not be used together.
Answer: B,C
NEW QUESTION # 38
Examine this code:
What will be the outcome?
- A. It will execute successfully and will display the user-defined error message.
- B. It will result in an error as the range of the error code can only be from "-20000 to -20999."
- C. It will result in an error as the range of the error code can only be from "-2000 to -2999."
- D. It will result in an error as the range of the error code can only be from "-1000 to -2000."
Answer: B
NEW QUESTION # 39
Which is true about counter variables in a FOR loop?
- A. It cannot be NULL.
- B. It must explicitly be declared.
- C. It is accessible outside the body of the loop.
- D. It can be modified in the body of the loop.
Answer: A
NEW QUESTION # 40
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 executes and displays output.
- B. It returns an error in line 4.
- C. It returns an error in line 2.
- D. It returns an error in line 9.
Answer: B
NEW QUESTION # 41
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. CBAC cannot be used to secure definer's rights.
- B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- C. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- D. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- E. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
- F. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- G. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
Answer: B,C,D
NEW QUESTION # 42
......
Pass Oracle With ActualVCE Exam Dumps: https://dumps4download.actualvce.com/Oracle/1Z0-149-valid-vce-dumps.html