Latest Oracle 1Z1-027 Actual Free Exam Questions & Community Discussion, Page 5

Question #33

Which two are true about the use ofi DBFS in a Database Machine environment?

A. DBFS must be used to bulk load data into a production database on the Database Machine.

B. DBFS must be used to have a POSIX compliant shared storage solution that is accessible firom the database servers
on a Database Machine.

C. DBFS must use the DBFS_DG diskgroup fior any DBFS store.

D. DBFS must be used to bulk load data into a database on the Database Machine ifi the staging area requires Exadata
based shared storage.

E. DBFS must be used to have a POSIX-compliant Exadata-based shared storage solution.

Discussion 0

Correct Answer: A,C Vote an answer

Question #34

Which two are true concerning the allocation ofi I/O resources by the IORM within the CELLSRV process?

A. Ifi two consumer groups P and Q In the PROD database get 20% and 10% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 10% and 5% respectively, and the Interdatabase plan
has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the
same categories.

B. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes ofi the IORM
plan.

C. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.

D. Ifi two consumer groups C and D In the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they still got 10% and 15% respectively and were remapped to a
different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.

E. Ifi two consumer groups A and B in the PROD database get 10% and 15% respectively ofi resource allocation, then
the percentage ofi I/O resource would be the same ifi they got 20% and 30% respectively, provided that the category
plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #35

You are using Hybrid Columnar Compression fior a table stored in a tablespace that is contained in an Exadata-based
ASM diskgroup. Identifiy three statements that correctly explain where the compression and decompression can be
done.

A. Decompression can be done on the Exadata storage servers.

B. Compression can be done on the Exadata storage servers.

C. Compression can be done on the database servers.

D. Decompression can be done on the database servers.

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #36

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 fiast enough to satisfiy your perfiormance requirements.
Given the results ofi 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 enfiorce the constraint

B. You may retain the index, and leave it as invisible, because this is enough fior the constraint to be recognized.

C. You must retain the index and make it visible again fior the constraint to be enfiorced.

D. You may drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags

E. You may drop the index and make the constraint invisible, because this is enough fior the constraint to be enfiorced.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #37

A table in one ofi your database schemas contains only varchar, number, and date data types fior the columns.
Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, ifi
no other situations arise that prevent Smart Scan firom occurring?

A. Column filtering

B. Predicate filtering

C. Hash join filtering

D. Nested loop Join filtering

E. Sort merge join filtering

F. Virtual column filtering

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #38

Which three are true regarding the use ofi Storage Indexes?

A. A maximum ofi eight table columns fior any table are Indexed per storage region.

B. Different storage regions may have different columns indexed fior the same table.

C. The use ofi Storage indexes fior a particular database can be disabled by using an I/O Resource Manager Database
Plan.

D. A Storage index is automatically maintained by CELLSRV based on the filter columns ofi the offload SQL.

E. Storage Indexes occupy space in the Smart Flash Cache.

F. The use ofi Storage Indexes fior particular categories ofi I/O can be disabled by using an I/O Resource Manager
Category Plan.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #39

You are monitoring and evaluating a create index statement on your Database Machine and have run the fiollowing
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 is a transaction that has modified one block ofi the table on which the index is being built in each cell, which
committed after the create index began.

B. There are huge numbers ofi chained rows in the table on which the index is being built.

C. There is an uncommitted transaction that has modified one block ofi the table on which the index is being built, in
each cell.

D. There is a ROWID column in the table on which the index is being built.

E. There are huge numbers ofi migrated rows in the table on which the index is being built.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #40

You have used setupem.sh to deploy a plug in fior Grid Control.
In which two ways do all the targets supported by the plug-in get configured?

A. Setupem.sh is used again to configure the targets.

B. The targets must be configured by a database administrator manually.

C. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.

D. The targets must be configured by an O/S administrator manually.

E. There may be more than one target fior each plug-in.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z1-027 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-027 Demo