最新的Oracle 1z1-074免費考試真題

問題1

You want to partition the SALES table on the CITY and SALE_DATE columns.
Which three partitioning methods can you use? (Choose three.)

A. range

B. interval

C. virtual column-based

D. hash

E. list

正確答案: A,D,E

問題2

Which two statements are true about a PDB lockdown profile? (Choose two.)

A. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

B. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.

C. It is enabled by default on creation.

D. It is created by a common user with the SYSDBA privilege in CDB$ROOT.

E. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

F. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.

正確答案: D,F

問題3

A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.
You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.
How can you do this?

A. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R

B. by creating a proxy PDB in CDB1 root, referencing LOC_R

C. by using public database links created in CDB1 and CDB2

D. by creating a proxy PDB in CDB2 root, referencing LOC_R

E. by using private database links created in CDB1 and CDB2

正確答案: D

問題4

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users' sessions?

A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

B. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

C. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

D. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

E. You cannot limit PGA for a set of database user sessions.

正確答案: B

問題5

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.
You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

B. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

D. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

E. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

正確答案: D

問題6

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)

A. SQL Performance Analyzer

B. using literals in SQL statements

C. adaptive execution plans

D. adaptive cursor sharing

E. SQL Access Advisor

正確答案: C,E

問題7

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group

B. UNDO quota for a consumer group

C. maximum number of DML operations performed by a consumer group

D. sessions that are blocking other sessions

E. sessions that are not blocking other sessions

正確答案: A,B,D

問題8

You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.
Which four might be reasons for these? (Choose four.)

A. Blocks are ageing out of the buffer cache frequently.

B. Too many sort operations are being performed.

C. The same small number of blocks are repeatedly accessed by different sessions simultaneously.

D. Cursors are closed explicitly after each execution.

E. The buffer cache is undersized.

F. A large number of connected user sessions are idle.

G. DBWR is not writing the dirty buffers fast enough.

正確答案: A,B,C,G

最新的Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074免費考試真題

聯系我們

站內鏈接

最新更新