1Z0-149 Dumps Free Test Engine Player Verified Updated [Mar 20, 2024]
Q&As with Explanations Verified & Correct Answers
NEW QUESTION # 15
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 "-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 execute successfully and will display the user-defined error message.
Answer: B
NEW QUESTION # 16
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: B,D
NEW QUESTION # 17
In which type of trigger can :OLD and :NEW identifiers be used?
- A. AFTER SUSPEND
- B. AFTER STATEMENT
- C. ROW
- D. BEFORE STATEMENT
Answer: C
NEW QUESTION # 18
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- B. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- C. CBAC cannot be used to secure definer's rights.
- D. 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.
- E. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- F. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- G. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
Answer: A,B,F
NEW QUESTION # 19
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 20
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 21
Examine this table in the SH schema:
User SH executes this code:
The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?
- A.
- B.
- C.
- D.
- E.
Answer: A
NEW QUESTION # 22
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 23
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. Function based indexes remain usable when replacing the function on which the index depends.
- B. A function definition can be modified without dropping and re-creating it.
- C. Object privileges to execute a replaced function are retained by those users who had the privileges.
- D. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
- E. This clause can be used only for procedures and functions.
Answer: B,C
NEW QUESTION # 24
Which two are true about exception handling? (Choose two.)
- A. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- B. Predefined exceptions are globally declared in the standard package.
- C. Internally defined exceptions can be handled only by the OTHERS exception handler.
- D. All declared exceptions are raised implicitly by the runtime system.
- E. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
Answer: B,E
NEW QUESTION # 25
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: C
NEW QUESTION # 26
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. The check is enforced by this clause for direct access and access through dynamic SQL.
- B. It can be used in the declaration of object types.
- C. It can be used for individual procedures and functions declared in a package specification.
- D. It must be specified in the heading of a package specification.
- E. It must be specified in the heading of a package body.
Answer: B,C
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 27
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 3.
- B. It will return an error at line 2.
- C. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
- D. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
- E. It will return an error at line 8.
Answer: D
NEW QUESTION # 28
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- B. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- C. Only the PRICE column can be updated in the PRODUCTS table.
- D. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- E. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
Answer: A,E
NEW QUESTION # 29
Which three statements are true about passing parameters to subprograms? (Choose three.)
- A. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
- B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
- C. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
- D. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- E. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
- F. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
- G. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
Answer: B,C,F
NEW QUESTION # 30
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
- A. It will always automatically initialize v_raise.
- B. It will always return a compile time error because it lacks an EXCEPTION section.
- C. It will set all salaries to NULL if it executes successfully.
- D. It will always return a run time error because v_raise is not initialized.
- E. It might return a run time error depending on who invokes it.
- F. It will set all salaries to 0 if it executes successfully.
Answer: A,C
NEW QUESTION # 31
Which two are true about implicit data type conversion? (Choose two.)
- A. ROWIDS are always implicitly converted to a number when used in a query.
- B. Implicit data type conversion can negatively impact performance.
- C. Collections can be implicitly converted to records.
- D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
- E. RAW data types are always implicitly converted to a CLOB when used in a query.
Answer: B,D
NEW QUESTION # 32
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. Named subprograms are stored in the database server.
- C. PROCEDURE subprograms can accept parameters.
- D. Anonymous blocks cannot use packaged variables.
- E. A FUNCTION subprogram must return one or more values.
- F. Named subprograms cannot be called from other packages.
- G. Anonymous blocks must always start with the Declare keyword.
Answer: B,C,E
NEW QUESTION # 33
Which three are true about PL/SQL subprograms? (Choose three.)
- A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
- B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- D. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- E. 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.
- F. A PL/SQL procedure can invoke an external code block written in a different programming language.
- G. Host variables can be referenced inside any PL/SQL subprogram.
Answer: A,C,F
NEW QUESTION # 34
Which two are true about lexical units? (Choose two.)
- A. A character literal with zero characters has the BOOLEAN value NULL.
- B. Character literals are case-sensitive.
- C. Spaces can be embedded in delimiters.
- D. Identifiers include labels.
- E. All user-defined identifiers must start with an alphabet.
Answer: B,E
NEW QUESTION # 35
......
Verified 1Z0-149 dumps Q&As Latest 1Z0-149 Download: https://www.testkingpass.com/1Z0-149-testking-dumps.html
1Z0-149 Dumps with Free 365 Days Update Fast Exam Updates: https://drive.google.com/open?id=1Ti50mXNHNbhYEeDzzwr716YPxeViJg0C