单选题You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()Athe XML scriptBthe PL/SQL scriptCthe DBMS_SCHEDULER packageDEnterprise Manager to schedule the backup

单选题
You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()
A

the XML script

B

the PL/SQL script

C

the DBMS_SCHEDULER package

D

Enterprise Manager to schedule the backup


参考解析

解析: 暂无解析

相关考题:

You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A.Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B.Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C.Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD.Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

You are the network administrator for All network servers run Windows Server 2003.A member server named TESTKING1 hosts several hundred folders, which residein various locations on the server. TESTKING1 is configured to run a normalbackup of the folder every Saturday at 1:00 A.M.You discover that users edit the contents of the folders on Saturday and Sunday.You need to use the Backup utility to reschedule the backup job so that it runs everyMonday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve thisgoal by using the minimum amount of administrative effort.What should you do?()A. Specify Monday as the start date of the job.B. Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.C. Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.D. Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.

You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler()A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from = http://www.amaderforum.comD、Recovery Manager (RMAN) script

You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?()A、Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.B、Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.C、Schedule a copy backup every day.D、Schedule a normal backup every day.

You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()A、SQL*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this? ()A、The DBMS_JOB packageB、The BACKUP_JOB packageC、The DBMS_BACKUP_RESTORE packageD、The calendar tool in the Operating System (OS)E、The backup scheduler in Enterprise Manager (EM)F、The DBMS_BACKUP_SCHEDULER packager inline mode

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()A、 Backup of offline tablespaces.B、 Backup of read-only tablespaces.C、 Backup of system-critical tablespaces.D、 Backup of online, locally managed tablespaces.E、 Backup of read/write dictionary-managed tablespaces.

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()A、backup of offline tablespacesB、backup of read­only tablespacesC、backup of system­critical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionary­managed tablespaces

While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager (RMAN)commands after creating the databaseE、schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()A、the XML scriptB、the PL/SQL scriptC、the DBMS_SCHEDULER packageD、Enterprise Manager to schedule the backup

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script

You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()A、SQL scriptB、PL/SQL scriptC、Operating System (OS) scriptD、Enterprise Manager (EM) scriptE、Recovery Manager (RMAN) script

You are the administrator of your company's network. You are preparing to deploy 20 new Windows 2000 Professional computers on your network. You want to be able to recover from disk failures and corrupt system files on the new computers. You want to configure the computers to automatically update their system configuration and emergency repair files on a scheduled bases.   What should you do?()A、Use the at command to schedule a weekly job to back up the boot partition.B、Use the at command to schedule a weekly job to run the system file checker.C、Use Windows backup to schedule a backup of the System State Data.D、Use Windows backup to schedule a backup of the system partition and the boot partition.

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1.  In the options below, which Transact-SQL statement should you use? ()  A、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos;; B、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION; C、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH DIFFERENTIAL; D、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION,DIFFERENTIAL;

You use Windows 2000 Professional on your desktop Computer. You schedule a task to run an MMC snap-in to perform configuration tasks on other computers. You notice that the task is not completing correctly. You manually start MMC. You add the snap-in. You are then able to successfully run the task. You verify that all of your other tasks are working correctly. You want to enable your tasks to complete successfully. What should you do?()A、Use Scheduled Tasks to configure the task to run under the security context of your account.B、Configure the Task Scheduler service account to use a local Administrator account and password.C、Use Computer Management to start the Messenger service and to configure the Messenger service to start automatically. D、Use Computer Management to start the Task Scheduler service and to configure the Task Scheduler service to start automatically.

You are a database administrator for your company. Each night, you perform full backups of your SQL Server 2005 computer. During business hours, you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do?()A、Schedule the full backups to run after the nightly index is rebuilt.B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

单选题You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler()AXML scriptBPL/SQL scriptCOperating system scriptDRecovery Manager (RMAN) script

单选题You are the administrator of your company's network. You are preparing to deploy 20 new Windows 2000 Professional computers on your network. You want to be able to recover from disk failures and corrupt system files on the new computers. You want to configure the computers to automatically update their system configuration and emergency repair files on a scheduled bases.   What should you do?()AUse the at command to schedule a weekly job to back up the boot partition.BUse the at command to schedule a weekly job to run the system file checker.CUse Windows backup to schedule a backup of the System State Data.DUse Windows backup to schedule a backup of the system partition and the boot partition.

单选题You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler()AXML scriptBPL/SQL scriptCOperating system scriptThis document was downloaded from = http://www.amaderforum.comDRecovery Manager (RMAN) script

单选题You want to configure and schedule offline database backups to run automatically.  Which tool or utility wouldyou use to achieve this()AThe XML scriptBThe PL/SQL scriptCThe DBMS_SCHEDULER packageDEnterprise Manager to schedule the backup

单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn';t run Wednesday.  So what action should you perform to achieve this goal?()AYou should remove the schedule for Wednesday from Job5. BYou should add a new Job5 schedule for Wednesday and disable it. CYou should delete the schedule for Wednesday. DYou should disable the schedule for Wednesday.

单选题You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?()ASchedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.BSchedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.CSchedule a copy backup every day.DSchedule a normal backup every day.

单选题You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()ASQL scriptBPL/SQL scriptCOperating System (OS) scriptDEnterprise Manager (EM) scriptERecovery Manager (RMAN) script

单选题You are a database administrator for your company. Each night, you perform full backups of your SQL Server 2005 computer. During business hours, you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do?()ASchedule the full backups to run after the nightly index is rebuilt.BSchedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.CSchedule an additional transaction log backup to run after the nightly index is rebuilt.DSchedule a marker to be added to the transaction log before the nightly index is rebuilt.

单选题You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()AThe DBMS_JOB packageBThe BACKUP_JOB packageCThe DBMS_BACKUP_RESTORE packageDThe calendar tool in the Operating System (OS)EThe backup scheduler in Enterprise Manager (EM)FThe DBMS_BACKUP_SCHEDULER packager inline mode

单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()AIt is a SQL script.BIt is a PL/SQL file.CIt is an operating system (OS) file.DIt is a Recovery Manager (RMAN) script