单项选择题
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.
The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.
How would you create these jobs？（）
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
相关考题
-
多项选择题
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（） (Choose all that apply.)
A. Backup retention policy
B. Default backup device type
C. Default destinations for backups
D. Multiple backup device types for single backup
E. Default section size for backups -
多项选择题
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)
A. An entry is created in the alert log file and the database instance continues to function normally
B. The log switch hangs occur for transactions until free space is available in the flash recovery area
C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented -
多项选择题
Evaluate the following command and its output： SQL>SELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
