Online Access Free 11gocmu Practice Test
| Exam Code: | 11gocmu |
| Exam Name: | Oracle Database 11g Certified Master Upgrade Exam |
| Certification Provider: | Oracle |
| Free Question Number: | 673 |
| Posted: | Sep 07, 2025 |
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
Exhibit:
View the Exhibit for some of the current parameter settings. A user logs in to the HR
schema and issues the following commands:
SQL> CREATE TABLE emp
(empno NUMBER(3),
ename VARCHAR2(20),
sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');
At this moment, a second user also logs in to the HR schema and issues the following
command:
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)