You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?()
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()
In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? ()
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?()
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?()
View the Exhibit. https://assets.asklib.com/images/image2/2018080210291676439.jpg You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which type of backup would this command perform?()
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
After executing the "show host" command, which of the information below would you see?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RMAN> REPORT NEED BACKUP days 3; What would be the output of this command?()
In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()
Why would you run the delete obsolete command?()
Examine the SQL statements that creates ORDERS table: https://assets.asklib.com/images/image2/201808011530357709.jpg For which columns would an index be automatically created when you execute the above SQL statement? ()
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
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?()