Pass Oracle Database PL/SQL Developer Certified Professional 1Z0-149 exam [Dec 19, 2023] Updated 67 Questions
Oracle 1Z0-149 Actual Questions and 100% Cover Real Exam Questions
Oracle 1z1-149 certification exam is designed for individuals who are interested in becoming certified as an Oracle Database 19c PL/SQL Developer. 1Z0-149 exam is intended to test the candidate's knowledge and skills in creating, debugging, and managing PL/SQL programs. Oracle Database 19c: Program with PL/SQL certification is ideal for database developers, database administrators, and anyone interested in working with Oracle databases.
Oracle 1Z0-149 certification exam is designed for individuals who want to demonstrate their expertise in programming with PL/SQL in Oracle Database 19c. Oracle Database 19c: Program with PL/SQL certification exam is ideal for developers, database administrators, and architects who want to validate their skills and knowledge in the latest version of Oracle Database.
NEW QUESTION # 15
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 # 16
Which is the correct method to implement a local subprogram in an anonymous block?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 17
Which three are true about DDL triggers? (Choose three.)
- A. They must be created in an enabled state.
- B. They can be fired when a table is truncated.
- C. They can be fired when a privilege is granted to a user.
- D. They cannot include the WHEN clause.
- E. They must be created in a disabled state.
- F. They can be fired either before or after a DDL statement executes.
- G. They fire only when a DDL statement is executed by the owner of the trigger.
Answer: B,F,G
NEW QUESTION # 18
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:
Now, examine this block of code:
Which two lines each result in a compilation error? (Choose two.)
- A. line 3
- B. line 1
- C. line 2
- D. line 6
- E. line 8
- F. line 7
Answer: B,D
NEW QUESTION # 19
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)
- A. Only trailing optional parameters can be omitted in the invocation call.
- B. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
- C. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
- D. Any optional parameters can be omitted in the invocation call.
- E. The actual parameters must be specified in the same order as the formal parameters are declared.
Answer: D,E
NEW QUESTION # 20
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 # 21
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. a record declared in a package specification
- B. a record declared in a procedure
- C. an associative array indexed by VARCHAR2
- D. a record declared in an anonymous block
- E. a predefined PL/SQL-only data type like BOOLEAN
- F. an associative array indexed by PLS_INTEGER
Answer: A,C,F
NEW QUESTION # 22
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 must use positional notation to specify the corresponding actual parameters.
- 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 standalone subprogram.
- F. Each procedure's formal parameters must differ in name.
- G. Each procedure can be a nested subprogram.
Answer: A,B,C
NEW QUESTION # 23
Which two blocks of code display a numerical zero? (Choose two.)
- A.
- B.
- C.
- D.
Answer: B,D
NEW QUESTION # 24
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
- 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. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- D. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- E. Only the PRICE column can be updated in the PRODUCTS table.
Answer: A,C
NEW QUESTION # 25
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It is deprecated in Oracle 12c.
- B. It can be used to obtain information about all identifiers when compiling a procedure.
- C. It can be used to control a user's privileges on PL/SQL objects at run time.
- D. It can be used to control execution of specific portions of the PL/SQL code conditionally.
Answer: B
NEW QUESTION # 26
Which two are true about implicit data type conversion? (Choose two.)
- A. Collections can be implicitly converted to records.
- B. RAW data types are always implicitly converted to a CLOB when used in a query.
- C. Comparison between character value and a number value always implicitly converts the character value to the number data type.
- D. Implicit data type conversion can negatively impact performance.
- E. ROWIDS are always implicitly converted to a number when used in a query.
Answer: C,D
NEW QUESTION # 27
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: A,C
NEW QUESTION # 28
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. 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.
- 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. 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 directly granted to its owner.
- 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,D,E
NEW QUESTION # 29
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. SELECT
- B. INSERT
- C. CREATE
- D. DELETE
- E. ALTER
- F. UPDATE
- G. DROP
Answer: A,B,F
NEW QUESTION # 30
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. A performance compilation warning is generated.
- C. It fails compilation.
- D. There are no compilation warnings or errors.
- E. An information compilation warning is generated.
Answer: B
NEW QUESTION # 31
Which is true about EXIT and CONTINUE statements?
- A. They can be used in any type of loop.
- B. They must use labels.
- C. They must have a WHEN condition.
- D. They have the same effect on the execution of a loop.
Answer: A
NEW QUESTION # 32
Which two are true about packages? (Choose two.)
- A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- B. Package specifications can be compiled without their bodies.
- C. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
- E. A package definition must have a specification and body.
Answer: B,C
NEW QUESTION # 33
......
Oracle 1Z0-149 Real 2023 Braindumps Mock Exam Dumps: https://www.lead1pass.com/Oracle/1Z0-149-practice-exam-dumps.html
1Z0-149 Free Exam Questions and Answers PDF Updated on Dec-2023: https://drive.google.com/open?id=1LChe-S2Mz6ieQgtRUITOlJdUVNZQRZay