Which three statements are true about windows？（）

A. A user cannot set privileges on the persistent lightweight jobs

B. Persistent lightweight jobs generate a large amount of metadata

C. It is possible to create fully self-contained persistent lightweight jobs

D. The use of a template is mandatory to create persistent lightweight jobs

E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

A. Building the SQL profile

B. Recommending optimization of materialized views

C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending restructuring SQL queries that are using bad plans

t; TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

A. A job chain can contain a nested chain of jobs.

B. The jobs in a job chain cannot have more than one dependency.

C. A job of the CHAIN type can be run using event-based or time-based schedules.

D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

A. There is demand for space from the new table从

B. The undo tablespace does not have sufficient free space

C. The new table name is the same as the table name in the recycle bin

D. The temporary tablespace that is assigned to you does not have sufficient free space

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

A. Testing the backup and recovery procedures

B. Testing the upgrade of an Oracle database to a new release

C. Testing the effect of an application changes on database performance

D. Continuously updating archive log files from the target database to support failover