ITPub博客

（97）The RECYCLEBIN parameter is set to ON for your database.You drop a table,PRODUCTS,from the SCOTT schema.Which two statements are true regarding the outcome of this action?(Choose two)A. All the related indexes and views are automatically droppedB. The flashback drop feature can reco...

（96）Examine the following command:SQL>ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The shrink operation touches every block in the BOOKING tableB. The high-water mark(HWM)for the BOOKING table is shifted from its orig...

（95）Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago.Log files switches have occurred in last two days.The target database is duplicated on the same host,using the Recovery Manager(RMAN) dupli...

（94）Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN sc...

（93）The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recovery with the RESETLOGS option?(Choose two)A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log fi...

（92）You observed the following output for a user session:What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit ...

（91）Your database interface is running. A user SCOTT starts a SQL*Plus session,and issues the following query:SQL>SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?A. User processB. Server processC. System Monitor(S...

（90）View the exhibit and examine the output. Which statement can be an inference from the output?Exhibit:A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. The number of times that the backup or r...

（89）You are using recovery Manager(RMAN)with a recovery catalog to backup up your production database.The backups and the archived redo log files are copied to a tape drive on a daily basis.The database was open and transactions were recorded in the redo logs.Because of fire in the buil...

（88）In your database,the flash recovery area(FRA)is configured as the default for RMAN backups.You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?A. Only one channel is allocated and the backup is created in the flash reco...

（87）You want to perform an RMAN backup of database as a copy.Which two factors will you consider while performing the backup operation?(Choose two).A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the ...

（86）Your production database is running in archivelog mode and you are using recovery manager(RMAN)with recovery catalogto perform the database backup at regular intervals.When you attempt to restart the database instance after a regular maintenance task on Sunday,the database fails to ...

（85）You executed the following command to drop a user: DROP USER scott CASCADE;Which two statements regarding the above command are correct?(Choose two.)A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All th...

（84）View the Exhibit and examine the Data Pump architecture. Identify the numbered components.A. 1-Oracle Loader,2-Oracle Data Pump,3-Direct Path APIB. 1-Oracle Data Pump,2-Direct Path API,3-Oracle LoaderC. 1-Direct Path API,2-Oracle Loader,3-Oracle Data PumpD. 1-Oracle Loader,2-Dire...

（83）Which three actions are required to configure the Flashback Database?(Choose three.)A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode答案：（A、B、D...

（82）Identify the three predefined server-generated alerts.(Choose three.)A. Drop UserB. Tablespace Space UsageC. Resumable Session SuspendedD. Recovery Area Low On Free SpaceE. SYSTEM Tablespace Size Increment答案：（B、C、D）

（81）Evaluate the following command and its output:SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACELMTEMP                       &n...

（80）Which two statements regarding a SQL profile are true?(Choose two.)A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PRO...

（79）You executed the following command:RMAN>RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above command is correct?A. The'/u01/app/oracle/oradata/orcl/users01.dbf 'data file is recovered from the image copy.B. The'/u01/app/oracle/o...

（78）You enable block change tracking.You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day,you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?A. RMAN reads th...