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

Oracle 1z0-338 Exam Practice Questions (P. 1)

  • Full Access (81 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 #1
A cloud user is assigned the Service Administrator role.
Which cloud actions can this user perform?
  1. A
    Perform all tasks in the My Services application, including user and role management tasks.
  2. B
    View, create, update, and delete Oracle Compute Cloud Service resources.
  3. C
    View only the Oracle Compute Cloud resources.
  4. D
    Work with one or more Oracle Cloud services only and use the My Services application to manage his or her own password and security challenge questions.
  5. E
    Perform cloud backups of a specific instance.

Correct Answer:
B
Reference: https://docs.oracle.com/cloud/latest/computecs_common/OCSUG/GUID-F89D66BD-85F5-4325-8A1F-F8EEE53A7CF1.htm#OCSUG113

Question #2
Which two options would you use to allow direct path loads to run in parallel on your Exadata platform? (Choose two.)
  1. A
    creating the required environment by using Smart Scan parallelization
  2. B
    setting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
  3. C
    setting the PARALLEL clause on both the external table and the table where you are loading the data
  4. D
    adding the PARALLEL hint to the CTAS or IAS statement
  5. E
    setting the PARALLEL_FORCE_LOCAL parameter to TRUE

Correct Answer:
CD

Question #3
You notice that a database node has hung, so you open a Service Request via My Oracle Support.
What diagnostic output will you send to My Oracle Support by default?
  1. A
    pkginfo
  2. B
    oswatcher
  3. C
    AWR
  4. D
    v$session output
  5. E
    list of database users

Correct Answer:
C

Question #4
Which statement is true about Exadata Storage Servers?
  1. A
    Exadata Storage Servers automatically delete old diagnostic and metric files.
  2. B
    Exadata requires a running database instance on all storage servers and database servers.
  3. C
    Redundancy for the user data that is stored in a database that is running on Exadata is achieved with RAID5.
  4. D
    Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
  5. E
    Exadata uses network affinity to determine which storage server data is written.

Correct Answer:
A

Question #5
Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)
  1. A
    SQL Explain Plan
  2. B
    resource plan
  3. C
    resource consumer group
  4. D
    resource plan directive
  5. E
    IORMPLAN object

Correct Answer:
BCD
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm001.htm#ADMIN11844

Next Questions

All Pages