A. 원래 동시에 실행되었던 SQL 문은 SPA에 의해 동시에 실행됩니다.

B. SQL Access Advisor와 통합됩니다.

C. 분석 작업의 모든 SQL 문에 대한 세분화된 분석을 그룹으로 제공합니다.

D. 분석 작업에서 각 SQL 문에 대한 실행 전후 통계를 제공합니다.

E. 시스템 변경이 SQL 워크로드 응답 시간에 미치는 영향을 예측합니다.

A. Increase the size of tape I/O buffers.

B. Enable asynchronous disk I/O.

C. Increase the size of the database buffer cache.

D. Disable FORCE LOGGING for the database.

E. Increase the level of RMAN multiplexing.

A. Flashback logs are monitored for being older than the retention period defined in db_flashback_retention_target and can be deleted by an administrator written event trigger.

B. Flashback logs are automatically purged when db_flashback_retention_target is set lower than the time they have already been retained.

C. Flashback logs are automatically purged whenever the value
Of DB_FLASHBACK_RETENTION_TARGET is changed.

D. Flashback logs are monitored and proactively deleted when beyond the retention period defined in db_flashback_retention_target before there is space pressure.

E. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_flashback_retention_TARGET only after there is space pressure

A. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).

B. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space might be reclaimed proactively before space pressure occurs.

D. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

E. Space is always reclaimed proactively before space pressure occurs.

A. Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.

B. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).

C. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.

D. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.

E. System statistics can be gathered only while connected to cdb$root.