The safer , easier way to help you pass any IT exams.
3 / 124
A. The job is terminated and the gathered statistics are not saved.
B. The job is terminated but the gathered statistics are not published.
C. The job continues to run until all statistics are gathered.
D. The job is terminated and statistics for the remaining objects are collected the next time the
maintenance window opens.
Answer: D
Explanation:
The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the
maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE,
causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The
remaining objects are then processed in the next maintenance window.
References:https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431
5.You plan to create a database by using the Database Configuration Assistant (DBCA), with the following
specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
A. a General Purpose database template with default memory allocation
B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
C. a General Purpose database template, with the shared server mode option and Automatic Memory
Management (AMM) enabled
D. a default database configuration
Answer: C
6.Which two statements are true about the logical storage structure of an Oracle database?
A. An extent contains data blocks that are always physically contiguous on disk.
B. An extent can span multiple segments.
C. Each data block always corresponds to one operating system block.
D. It is possible to have tablespaces of different block sizes.
E. A data block is the smallest unitof I/O in data files.
Answer: B,D
7.Which two statements correctly describe the relationship between data files and logical database
structures?
A. A segment cannot span data files.
B. A data file can belong to only onetablespace.
C. An extent cannot span data files.
D. The size of an Oracle data block in a data file should be the same as the size of an OS block.
Answer: B,C
8.Which statement is true about the Log Writer process?
A. It writes when it receives a signal from the checkpoint process (CKPT).
