Pass 1z1-149 Exam in First Attempt Guaranteed 100% Cover Real Exam Questions [Aug-2023]
Valid 1z1-149 test answers & Oracle 1z1-149 exam pdf
Oracle 1Z0-149 certification exam is designed for individuals who want to demonstrate their skills and knowledge in working with the Oracle Database 19c using PL/SQL programming language. 1z1-149 exam is intended for developers, database administrators, and other IT professionals who work with Oracle databases and want to enhance their career prospects in the field.
NEW QUESTION # 13
Which three are true about user-defined functions? (Choose three.)
- A. They can be used in CONNECT BY and START WITH clauses.
- B. They can appear in the select list of a SELECT statement.
- C. Functions can call only other functions.
- D. They can be executed as standalone commands.
- E. They must be defined with at least one parameter.
- F. They can be used in ORDER BY and GROUP BY clauses.
- G. They need not return any values.
Answer: A,B,F
NEW QUESTION # 14
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. Object privileges to execute a replaced function are retained by those users who had the privileges.
- B. Function based indexes remain usable when replacing the function on which the index depends.
- C. This clause can be used only for procedures and functions.
- D. A function definition can be modified without dropping and re-creating it.
- E. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
Answer: A,D
NEW QUESTION # 15
Which three are true about functions and procedures? (Choose three.)
- A. Both can be invoked from within SQL statements.
- B. In a procedure the RETURN statement cannot specify an expression.
- C. The ACCESSIBLE BY clause can be used only for procedures.
- D. In a function every RETURN statement must specify an expression.
- E. Both can have only constants as actual parameters for IN mode parameters.
- F. In a function, every execution path must lead to a RETURN statement.
Answer: B,D,F
NEW QUESTION # 16
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 predefined PL/SQL-only data type like BOOLEAN
- B. an associative array indexed by VARCHAR2
- C. a record declared in a procedure
- D. an associative array indexed by PLS_INTEGER
- E. a record declared in an anonymous block
- F. a record declared in a package specification
Answer: B,D,F
NEW QUESTION # 17
Examine the EMPLOYEES table structure:
Now, examine this code:
Which statement is true about the result of executing this block?
- A. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
- B. It will return an error at line 3.
- C. It will return an error at line 2.
- 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 # 18
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- B. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- C. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- D. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
- E. Only the PRICE column can be updated in the PRODUCTS table.
Answer: B,D
NEW QUESTION # 19
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. It will run successfully producing a result of 5.
- B. It will run successfully producing a result of 4.
- C. It will result in an error because table depts has been altered.
- D. DEP_VU must be manually recompiled to successfully run this code.
Answer: B
NEW QUESTION # 20
Which three statements are true about passing parameters to subprograms? (Choose three.)
- A. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
- B. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
- D. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
- E. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
- F. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
- G. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
Answer: C,E,G
NEW QUESTION # 21
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: A
NEW QUESTION # 22
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 23
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause and bulk binds may not be used together.
- 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 returns column values for rows affected by DML statements.
Answer: B,C
NEW QUESTION # 24
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will fail at lines 6 and 7.
- B. It will fail only at line 7.
- C. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
- D. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
Answer: B
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: A
NEW QUESTION # 26
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. INDEX-BY table types can be created in PL/SQL blocks only.
- C. INDEX-BY table types can be created with the CREATE TYPE statement.
- D. The index can be integer only.
- E. The index can be integer or string.
Answer: B,E
NEW QUESTION # 27
Which three are true about anonymous blocks and subprograms? (Choose three.)
- A. Anonymous blocks must always start with the Declare keyword.
- B. FUNCTION subprograms must be called and passed through one or more parameters.
- C. A FUNCTION subprogram must return one or more values.
- D. Named subprograms are stored in the database server.
- E. Named subprograms cannot be called from other packages.
- F. PROCEDURE subprograms can accept parameters.
- G. Anonymous blocks cannot use packaged variables.
Answer: C,D,F
NEW QUESTION # 28
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,E
NEW QUESTION # 29
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. Call HR.API.P1 from the HR schema.
- C. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- D. Call HR.HELPER.H1 from the SH schema.
- E. Call HR.HELPER.H1 from the HR schema.
Answer: A,D
NEW QUESTION # 30
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- B. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- 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 # 31
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 or procedure only.
- C. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- D. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- E. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- F. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- G. CBAC cannot be used to secure definer's rights.
Answer: C,E,F
NEW QUESTION # 32
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. Implicit cursor returns only one record.
- B. Explicit cursor can return more than one record.
- C. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- D. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- E. %Isopen is always false in Explicit Cursor.
- F. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- G. %Isopen is always false in Implicit Cursor.
Answer: B,F,G
NEW QUESTION # 33
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- B. It can be used to obtain information about all identifiers when compiling a procedure.
- 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: B
NEW QUESTION # 34
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. DISABLE
- B. SEVERE
- C. ERROR
- D. ALL
- E. ENABLE
Answer: B,D
NEW QUESTION # 35
Which two are true about lexical units? (Choose two.)
- A. A character literal with zero characters has the BOOLEAN value NULL.
- B. Identifiers include labels.
- C. Spaces can be embedded in delimiters.
- D. All user-defined identifiers must start with an alphabet.
- E. Character literals are case-sensitive.
Answer: D,E
NEW QUESTION # 36
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 outer block Error in calling block
- B. Error in inner block
- C. Error in inner block Error in outer block
- D. Error in inner block Error in calling block
Answer: B
NEW QUESTION # 37
......
Oracle 1Z0-149 is a certification exam that validates the skills of individuals in programming with PL/SQL. It is designed for database developers, programmers, and administrators who want to demonstrate their expertise in PL/SQL programming. 1z1-149 exam is based on Oracle Database 19c, which is the latest version of Oracle's flagship database management system.
1z1-149 Exam Questions – Valid 1z1-149 Dumps Pdf: https://www.examcost.com/1z1-149-practice-exam.html
Verified 1z1-149 dumps Q&As - Pass Guarantee: https://drive.google.com/open?id=1KhGcGNxL9iD_MEMBwal4IuS9_BHB5CBj
