[Nov-2023] Use Real 1Z0-149 Dumps Free Sample Questions and Practice Test Engine
Pass Oracle 1Z0-149 exam - questions - convert Tets Engine to PDF
Oracle 1z1-149 certification exam is a comprehensive assessment of a candidate’s skills and knowledge in PL/SQL programming, covering a range of topics such as PL/SQL program units, packages, triggers, error handling, and performance tuning. 1Z0-149 exam consists of 80 multiple-choice questions, and candidates are given 120 minutes to complete the exam. To pass the exam, candidates must score at least 66%, which requires a deep understanding of PL/SQL programming concepts and hands-on experience in developing PL/SQL applications.
NEW QUESTION # 15
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
- B. If set to NATIVE, programs are stored in platform dependent machine code.
- C. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- D. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- E. The default value is NATIVE.
Answer: A,B
NEW QUESTION # 16
Which two are true about lexical units? (Choose two.)
- A. Character literals are case-sensitive.
- B. A character literal with zero characters has the BOOLEAN value NULL.
- C. Identifiers include labels.
- D. Spaces can be embedded in delimiters.
- E. All user-defined identifiers must start with an alphabet.
Answer: A,E
NEW QUESTION # 17
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 # 18
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 # 19
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 # 20
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 ORA41.
- B. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
- C. No update happens even though the procedure executes successfully.
- D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
Answer: B,E
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
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 23
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?
- A. Error in inner block Error in calling block
- B. Error in inner block Error in outer block Error in calling block
- C. Error in inner block
- D. Error in inner block Error in outer block
Answer: C
NEW QUESTION # 24
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 and bulk binds may not be used together.
- 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 returns column values for rows affected by DML statements.
Answer: A,C
NEW QUESTION # 25
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
- A. A deterministic function's results always depend on the state of session variables.
- B. The PARALLEL_ENABLE clause can be specified for a nested function.
- C. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
- D. The NOCOPY hint asks the compiler to pass the actual parameters by value.
- E. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
- F. A function is deterministic if it always returns the same result for a specific combination of input values.
- G. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
Answer: C,E,F
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 must be specified in the heading of a package body.
- D. It can be used for individual procedures and functions declared in a package specification.
- E. It must be specified in the heading of a package specification.
Answer: B,D
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 27
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.HELPER.H1 from the HR schema.
- B. Call HR.API.P1 from the HR schema.
- C. Call HR.API.P1 from the SH schema.
- D. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- E. Call HR.HELPER.H1 from the SH schema.
Answer: C,E
NEW QUESTION # 28
Which is the correct method to implement a local subprogram in an anonymous block?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 29
Which two are true about exception handling? (Choose two.)
- A. Internally defined exceptions can be handled only by the OTHERS exception handler.
- B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- C. All declared exceptions are raised implicitly by the runtime system.
- D. Predefined exceptions are globally declared in the standard package.
- E. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
Answer: D,E
NEW QUESTION # 30
Which statement is true about user-defined records?
- A. The number of fields must match the number of columns in a table.
- B. Field names must match selected column names.
- C. They can be returned from a function.
- D. Field types must match column types.
Answer: A
NEW QUESTION # 31
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
- B. This program unit will compile successfully.
- C. Initialization of loan_amount can be done while using this packaged variable in another program.
- D. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
- E. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- F. This will not compile successfully because the min_bal constant must be initialized.
- G. Initialization of min_bal can be done while using this packaged constant in another program.
Answer: A,D,F
NEW QUESTION # 32
......
Oracle 1z1-149 exam is a certification exam that aims to test the programming skills of individuals in the latest version of Oracle Database, which is Oracle Database 19c. 1Z0-149 exam is designed for individuals who have a solid understanding of PL/SQL and who have experience in developing database applications using PL/SQL. 1Z0-149 exam is also aimed at individuals who are looking to become certified Oracle Database 19c PL/SQL Developers.
Pass Your 1Z0-149 Exam Easily - Real 1Z0-149 Practice Dump Updated Nov 10, 2023: https://www.itpass4sure.com/1Z0-149-practice-exam.html
2023 Realistic Verified Free Oracle 1Z0-149 Exam Questions: https://drive.google.com/open?id=1d0RBBNFCqRgVyMLlwKYS0es_Y72F0i4s
