Oracle Database Cloud Service 2017 Implementation Specialist Update Assessment
The Oracle Exadata Database Machine and Cloud Service Implementation Essentials (1Z0-338) Sample Question Set is designed to help you prepare for the Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist (OCS) certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-338 Certification Practice Exam.
This Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials certification sample practice test and sample question set are designed for evaluation purposes only. If you want to test your Oracle 1Z0-338 knowledge to identify your areas of improvement and get familiar with the actual exam format, we suggest you prepare with the Premium Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist (OCS) Certification Practice Exam. Our team of Oracle Exadata experts has designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Our premium Oracle 1Z0-338 certification practice exam will boost your confidence as well as your actual Oracle Exadata Database Machine and Cloud Service Implementation Essentials exam result.
01. How do ASM failure group provide redundancy?
a) For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks are lost during an outage.
b) They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the database server.
c) They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.
d) They ensure that the cell disks are sliced into grid disks by using cellsrv processes.
02. Your customer has a very large table that is accessed very infrequently, they would like to load this table onto their Exadata Database Machine, but are critically low on space and would like to compress the table as much as possible.
They are looking for recommendations on the strategy to use. Select the best method.
a) Load this table using Advanced Compression
b) Load this table using a combination of Hybrid Columnar Compression, Advanced Compression and Basic Compression
c) Load this table with Hybrid Columnar Compression set to ARCHIVE HIGH
d) Load this table with Hybrid Columnar Compression set to QUERY LOW
03. Which command would you use to stop your customers entire RAC cluster prior to rebooting the server?
a) CRSCTL
b) SRVCTL
c) CELLCLI
d) DCLI
e) CellCLI Shutdown services ms
04. Which three operations can be performed on the Exadata Storage Servers?
a) Predicate Filtering
b) Aggregation
c) Storage Index Processing
d) Table Scans
e) Data Conversion
05. A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database.
Because of the importance of the control file, Oracle recommends that the control file be?
a) size constrained, to prevent size overruns
b) managed by EM12c, to ensure proper maintenance
c) stored on an HA USB Drive, to ensure that it does not get overwritten
d) multiplexed, or have multiple identical copies
06. Your customer is keen to ensure that they select the best tape based backup strategy on their Exadata Database Machine.
a) Daily full RMAN backups that take advantage of Exadata's speed and performance
b) Weekly full RMAN tape backups and daily incremental RMAN tape backups
c) Weekly full RMAN disk based backups and daily incremental RMAN backups
d) Tape based backups are not recommended on the Exadata Database Machine
07. Which Oracle Cloud service can be deployed as a quarter, half, or full rack?
a) Big Data Analytics Cloud Service
b) Oracle Infrastructure as a Service Cloud
c) Oracle Database Express
d) Oracle Exadata Cloud Service
08. Which CellCLI command will shut down the ms, rs, and cellsrv services on Exadata?
a) CellCLI > alter cell shutdown ms, rs, cellsrv
b) CellCLI > alter cell stop ms, rs, cellsrv
c) CellCLI > alter cell shutdown services all
d) CellCLI > alter cell all shutdown
e) CellCLI> alter cell shutdown ms; alter cell shutdown rs, alter cell shutdown cellsrv
09. Your customer would like to apply patches to the Exadata Database Machine to match their current patching schedule. Currently, servers are patched twice per year, databases are patched quarterly, operating systems are patched monthly.
Will your customer be able to patch the various components of the Exadata Database Machine on the same schedule?
Select the best answer and reason.
a) Yes, patches are delivered from Metalink on a monthly schedule
b) No, patches are delivered quarterly and the OS, firmware, storage server and database server patches are delivered together
c) Yes, patches are delivered via Platinum Support. OS and firmware patches are available monthly, CPU patches are available for download once per quarter.
d) No, patches for the os, firmware, storage server and database server are available once per year.
10. You have recommended that your customer use IORM in order to distribute disk bandwidth among multiple databases on an Exadata system. Which strategy could this action potentially help out with?
a) Consolidation
b) OLTP
c) Big Data Analytics performance
d) SQL statement tuning
e) Grid infrastructure optimization
Question: 01
Answer: c
Question: 02
Answer: c
Question: 03
Answer: a
Question: 04
Answer: a, c, d
Question: 05
Answer: d
Question: 06
Answer: b
Question: 07
Answer: d
Question: 08
Answer: c
Question: 09
Answer: b
Question: 10
Answer: a
Oracle Database Cloud Service 2017 Implementation Specialist Update Assessment
Source: https://www.dbexam.com/oracle/oracle-1z0-338-certification-sample-questions-and-answers