ITPub博客

593.Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?a. shutdown immediate from RMANb. Log into RMANc. startup mount from RMANd. backup databasee. alter database openf. backup database plus archivelog delete inputA. b, c...

590.Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?A. Differential incremental backupB. Different incremental backupC. Cumulative backupD. Cumulative incremental backupAnswer: A哪种备份类型的备份只备份自同一级别的最新备份或较低...

589.Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles, archive logs, and control filesC. All datafiles and control filesD. All the used blocks in a datafileAnswer: D以下哪一个最好的描述了一个完整的备份？D. 数据文件中所有使用的数据块...

545.When performing an online backup, what is the proper order of the following steps?a. Issue the alter database end backup command.b. Back up the archived redo logs.c. Issue the alter database begin backup command.d. Back up the database files.e. Determine the beginning log sequence number.f...

544.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 archi...

517.Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.C. Uncorrupted blocks from the flash...

512.Which two statements correctly describe the relationship among the Scheduler components:job,program, and schedule? (Choose two)A. A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as part of a sc...

511.You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/archLOG_ARCH1VK_D...

597.What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIAB. CONFIGURE DEFAULT DEVICE TYPE TO TAPEC. CONFIGURE DEFAULT DEVICE TYPE TO SBTD. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPEAnswer: C...

166.Note the output of the following query;SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;FLASHBACK_ARCHIEVE_NAME STATUSFLA1You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;What ...

574.A user sends you an email with the following error message: create table idtable(id number)*ERROR at line 1:ORA-01116: error in opening database file 4ORA-01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbfORA-27041: unable to open fileLinux Error: 2: No such file or directoryAdditi...

199.When youre performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)A. The SYSTEM tablespace.B. The UNDO tablespace.C. All tablespaces with tables.D. All tablespaces with indexes.E. No tablespaces are automa...

190.You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsing RMAN, ...

115.What are the advantages of variable extent size support for large ASM files? (Choose two.)A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.B. It improves performance in the extended cluster configuration by reading from a local copy...

229.Which statements are true regarding SecureFile LOBs? (Choose all that apply.)A. The amount of undo retained is user controlled.B. SecureFile LOBs can be used only for nonpartitioned tables.C. Fragmentation is minimized by using variable-sized chunks dynamically.D. SecureFile encryption allow...

177-Q104: Which of the following RMAN commands performs a recovery process by applying incremental backups and archived redo logs to a restored backup?A. SET NEWNAMEB. SWITCHC. CROSSCHECKD. RECOVERE. CATALOGF. RESTOREAnswer: D

177-Q98: Which of the following are segment types in a database? Each correct answer represents a complete solution.(Choose all that apply.)A. DataB. IndexC. SchemaD. UndoAnswer: A B D

177-Q90: Martha is a employee in Tech-Mart Inc. The company uses an Oracle database. The database contains a table named Employees for storing employee records. Martha is performing an insert operation on the Employees table. After some time, the insert operation fails. Which of the following typ...

177-Q69: You work as a Database Administrator for Veedol Inc. Your manager wants you to run a job that updates the transaction table every 30 minutes. To schedule the job, you have to set the value of the interval element. Which of the following setting for the repeat_interval argument will archi...

177-Q68: In RMAN, you execute the command CONFIGURE BACKUP OPTIMIZATION ON so that you can avoid backing up objects that are already backed up sufficiently within the retention policy. However, you want to make an additional backup of the USERS tablespace to a removable disk for offsite storage. ...