Get 2024 Updated Free Oracle 1Z0-149 Exam Questions and Answer
1Z0-149 Dumps PDF and Test Engine Exam Questions
NEW QUESTION # 30
Which three are true about user-defined functions? (Choose three.)
- A. They must be defined with at least one parameter.
- B. They can be used in ORDER BY and GROUP BY clauses.
- C. They can be executed as standalone commands.
- D. They need not return any values.
- E. They can be used in CONNECT BY and START WITH clauses.
- F. Functions can call only other functions.
- G. They can appear in the select list of a SELECT statement.
Answer: B,E,G
NEW QUESTION # 31
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 32
Examine these statements:
Which is true?
- A. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
- B. It will result in a compilation error for protected_proc because calling_proc does not exist.
- 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: B
NEW QUESTION # 33
Examine this code:
What will be the outcome?
- A. It will execute successfully and will display the user-defined error message.
- B. It will result in an error as the range of the error code can only be from "-20000 to -20999."
- 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 "-2000 to -2999."
Answer: B
NEW QUESTION # 34
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
- C. Error in inner block
- D. Error in inner block Error in outer block Error in calling block
Answer: C
NEW QUESTION # 35
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
- A. DATABASE LINKS
- B. VARIABLES
- C. TRIGGER BODY
- D. PACKAGES
- E. ANONYMOUS BLOCK
Answer: A,D
NEW QUESTION # 36
Which three are true about PL/SQL subprograms? (Choose three.)
- A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
- B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- C. Host variables can be referenced inside any PL/SQL subprogram.
- D. A PL/SQL procedure can invoke an external code block written in a different programming language.
- E. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- F. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- G. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
Answer: A,D,G
NEW QUESTION # 37
Which two are true about collections and RECORD types? (Choose two.)
- A. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
- B. A variable of RECORD type can contain fields of another RECORD type or any collection type.
- C. All collections and RECORD types can be stored in table columns.
- D. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
- E. Collections and RECORD types are always dense.
- F. Only associative arrays and nested tables can have elements of RECORD type.
Answer: A,F
NEW QUESTION # 38
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- B. The RETURNING clause can be used for remote or parallel deletes.
- C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- D. The RETURNING INTO clause returns column values for rows affected by DML statements.
- E. The RETURNING INTO clause and bulk binds may not be used together.
Answer: B,C
NEW QUESTION # 39
For which three SYSTEM EVENTS can triggers be created? (Choose three.)
- A. SHUTDOWN
- B. BEFORE GRANT
- C. AFTER AUDIT
- D. DDL
- E. SERVERERROR
- F. BEFORE ANALYZE
- G. STARTUP
Answer: A,E,G
NEW QUESTION # 40
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 # 41
Which two are true about packages? (Choose two.)
- A. Package specifications can be compiled without their bodies.
- 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. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- 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 # 42
Which two are true about INDEX-BY tables? (Choose two.)
- A. INDEX-BY table types can be created in PL/SQL blocks only.
- B. INDEX-BY table types can be created with the CREATE TYPE statement.
- C. The index can be integer or string.
- D. The index can be integer only.
- E. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
Answer: A,C
NEW QUESTION # 43
Examine this table in the SH schema:
Now, examine this code:
Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
- A. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- B. In line 2, change IN OUT mode to IN mode.
- C. In line 1, add the default parameter DEFAULT 2000.
- D. In line 2, add the default parameter DEFAULT 2000.
- E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
- F. In line 1, change IN OUT mode to IN mode.
Answer: B,C
NEW QUESTION # 44
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 4
- B. line 3
- C. line 2
- D. line 6
- E. line 5
Answer: D
NEW QUESTION # 45
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:
USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?
- A. It executes successfully.
- B. It results in an error because Authid Current_User is missing from MYPROC.
- C. It results in an error because USERB doesn't have select privilege on USERA.EMP.
- D. It results in an error because Authid Definer is missing from MYPROC.
Answer: A
NEW QUESTION # 46
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. WHEN
- B. FETCH
- C. OPEN-FOR
- D. DECLARE
- E. CLOSE
- F. OPEN
- G. INTO
Answer: B,C,E
NEW QUESTION # 47
......
Verified 1Z0-149 exam dumps Q&As with Correct 67 Questions and Answers: https://examcertify.passleader.top/Oracle/1Z0-149-exam-braindumps.html