oracle 1Z0-338 Exam Questions

Questions for the 1Z0-338 were updated on : Jun 07 ,2024

Page 1 out of 6. Viewing questions 1-15 out of 81

Question 1

A cloud user is assigned the Service Administrator role.
Which cloud actions can this user perform?

  • A. Metric values are computed and stored in memory, and then permanently stored on disk.
  • A. Perform all tasks in the My Services application, including user and role management tasks.
  • B. DBMCLI can be used to report on Exadata storage server metrics.
  • B. View, create, update, and delete Oracle Compute Cloud Service resources.
  • C. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.
  • C. View only the Oracle Compute Cloud resources.
  • D. Fields in AlertHistory cannot be modified.
  • 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.
  • E. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.
  • E. Perform cloud backups of a specific instance.
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 2

Which two options would you use to allow direct path loads to run in parallel on your Exadata
platform? (Choose two.)

  • A. creates a backup of the patch in case of an error in the patching routine
  • A. creating the required environment by using Smart Scan parallelization
  • B. performs a backup of each Oracle home directory before a patch is applied
  • B. setting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
  • C. forces the software to create a backup of the exadbpatch.cfg file
  • C. setting the PARALLEL clause on both the external table and the table where you are loading the data
  • D. adds a dialog box that prompts for a backup before the patch can be applied
  • D. adding the PARALLEL hint to the CTAS or IAS statement
  • E. creates a backup of the Oracle database data files
  • E. setting the PARALLEL_FORCE_LOCAL parameter to TRUE
Answer:

C,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

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?

  • A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
  • A. pkginfo
  • B. Hybrid Columnar Compression can be defined for a single column.
  • B. oswatcher
  • C. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
  • C. AWR
  • D. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.
  • D. v$sessionoutput
  • E. list of database users
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 4

Which statement is true about Exadata Storage Servers?

  • A. review of the database server iostat output
  • A. Exadata Storage Servers automatically delete old diagnostic and metric files.
  • B. alert notifications through email when SMTP notification is configured
  • B. Exadata requires a running database instance on all storage servers and database servers.
  • C. review of the ILOM log
  • C. Redundancy for the user data that is stored in a database that is running on Exadata is achieved with RAID5.
  • D. review of the output of LIST ALERTHISTORY
  • D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
  • E. review of the output of SELECT STATUS FROM V$DATAFILE
  • E. Exadata uses network affinity to determine which storage server data is written.
  • F. alert notifications in the Enterprise Manager Exadata Plug-In
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 5

Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)

  • A. CellCLI can be used to back up the Exadata storage cells or make a bootable disk to restore the cell.
  • A. SQL Explain Plan
  • B. With a simple CellCLI command, you can synchronize changes to all the storage cells in the Exadata realm.
  • B. resource plan
  • C. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
  • C. resource consumer group
  • D. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
  • D. resource plan directive
  • E. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.
  • E. IORMPLAN object
Answer:

B,C,D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 6

In a customers ACFS filesystem, they would like you to set up replication between the existing local
primary and the remote standby Exadata system.
Which tool would you use to administer the replication process?

  • A. system
  • A. Replication is controlled by using Enterprise Manager Cloud Control.
  • B. Account Administrator
  • B. Replication is controlled by using sqlplus while you are logged in as SYSASM.
  • C. Identity Domain Administrator
  • C. Replication is controlled by using the acfsutil command-line tool.
  • D. sys
  • D. Replication of ACFS filesystems for non-database files on Exadata is not supported.
  • E. Service Instance Administrator
  • E. Replication is controlled by using the exacli command-line tool.
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 7

Which two statements are true about troubleshooting failed patching activities? (Choose two.)

  • A. grid disks with default AU allocation sizes of 1 MB
  • A. Dependency issues found duringyumupdates should be ignored by using theforceoption.
  • B. usage of flash technology to cache recently used data
  • B. Failed storage cell patches are rolled back to the previous release automatically.
  • C. prioritization of disk I/Os based on the database
  • C. Failed OS patches on database servers can be rolled back.
  • D. prioritization of OLTP I/Os over scan I/Os
  • D. Dependency issues that are found duringyumupdates require rolling back to a previous release before retrying.
  • E. database storage flash cache space allocation guarantees and limits
  • E. Bundle patches applied by usingopatch autocannot roll back only the database or the grid infrastructure home.
  • F. Database server OS updates can be rolled back by usingopatch auto –rollback.
Answer:

A,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 8

The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.
What protocol do these tiers use to communicate with each other?

  • A. LIST GRIDDISK ATTRIBUTES name, status;
  • A. iDB – Intelligent Database Protocol
  • B. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;
  • B. InfiniBand protocol
  • C. LIST CELLDISK ATTRIBUTES name, raidLevel;
  • C. Ethernet protocol
  • D. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;
  • D. Secure Shell protocol
  • E. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;
  • E. Fibre Channel protocol
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 9

Your customer needs to ensure that their data is available on the Exadata machine during patches.
The customer wants to be able to patch one server at a time but still be protected against single-
node server failure.
What ASM redundancy level should they use?

  • A. CTAS over a database link
  • A. High
  • B. Expdp and Impdp
  • B. Normal
  • C. Cross Platform Incremental Backup and Restore
  • C. External
  • D. logical migration by using RMAN and GoldenGate
  • D. Extreme
  • E. physical migration by using Data Guard
  • E. Standard
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
Reference:
http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf(page
7)

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 10

In which three ways can customers access the ILOM interface to manage the Exadata database and
storage server hardware components? (Choose three.)

  • A. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
  • A. ILOM CLI interface through the management network
  • B. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
  • B. ILOM Web interface through the management network
  • C. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.
  • C. remote KVM session to the ILOM
  • D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.
  • D. from the database server operating system tool "ilomcli"
  • E. All indexes should be dropped when migrating to Exadata.
  • E. from the storage server operating system tool "ilomcli"
Answer:

B,C,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 11

Your customer is implementing a storage consolidation strategy on their existing Exadata.
Which step represents the Oracle recommended action that the customer should take in their
approach?

  • A. Create a CELLBOOT USB Flash Drive by using an external USB drive.
  • A. Do not use IORM because it will interfere with the shared database functionality on Exadata.
  • B. Mount the LVM backup image across the network and recover the system.
  • B. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  • C. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  • C. Use IORM to distribute disk bandwidth among the databases.
  • D. Reboot the new server by using a bootable recovery image from the external USB drive.
  • D. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  • E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
  • E. Set up a resource consumer group within each database instance and manage it individually.
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 12

How does Advanced Compression differ from Hybrid Columnar Compression?

  • A. Do not use IORM because it will interfere with the shared database functionality on Exadata.
  • A. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
  • B. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  • B. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
  • C. Use IORM to distribute disk bandwidth among the databases.
  • C. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
  • D. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  • D. Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where data is fairly static.
  • E. Set up a resource consumer group within each database instance and manage it individually.
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 13

The Exadata compute node, exadbs04, has been having issues for some time. The server had to be
repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute
node must be re-imaged with an Oracle Support installation image.
Which three tasks must be performed in order to re-image the compute node? (Choose three.)

  • A. It is enabled through OEDA by selecting the Enable FlashCache check box in the hardware configuration section.
  • A. Create a CELLBOOT USB Flash Drive by using an external USB drive.
  • B. It can be enabled with the ‘cellcli –I alter flashCache=on’ command.
  • B. Mount the LVM backup image across the network and recover the system.
  • C. It can be enabled manually with the CREATE FLASHCACHE command from CellCLI.
  • C. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  • D. It can be enabled by default during installation.
  • D. Reboot the new server by using a bootable recovery image from the external USB drive.
  • E. It can be enabled by using the cellCLI DROP FLASHCACHE command.
  • E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
Answer:

C,D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 14

Which statement is true about instance caging setup?

  • A. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workloads.
  • A. The initialization parameterresource_manager_planshould be set.
  • B. Configure and enable Parallel Query.
  • B. For a system with 16 threads, the sum ofcpu_countfor all databases should not be higher than 32 to prevent oversubscribing.
  • C. Deploy Instance Caging to control batch jobs.
  • C. Database instances need to be restarted to make changes tocpu_counteffective.
  • D. Build a Database Resource Management Plan, giving priority to query workloads.
  • D. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  • E. Configure IORM to disable Flash Cache usage for batch workloads.
  • E. Instance caging is the right approach to make sure that database instances are not stealin memory from one another.
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 15

Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete
ACFS filesystems? (Choose three.)

  • A. Inactivate all physical disks on the cell.
  • A. SQL*Plus and ASMCMD
  • B. Shutdown the cellsrv services on the cell.
  • B. ASMCA
  • C. Disable the storage indexes on the cell.
  • C. Enterprise Manager Express
  • D. Inactivate the grid disks on the cell.
  • D. Enterprise Manager Cloud Control
  • E. Create a new flash cache on the cell.
  • E. RMAN
  • F. Drop the existing flash cache on the cell.
  • F. OUI
Answer:

A,B,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Explanation:
Reference:
https://dbasolutions.wikispaces.com/ACFS+on+Linux

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000
To page 2