You want to perform a backup of your database to tape. Which backup format can you use？（）

相似题目

• You encrypt your files to ensure the security of the files. You want to make a backup copy of the files and maintain their security settings. You have the option of backing up to either the network or floppy disk.  What should you do？（）

  A . Copy the files to a network share on an NTFS volume and do nothing further. B . Copy the files to a network share on a FAT 32 volume and do nothing further. C . Copy the files to a floppy disk that has been formatted by using Windows 2000 Professional.  D . Place the files in an encrypted folder， and then copy the folder to floppy disk.

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

  A . 3 hours B . 6 months C . until last year D . until last commit E . until the point when the undotablespacewas refreshed F . until the database is shut down and the memory erased

  查看最佳答案

• You have two NTP servers 10.1.1.1 & 10.1.1.2 and want to configure a router to use 10.1.1.2 as its NTP server before falling back to 10.1.1.1. Which command will you use？

  查看最佳答案

• You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).

  A . The backup as copy can only be taken to disk B . The backup as copy can only be taken to tape C . Backup can be performed only when the instance is shutdown D . Backup will constitute all used and unused blocks in the database

  查看最佳答案

• You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）

  A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

  查看最佳答案

• You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）

  A . The backup as copy can only be taken to disk B . The backup as copy can only be taken to tape C . Backup can be performed only when the instance is shutdown D . Backup will constitute all used and unused blocks in the database

  查看最佳答案

• Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

  A .  Database datafiles B .  Control files C .  Archived redo logs D .  Online redo logs E .  Flashback log

  查看最佳答案

• You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

  A .  alter tablespace MY_DATA begin backup B .  alter tablespace MY_DATA start backup C .  alter tablespace MY_DATA backup begin D .  alter MY_DATA begin backup E .  You cannot back up individual tablespace

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

  A . Set the UNDO_RETENTION parameter to AUTO. B . Create an initial undo segment in undotablespace. C . Set the UNDO_RETENTION parameter to 900 or more D . Set the initialization parameter UNDO_MANAGEMENT to AUTO E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

  查看最佳答案

• You encrypt three files to ensure the security of the files. You want to make a backup copy of these three files and maintain their security settings. You have the option of backing up to either the network or a floppy disk. What should you do？（）

  A . Copy the files to a network share on an NTFS volume. Do nothing further. B . Copy the files to a network share on a FAT32 volume. Do nothing further. C . Copy the files to a floppy disk that has been formatted by using Win2000 Professional. Do nothing further. D . Place the files in an encrypted folder. Then copy the folder to a floppy disk.

  查看最佳答案

• You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

  A .  Every SQL statement in the STS is considered only once for execution. B .  The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. C .  The execution plan and execution statistics are computed for each SQL statement in the STS.  D .  The effects of DDL and DML are considered to produce the execution plan and execution statistics.

  查看最佳答案

• You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

  A . ALTER DATABASE FLASHBACK ON; B . GRANT SELECT any transaction TO scott; C . GRANT EXECUTE ON dbms_flashback TO scott; D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; E . ALTER TABLESPACE undots1 RETENTION GUARANTEE; F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS

  查看最佳答案

• You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

  A . The source database backup must be copied over the net for test database. B . The source database must be run in ARCHIVELOG mode if the database is open. C . The source database must be shut down cleanly if the database is in mounted state. D . A net service name should be set up and a listener configured with the target as well as the source database.

  查看最佳答案

• Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

  A .  Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs. B .  Just back up the database datafiles without shutting down the database. C .  You will have to wait until you can shut down the database to perform the backup. D .  Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up. E .  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backu

  查看最佳答案

• You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

  A .  The backup as copy can only be taken to disk B .  The backup as copy can only be taken to tape C .  Backup can be performed only when the instance is shutdown D .  Backup will constitute all used and unused blocks in the database

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

  A .  all the data files belonging to the USERS tablespace B .  password file C .  online redo log files D .  the current control file E .  archived redo log files F .  the current server parameter file G .  data files belonging to the USERS tablespace and all the default tablespace

  查看最佳答案

• You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

  A .  You must enable the row movement on the SCOTT.EMP table. B .  You must define the tablespace of the SCOTT.EMP table for automatic segment space management. C .  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement. D .  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

  A . ALTER DATABASE FLASHBACK ON; B . GRANT SELECT any transaction TO scott; C . GRANT EXECUTE ON dbms_flashback TO scott; D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; E . ALTER TABLESPACE undots1 RETENTION GUARANTEE; F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

  A .  ALTER DATABASE FLASHBACK ON B .  GRANT SELECT any transaction TO scott C .  GRANT EXECUTE ON dbms_flashback TO scott D .  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA E .  ALTER TABLESPACE undots1 RETENTION GUARANTEE F .  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

  查看最佳答案

• You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）

  A . Configure the Windows backup to backup the system partition. B . Configure the Windows backup to backup the System State Data. C . Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts. D . Create a batch file to run rdisk.exe/s before the backup starts.

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• You want to get your book back, ______ ？

  A．don't you B．do you C．aren't you

  查看最佳答案