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 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
相关考题:
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode foran installation?()A、Run the root.sh script.B、Create the oraInst.loc file.C、Create the tnsnames.ora file.D、Run the oraInstRoot.sh script.
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 have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?()A、 .SQL B、 .PLL C、 .PLDD、 .PRT
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
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()A、Run the root.sh script.B、Create the oraInst.loc file.C、Create the tnsnames.ora file.D、Run the oraintRoot.sh script.
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?()A、 It must be executed from the Oracle Database 11g environment.B、 It must be executed only after the SYSAUX tablespace has been created.C、 It must be executed from the environment of the database that is being upgraded.D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
You issued the following statement: SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?() A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
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 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 want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()A、 column sizesB、 column data typesC、 PCTFREED、 projected number of rowE、 PCTUSED
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
You issue this RMAN command: RMAN create script Level0Backup { backup incremental level 0 format ‘/u01/db01/backup/%d_%_Sp’ fileperset 5 (database include current controlfile); sql ‘alter database archive log current’; } Which three statements are true about the Level0Backup script you just created?()A、The script is stored only in the control file.B、The script is stored only in the recover catalog.C、The script can be executed only by using the RMAN RUN command.D、The commands of the script can be displayed with the LIST command.E、The commands of the script can be displayed with the PRINT command.F、The commands of the script can be displayed with the REPORT command.
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
单选题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 backed up the control file to trace. Which statement is true about the trace file generated?()AThe trace file is in binary format.BThe trace file has a SQL script to re-create the control file.CThe trace file is a backup set created during the backup of the control file. DThe trace file contains the instructions to manually re-create the control file.EThe trace file is an image copy of the control file created during the backup of the control file.
单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()A space allocated in the tablespaceB space required for the bitmap index on a column of the tableC space remaining in the tablespace after creating the tableD estimated value of the PCTFREE storage parameter
单选题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 issued the following statement: SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()A The control file will be multiplexed.B The control file will be recreated.CThe script containing the CREATE CONTROLFILE statement will be created.D The binary backup of the control file will be created.
单选题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 want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()A column sizesB column data typesC PCTFREED projected number of rowE PCTUSED
单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?()A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题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 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 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