1Z0-149 Updated Exam Dumps [2024] Practice Valid Exam Dumps Question
1Z0-149 Sample with Accurate & Updated Questions
NEW QUESTION # 24
Which three are true about DDL triggers? (Choose three.)
- A. They can be fired when a table is truncated.
- B. They can be fired when a privilege is granted to a user.
- C. They must be created in a disabled state.
- D. They can be fired either before or after a DDL statement executes.
- E. They must be created in an enabled state.
- F. They fire only when a DDL statement is executed by the owner of the trigger.
- G. They cannot include the WHEN clause.
Answer: A,D,F
NEW QUESTION # 25
Examine these statements:
Which is true?
- A. It will result in a compilation error for protected_proc because calling_proc does not exist.
- B. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
- 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 must be prefixed with the schema name.
Answer: A
NEW QUESTION # 26
Which three are true about functions and procedures? (Choose three.)
- A. Both can have only constants as actual parameters for IN mode parameters.
- B. The ACCESSIBLE BY clause can be used only for procedures.
- C. Both can be invoked from within SQL statements.
- D. In a function, every execution path must lead to a RETURN statement.
- E. In a procedure the RETURN statement cannot specify an expression.
- F. In a function every RETURN statement must specify an expression.
Answer: D,E,F
NEW QUESTION # 27
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- B. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- C. Implicit cursor returns only one record.
- D. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- E. %Isopen is always false in Implicit Cursor.
- F. Explicit cursor can return more than one record.
- G. %Isopen is always false in Explicit Cursor.
Answer: D,E,F
NEW QUESTION # 28
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. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
- D. Any optional parameters can be omitted in the invocation call.
- E. Only trailing optional parameters can be omitted in the invocation call.
Answer: B,D
NEW QUESTION # 29
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. There are no compilation warnings or errors.
- B. It fails compilation.
- C. A performance compilation warning is generated.
- D. An information compilation warning is generated.
- E. A severe compilation warning is generated.
Answer: C
NEW QUESTION # 30
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: C
NEW QUESTION # 31
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure's formal parameters can differ in data type or name.
- B. Each procedure's formal parameters must differ in name.
- C. Each procedure can be a nested subprogram.
- D. Each procedure can be a packaged subprogram.
- E. Each procedure can be a standalone subprogram.
- F. Each procedure must use positional notation to specify the corresponding actual parameters.
- G. Each procedure must use named notation to specify the corresponding actual parameters.
Answer: A,D,F
NEW QUESTION # 32
Which two are true about lexical units? (Choose two.)
- A. A character literal with zero characters has the BOOLEAN value NULL.
- B. Spaces can be embedded in delimiters.
- C. Character literals are case-sensitive.
- D. Identifiers include labels.
- E. All user-defined identifiers must start with an alphabet.
Answer: C,E
NEW QUESTION # 33
Which is true about EXIT and CONTINUE statements?
- A. They must use labels.
- B. They have the same effect on the execution of a loop.
- C. They can be used in any type of loop.
- D. They must have a WHEN condition.
Answer: C
NEW QUESTION # 34
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 4.
- C. It will run successfully producing a result of 5.
- D. It will result in an error because table depts has been altered.
Answer: B
NEW QUESTION # 35
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 set all salaries to 0 if it executes successfully.
- C. It will set all salaries to NULL if it executes successfully.
- D. It will always return a compile time error because it lacks an EXCEPTION section.
- E. It will always return a run time error because v_raise is not initialized.
- F. It will always automatically initialize v_raise.
Answer: C,F
NEW QUESTION # 36
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING clause can be used for remote or parallel deletes.
- 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 INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- E. When using the RETURNING INTO clause, the data returned can be only single column or expression.
Answer: A,D
NEW QUESTION # 37
Which two are true about packages? (Choose two.)
- A. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- C. A package definition must have a specification and body.
- D. Package specifications can be compiled without their bodies.
- E. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
Answer: A,D
NEW QUESTION # 38
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: C
NEW QUESTION # 39
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
- A. DATABASE LINKS
- B. VARIABLES
- C. ANONYMOUS BLOCK
- D. PACKAGES
- E. TRIGGER BODY
Answer: A,D
NEW QUESTION # 40
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 41
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- B. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- C. If set to NATIVE, programs are stored in platform dependent machine code.
- D. The default value is NATIVE.
- E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
Answer: C,E
NEW QUESTION # 42
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. INTO
- B. FETCH
- C. CLOSE
- D. WHEN
- E. OPEN
- F. DECLARE
- G. OPEN-FOR
Answer: B,C,G
NEW QUESTION # 43
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 # 44
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 or string.
- C. INDEX-BY table types can be created in PL/SQL blocks only.
- 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 # 45
......
Oracle 1Z0-149 exam is designed to test the candidate's knowledge and skills in Oracle Database 19c programming with PL/SQL. 1Z0-149 exam is intended for developers who are proficient in SQL and have experience with developing database applications using PL/SQL. Oracle Database 19c: Program with PL/SQL certification is the first step in becoming an Oracle Certified Professional (OCP) in PL/SQL.
Pass Oracle 1Z0-149 Premium Files Test Engine pdf - Free Dumps Collection: https://www.dumpstests.com/1Z0-149-latest-test-dumps.html
1Z0-149 Exam Info and Free Practice Test | DumpsTests: https://drive.google.com/open?id=1o0H_HugguZ82IvDHwEqo-32Ns4CVuMry