多项选择题

The user SYS creates a job by using the following comma……

The user SYS creates a job by using the following command:

Which two statements are true about the job that was created by the preceding command?（）

A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D.

<上一题目录下一题>

热门试题

多项选择题Which three tasks can be performed using a duplicate database?（）

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

单项选择题Examine the CREATE DISKGROUP command used to create a disk group: In which situation would you use this method of disk group creation?（）

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

单项选择题You executed the following commands in a database session: What could have caused the recycle bin to clean up?（）

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

单项选择题View the exhibit and examine the TRANS tables storage information. After a massive delete 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

多项选择题Which two statements are true about a job chain?（）

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