ITPub博客

（33）Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables.You decide to restrict their access to data dictionary objects.Which method would you adopt to achieve this objective?A.Revoke the RESOURCE role ...

（32）Your database instance is running with full workload after database creation.You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estima...

（31）Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A. It is the time period after which the undo data becomes obsolete.B. It  is  the  time  period  after  which  the  committed  undo  data...

（30）In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?A. when the data file of the undo tablespace is autoextensibleB. when there are more than one undo tablespaces available in the databaseC. when the undo tablespace is of a fixed size and ret...

（29）Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds.You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;What effect would this command have on the data...

（28）View the Exhibit and examine the undo tablespace attributes.Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour.The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The da...

（27）Which two statements are true regarding transactions in an Oracle database? (Choose two.)A.Multiple transactions can use the same undo segment.B.A transaction is assigned an undo segment when it is started.C.More than one transaction cannot share the same extent in the undo tablespa...

（26）Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management.C.Undo segments automatically grow and shrink as needed, acting as circu...

（25）Which three operations require undo data? (Choose three.)A.committing a transactionB.flashing back a transactionC.recovering a failed transactionD.running a read-consistent queryE.changing a tablespace status from READ ONLY to READ WRITE答案：（B、C、D）...

（24）Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)A. An extent cannot spread across data files.B. A segment cannot spread across data files.C. A data file can belong to only one tablespace.D. A data file ca...

（23）Note the following structures in your database server:1: Extents2: OS Blocks3: Tablespace4: Segments5: Oracle Data BlockWhich option has the correct arrangement of these structures from the smallest to the largest?A.2, 5, 1, 4, 3B.1, 2, 3, 4, 5C.5, 2, 1, 3, 4...

（22）Identify the logical structure that will never have more than one data segment created for it.A.external tableB.partitioned tableC.partitioned indexD.nonclustered tableE.global temporary table答案：（D）解析：A（X），外部表不属于逻辑结构...

（21）Which three statements are true about logical structures of the Oracle database? (Choose three.)A. Each segment contains one or more extents.B. Multiple tablespaces can share a single data file.C. A data block is the smallest unit of input/output (I/O) in data files.D. It is pos...

（20）You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed?A.System monitor (SMON)B.Process monitor (PMON)C.Memory manager pro...

（19）Which two statements about the background process of the database writer are true? (Choose two.)A.It is possible to have multiple database writers in an Oracle instance.B.It writes dirty buffers, if any, to data files whenever a checkpoint occurs.C.It writes dirty buffers, if any, t...

（18）View the Exhibit and identify the component marked with a question mark.A.Checkpoint (CKPT)B.Process Monitor (PMON)C.Archiver Processes (ARCn)D.Recoverer Process (RECO)E.Memory Manager process (MMAN)答案：（A）

（17）Note the functionalities of various background processes:1: Perform recovery at instance startup.2: Free the resources used by a user process when it fails.3: Cleanup the database buffer cache when a process fails.4: Dynamically register database services with listeners.5: M...

（16） Note the following functionalities of various background processes:1: Record the checkpoint information in data file headers.2: Perform recovery at instance startup.3: Cleanup unused temporary segments.4: Free the resources used by a user process when it fails.5: Dynamicall...

（15）Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)A.Shared SQL Area will be allocated in the shared pool.B.Shared SQL Area will be allocated when a session starts.C.Shared SQL Area will be allocated in the large pool always.D.Private SQL Area...

（14）These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are queried by using SQL statements2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements3: Res...