-
Why would you execute the report obsolete command？（）
A . To list all backups that were no longer available for restore operations
B . To list all backups that had aged beyond the RMAN retention criteria
C . To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D . To list all datafiles that are no longer part of the database and thus do not need to be backed up
E . To list all archived redo logs that are no longer needed for any database recovery
-
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? （）
A . to execute a specified method of a Java class
B . to reference a variable or invoke a method of a custom Java Object
C . to pass variables between two different workflows
D . to create an object for the purpose of executing methods on a remote computer
E . to get a reference to the Contact and Session states
F . to allow for arguments to be passed to a specified method
-
In which situation would you use the Oracle Shared Server configuration？（）
A . when performing export and import using Oracle Data Pump
B . when performing backup and recovery operations using Oracle Recovery Manager
C . when performing batch processing and bulk loading operation in a data warehouse environment
D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
-
For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)
A . setting idle timeout limits on resource plans
B . saving storage space by using compressed backup sets
C . creating jobs that will run automatically at a scheduled time
D . assigning priorities to jobs to manage access to system resources
E . creating alerts to perform notification when tablespaces are low on available space resource
-
Generally，when lifting an inflatable liferaft back aboard ship you would use the（）.
A . towing bridle
B . main weather cover
C . external lifelines
D . righting stra
-
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter?（）
A . FIND_TIMER
B . CREATE_TIMER
C . SET_TIMER
D . DELETE_TIMER
E . GET_APPLICATION_PROPERTY
-
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
When passing a hawser to the dock you would first use what line（）.
A . Gantline
B . Heaving line
C . Preventer
D . War
-
Why would you run the delete obsolete command？（）
A . To remove missing backup set pieces physically from disk
B . To remove metadata related to backup set pieces in the control file and the recovery catalog
C . To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
D . To delete backup set pieces associated with backups that are no longer needed due to retention criteria
E . To remove old versions of RMAN backu
-
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? （）
A . &
B . ACCEPT
C . PROMPT
D . &&am
-
In which case would you use the Flashback Database feature to perform a recovery？（）
A . to recover a dropped tablespace
B . to recover data from a truncated table
C . to recover a data file that has been shrunk
D . to recover a database to the state that existed before the RESETLOGS operatio
-
Why would you use WebLogic Diagnostics Framework （WLDF） instead of Oracle Enterprise Manager （OEM） （）
A . WLDF has better performance than OEM
B . my organization already has a solution for unified management and monitoring； we need to supplement that with some specific WLS-related capabilities
C . OEM is not certified with latest version of WLS
D . OEM is really focused on the database tier， is not meant to address JEE management and monitoring
-
For which two situations would you use functionality provided by the Resource Manager?（）
A . setting idle timeout limits on resource plans
B . saving storage space by using compressed backup sets
C . creating jobs that will run automatically at a scheduled time
D . assigning priorities to jobs to manage access to system resources
E . creating alerts to perform notification when tablespaces are low on available space resource
-
Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
7.Your classmate from Britain would like to borrow your computer this weekend. Unfortunately, you need to use it at the same time. How would you refuse the request politely?
-
7.Your classmate from Britain would like to borrow your computer this weekend. Unfortunately, you need to use it at the same time. How would you refuse the request politely?
-
Which of the following professional greeting would you use if you do not know the recipient?
-
Why might you choose to organize your paper using the compare then contrast format?
-
Why did the tribe from Central Africa describe the picture differently from how you or I would describe the photo?
-
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed？（）
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation
