1Z0-032章节练习(2018.08.01)

A.The size of the redo buffer in SGA. 
B.The instance that will perform recovery in Real Application Cluster database. 
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

A.A direct-load insert can be invoked by suing the APPEND hint.
B.Inserting using the NOLOGGING option is the default for direct-load inserts.
C.All data loaded using direct-load insert is loaded below the high-water mark.
D.An object that is modifies using parallel direct-load can be queried within the same Transaction.

A.It readily responds to dynamic changes for concurrent access. 
B.It improves performance and space utilization in a multiple-instance environment. 
C.It requires fewer space related options then freelist managed structures. 
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

A.IDS* 2
B.TS + IYM
C.TS –TSI
D.IDS – TS
E.IDS + IYM

A.External tables can be updated. 
B.External tables are read-only tables. 
C.Indexes can be created on external tables. 
D.Indexes cannot be created on external tables.

A.Define user profiles and set the CPU_PER_CALL limit. 
B.Define a SWITCH_TIME for a plan in the Resource Manager. 
C.Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. 
D.Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.

A.The filename format. 
B.Information stored inside a data dictionary table. 
C.Information stored in the ALERT.LOG file for the corresponding instance. 
D.Information stored inside the corresponding initialization parameter file for the instance.

A.Enables easier loading of multinational data. 
B.Uses a fixed-width Multibyte encoding sequence.
C.Asian characters are represented in three characters. 
D.Used a variable-width Multibyte encoding sequence. 
E.European characters are represented on one or two bytes. 

A.LIST
B.CHANGE
C.CATALOG
D.CROSSCHECK

A.It provides each session with its own view of the database at a different point in the past. 
B.It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables. 
C.It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. 
D.It allows you to add new sites to multimaster replication environment without quiescing the master definition site.