Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-146

Oracle 1z0-146 Exam Practice Questions (P. 5)

  • Full Access (117 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which two statements are true about associative arrays and varrays? (Choose two.)
  1. A
    Only varrays must use sequential numbers as subscripts
  2. B
    Only varrays can be used as column types in database tables
  3. C
    Both assocaitive arrays and varrays must use sequential numbers as subscripts
  4. D
    Both assocative arrays and varrays can be used as column types in database tables

Correct Answer:
AB

Question #22
See the Exhibit:


Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)
  1. A
    Explicitly validate the identifier length limit
  2. B
    Add AUTHID DEFINER to the definition of the procedure
  3. C
    Use PRAGMA RESTRICT_REFERENCES in the procedure
  4. D
    Filter out control characters in user-supplied identifier names
  5. E
    Use the object ID of the table from the data dictionary to build the trigger name

Correct Answer:
ADE

Question #23
You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached reuslt bypassed? (Choose all that apply)
  1. A
    When the size for the memory allocated for the result cache is increased
  2. B
    When the function is executed in a session frequently with the same parameter value
  3. C
    When the database administrator has disabled the use of the result cache during application patching
  4. D
    Whe a data manipulation language statement in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function

Correct Answer:
CD

Question #24
See the Exhibit:

Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply)
  1. A
    Use cursors to fetch values
  2. B
    Remove redundant SQL statements in the procedure
  3. C
    Avoid the NOT NULL constraint when declearing the variable
  4. D
    Define and compule procedures independently and not as part of a package

Correct Answer:
BC

Question #25
See the Exhibit:
Exhibit1:


Exhibit2:


When executing the above PL/SQL statement to create SALES_ORDERS_CTZ context to use the OE.SALES_ORDERS_PKG package.
ERROR at line 2:
ORA-28112: Failed to execute policy function.
What could be the reason for the error?
  1. A
    The user has insufficient privileges on the DBMS_SESSION package
  2. B
    The subprograms inside the package have not been created with the invokers right
  3. C
    The THE_PREDICATE function has an insufficient number of parameters in the package
  4. D
    The policy is created by using SALES_ORDERS_PKG. THE_PREDICATE without a parameter

Correct Answer:
C

Previous Questions Next Questions

All Pages