【单选题】A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer ha...
A.
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
B.
Back up the current transaction log. Restore the database to the point just before the data loss.
C.
Restore the database from the existing backup files to a time just before the data loss.
D.
Restore the database to the point of the last full backup.
【单选题】You are creating a job class. You have issued the following command to create the job class: SQL> BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS( JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’, RESOUR...
A.
The command will be executed successfully.
B.
The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
C.
The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
D.
The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
E.
The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.