A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
您可能感兴趣的试卷
你可能感兴趣的试题
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member.
When you attempt to start the database, you receive the following errors:()
A. ALTER DATABASE DROP LOGFILE GROUP 1
B. ALTER DATABASE CLEAR LOGFILE GROUP 1
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D. ALTER DATABASE DROP LOGFILE MEMBER ’D:\REDO01.LOG’
While deploying a new application module,the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences?()
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
最新试题
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()
Which three functions are performed by the SQL Tuning Advisor?()
Which three tasks can be performed using a duplicate database?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()