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-148

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

  • Full Access (75 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 tablespace is used to store the data collected by PL/Scope?
  1. A
    UNDOTBS1
  2. B
    SYSAUX
  3. C
    SYSTEM
  4. D
    TEMP
  5. E
    USERS

Correct Answer:
B
Reference:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm#BABDGJAF

Question #22
Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?
  1. A
    The IN parameters must not include BLOB, CLOB, collection or record data types.
  2. B
    The function must be created with invoker’s rights or in an anonymous block.
  3. C
    The function must be declared as a pipelined table function.
  4. D
    The function must have an OUT or an IN OUT parameter.

Correct Answer:
C
Reference:
https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/subprograms.htm#insertedID11

Question #23
Which two statements are true with respect to fine-grained access control?
  1. A
    It is implemented by end users.
  2. B
    It can be used to implement column masking.
  3. C
    It implements security rules through functions and associates these security rules with tables, views or synonyms.
  4. D
    Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.
  5. E
    The DBMS_FGA package is used to set up fine-grained access control.

Correct Answer:
CD
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/security.htm

Question #24

Which two statements are correct about the collections before v3. DELETE is executed?
  1. A
    The values of v3(31) (2) and v3 (33) (2) are identical.
  2. B
    The value of v3 (31) (3) is 6.
  3. C
    The value of v3 (31) (1) and v3 (33) (3) are identical,
  4. D
    The value of v3 (31) (1) is "hello".
  5. E
    The values of v3 (32) (2) and v1 (2) are identical.

Correct Answer:
AD

Question #25
Which two statements are true about the DBMS_ LOB package?
  1. A
    DBMS_LOB.COMPARE can compare parts of two LOBs.
  2. B
    DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
  3. C
    DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
  4. D
    If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.
  5. E
    Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.

Correct Answer:
DE
Reference:
https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_lob.htm#insertedID2

Previous Questions Next Questions

All Pages