View All 1Z0-149 Actual Free Exam Questions Dec 21, 2023 Updated
Pass Authentic Oracle 1Z0-149 with Free Practice Tests and Exam Dumps
NEW QUESTION # 10
Which two are true about lexical units? (Choose two.)
- A. All user-defined identifiers must start with an alphabet.
- B. Identifiers include labels.
- C. Spaces can be embedded in delimiters.
- D. Character literals are case-sensitive.
- E. A character literal with zero characters has the BOOLEAN value NULL.
Answer: A,D
NEW QUESTION # 11
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 can be used to control a user's privileges on PL/SQL objects at run time.
- D. It is deprecated in Oracle 12c.
Answer: B
NEW QUESTION # 12
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 "-2000 to -2999."
- B. It will execute successfully and will display the user-defined error message.
- C. It will result in an error as the range of the error code can only be from "-1000 to -2000."
- D. It will result in an error as the range of the error code can only be from "-20000 to -20999."
Answer: D
NEW QUESTION # 13
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 # 14
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. SELECT
- B. UPDATE
- C. DROP
- D. ALTER
- E. INSERT
- F. DELETE
- G. CREATE
Answer: A,B,E
NEW QUESTION # 15
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- 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. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
- E. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
Answer: D,E
NEW QUESTION # 16
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. Call HR.HELPER.H1 from the SH schema.
- D. Call HR.HELPER.H1 from the HR schema.
- E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
Answer: A,C
NEW QUESTION # 17
Which two are true about implicit data type conversion? (Choose two.)
- A. RAW data types are always implicitly converted to a CLOB when used in a query.
- B. Collections can be implicitly converted to records.
- C. ROWIDS are always implicitly converted to a number when used in a query.
- D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
- E. Implicit data type conversion can negatively impact performance.
Answer: D,E
NEW QUESTION # 18
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- B. %Isopen is always false in Implicit Cursor.
- C. %Isopen is always false in Explicit Cursor.
- D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- E. Implicit cursor returns only one record.
- F. Explicit cursor can return more than one record.
- G. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
Answer: B,F,G
NEW QUESTION # 19
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. It fails compilation.
- B. An information compilation warning is generated.
- C. A severe compilation warning is generated.
- D. There are no compilation warnings or errors.
- E. A performance compilation warning is generated.
Answer: E
NEW QUESTION # 20
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 might return a run time error depending on who invokes it.
- E. It will set all salaries to 0 if it executes successfully.
- F. It will always return a run time error because v_raise is not initialized.
Answer: A,C
NEW QUESTION # 21
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 22
In which type of trigger can :OLD and :NEW identifiers be used?
- A. AFTER SUSPEND
- B. ROW
- C. AFTER STATEMENT
- D. BEFORE STATEMENT
Answer: B
NEW QUESTION # 23
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 24
Which two are true about collections and RECORD types? (Choose two.)
- A. All collections and RECORD types can be stored in table columns.
- B. Only associative arrays and nested tables can have elements of RECORD type.
- C. Collections and RECORD types are always dense.
- D. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
- E. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
- F. A variable of RECORD type can contain fields of another RECORD type or any collection type.
Answer: B,D
NEW QUESTION # 25
......
New 1Z0-149 Exam Questions Real Oracle Dumps: https://pass4sure.examtorrent.com/1Z0-149-prep4sure-dumps.html
