111、
111.Which two statements are true about checkpointing? (Choose two.) A. The checkpoint frequency decreases with the smaller redo log file size. B. It ensures that all committed data is written to the data files during normal shutdown. C. The frequent full checkpoint in a database can cause the overall degradation of the database performance. D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
Answer: BC DBWn：数据库块写入器（Database Block Writer）负责将脏块写入磁盘的后台进程。 CKPT：检查点进程（Checkpoint Process）只是更新数据文件的文件首部，以辅助建立检查点的进程（DBWn）。 LGWR：日志写入器（Log Writer）负责将SGA中重做日志缓冲区的内容刷新输出到磁盘。
112、
112.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.) A. You cannot export data from a remote database. B. You can rename tables during an import operation. C. You can overwrite existing dump files during an export operation. D. You can compress the data during export but not the metadata because it is not supported.
Answer: BC
113、View the Exhibit.
You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this? A. You have chosen the File System option as the storage option. B. You have chosen the Automatic Storage Management (ASM) as the storage option. C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI). D. You are using General Purpose template and not the Custom Database template to create the database.
Answer: D
114、
114.Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future. What action would you take to achieve this task? A. Insert finding directives for ADDM tasks in the future. B. Create a baseline on a pair of snapshots spanning the peak-load period. C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period. D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
Answer: B
115、
115.Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace B. Undo tablespace has only one datafile C. Undotablespace has a datafile which is reused in cyclic manner
Answer: A
