ITPub博客

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

177-Q59: You inadvertently delete some RMAN backups with operation system command. You perform additional backups from RMAN again but you need to remove the deleted backups from the recovery catalog. What commands can you use to clean up the catalog?(Choose all that apply.)A. DELETE EXPIRED...

177-Q54: Your CUSTOMER_ORDER and ORDERJTEMS table is updated daily with both phone orders and Internet orders. During and ad-hoc maintenance operation, an operations specialist accidentally deletes serval items from an order placed last week. Which flashback feature will minimize the loss of rece...

177-Q50: When you perform a whole database backup wuth the command BACKUP DATABASE PLUS ARCHIVELOG, which database objects are included in the backup?(Choose the best answer.)A. All datafiles and archived log files. The control file is included if you add the CONTROLFILE keyword, and the SPFI...

177-Q26: Identify the correct relationships between resource consumer group, resource plan directives, and resource plans.(Choose all that apply.)A. Only one resource plan can be active at a time.B. A user can b a member of only one resource consumer group.C. One resource plan can hav...

177-Q7: You want to ensure the recoverability of the recovery catalog itself. Which of the following steps should you implement to maximize recoverability? (Choose all that apply.)A. Configure the database for ARCHIVELOG mode.B. Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the rec...

177-Q6: Your flash recovery area becomes full when you are running and RMAN backup (and has not yet reached the value specified by DB_RECOVERY_FILE_DEST). It is the destination for archived redo log files and backups. What will happen to the database? (Choose the best answer)A. If you have th...

177-Q161: You want the ability to recover to any time within the last seven days and therefore you configured the recovery window retention policy using the command:RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;After configuring the recovery window, you performed the datab...

117-Q118: You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to a...

177-Q117: Which three are the valid statements in relation to SQL plan baselines?(Choose three.)A. The plans generated for every SQL statement are stored in the SQL plan baseline by default.B. The plans can be manually loaded to the SQL plan baseline.C. The plan baselines are stored t...

177-Q115: You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements with be true in this scena...