1Z0-027 | Most recent Oracle 1Z0-027 vce
Q21. You are examining the existing IORM configuration on the cells of Database Machine, to see if they require my modifications based on recent changes to various workloads.
All seven cells in your X3-2 half-rack shown the following:
Which two are true about I/O to the cells using this plan?
A. I/O requests in the batch category may use flashcache if the I/O is from the sales finance database, and these I/O requests are guaranteed to get 80% of the I/O if the interactive category I/Os use no more than 20%.
B. I/O requests made by sessions in the marketing database may use flashing and flashcache if no other categories or database or database are using flashing and flashcache at the same time.
C. I/O requested in the interactive category may use flashdns if the I/O is from the sales or finance databases, and these I/O requests are guaranteed to get 90% of the I/O if the enough I/Os are issued in this category.
D. I/O requests from the sales database may use flashing regardless of the I/O category.
E. No I/Os in any category or from any database may use flashing or flashcache because the objective is off.
Answer: DE
Q22. To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis.
You must contain storage availability while performing task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned.
Which two factors would prevent you from moving the disks from one Exadata storage server to another one?
A. The existence of an external redundancy ASM diskgroup
B. The existence of a normal redundancy ASM diskgroup
C. The existence of an ASM diskgroup with the repair_time attribute set to 0.
D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
E. Offline or inactive celldisks in another Exadata server
Answer: AD
Q23. You are planning the physical installation of two full rack Database Machines and two full-rack expansion racks. The four racks will be combined into one multi rack system.
Which are the two guidelines for installing this configuration in your data Center?
A. All Database Machines must be placed side by side with no space between them.
B. All Expansion Racks must be placed side by side with no space between them.
C. All racks must be placed in such away that the exhaust air of one rack does not enter theairinlet of another
D. All racks must be placed side by side with no space between them.
E. All racks must be isolated from each other with at least one meter between them.
F. Racks may be placed as required in the machine room.
G. Expansion Racks must be placed side by side at least one meter apart.
Answer: AC
Q24. A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability.
The following is true about the tables used by the application:
1. The data for the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None of the indexes are compressed or reverse key indexes.
4. The tables use the default organization type data.
5. The only data types for the table are varchar (2), number, or date.
6. The largest number of columns for any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set of “cell smart table scan” or a set of “cell smart index scan” requested?
A. Full scans on sorted hash clustered tables executed in parallel
B. Full table scans on index organized tables executed in parallel.
C. Full table scans on heap tables executed in parallel
D. Full scans on index clustered tables executed in parallel
E. full scans on hash clustered tables executed in serially
F. fast full scans on B*Tree indexes executed in parallel
G. full index scans on B*Tree indexes executed in parallel
Answer: BG
Q25. Which two activities are supported on the storage servers in the Database Machine?
A. Installing an alternative package manager
B. configuring secure shell user equivalency for the callmonitor user
C. changing root password
D. upgrading the Storage Server software package using RPN
E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
Answer: AD
Q26. You are monitoring and evaluating a create index statement on your Database Machine and have run the following query after executing statement, providing the output. Shown:
Select two reasons why the statement would have produced so many “cell single block physical read” waits compared to “cell smart table scan” waits.
A. There are huge numbers of migrated rows in the table on which the index is being built.
B. There is an uncommitted transaction that has modified one block of the table on which the index is being built, in each cell.
C. Thereis a transaction that has modified one block of the table on which the index is being built in each cell, which committed after the create index began.
D. There are huge numbers of chained rows in the table on which the index is being built.
E. There is a ROWID column in the table on which the index is being built.
Answer: AD
Q27. Which three are true regarding the use of Storage Indexes?
A. Different storage regions may have different columns indexed for the same table.
B. A Storage index is automatically maintained by CELLSRV based on the filter columns of the offload SQL.
C. The use of Storage indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
D. Storage Indexes occupy space in the Smart Flash Cache.
E. The use of Storage Indexes for particular categories of I/O can be disabled by using an I/O Resource Manager Category Plan.
F. A maximum of eight table columns for any table are Indexed per storage region.
Answer: BCF
Q28. In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?
A. On a dbfs file system stored in a staging database on the Database Machine
B. On an Exadata-based ACFS file system on the Database Machine
C. On an nfs file system mounted on a database server where the external table will be accessed.
D. On local storage on one or more cells that are accessible to the database server where the load will be performed.
Answer: CD
Q29. You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to determine it Smart Scan operations will be fast enough to satisfy your performance requirements.
Given the results of your testing, you consider dropping the index.
Which two statements are true?
A. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY to enforce the constraint
B. You may drop the index and use a constraint with the DISABLE NOVALIDATE RELYflags
C. You must retain the index and make it visible again for the constraint to be enforced.
D. You may drop the index and make the constraint invisible, because this is enough for the constraint to be enforced.
E. You may retain the index, and leave it as invisible, because this is enough for the constraint to be recognized.
Answer: AC
Q30. Consider the following sequence of CELLCLI commands and SQL statements:
All CELLCLI commands and SQL statements are executed successfully without warnings.
Which statement is true about the I/O performance of the DATA01 ASM diskgroups?
A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
B. The DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
C. The DATA01 diskgroup has better performance because the DATA01 griddisks are created on interleaved cell disks.
D. The performance of both diskgroups is balanced because they are created on interleaved
griddisks.
Answer: A