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. 2)

  • 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 #6
See the Exhibit:


Examine the PL/SQL block; While executing the PL/SQL statements generates the errors, what is the reason?
  1. A
    The DELETE(n) method cannot be used with varrys
  2. B
    The DELETE(n) method cannot be used with nested tables
  3. C
    The NEXT method cannot be used with an associate array with VARCHAR2 key values
  4. D
    The NEXT method cannot be used with a nested table from which an element has been deleted

Correct Answer:
A

Question #7
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
  1. A
    The corresponding shared library is also removed from the system
  2. B
    PL/SQL subprograms can be used to invoke the external C procedure
  3. C
    The existing extproc process is terminated and a new extproc is started
  4. D
    The PL/SQL subprogram that depends on the external C program becomes invalid

Correct Answer:
D

Question #8
See the exhibit:


Which of the above INSERT statements are valid?
  1. A
    Only the first statement is valid
  2. B
    All the statement are valid
  3. C
    Only the first and fourth statements are valid
  4. D
    Only the first and second statements are valid
  5. E
    Only the first, second and third statements are valid

Correct Answer:
E

Question #9
The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter.
Examine the following initialization parameter settings for your database:

MEMORY_TARGET = 500M -

RESULT_CACHE_MODE=MANUAL -
You execute a query by using the result_cache hint. Which statement is true in this scenario?
  1. A
    The query results are not stored because no memory is allocated for the result cache
  2. B
    The query results are stored and 0.5% of the memory target is allocated to the result cache
  3. C
    The query results are stored and 0.25% of the memory target is allocated to the result cache
  4. D
    The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE

Correct Answer:
C

Question #10
Which three actions can be performed by using the DMBS_ASSERT package to prevent SQL injection? (Choose three.)
  1. A
    Detect a wrong user
  2. B
    Check input string length
  3. C
    Verify qualified SQL names
  4. D
    Validate TNS connect strings
  5. E
    Verify an exisitng schema name
  6. F
    Enclose string literals within double quotation marks

Correct Answer:
CEF

Previous Questions Next Questions

All Pages