Exam Code: 1Z0-055 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: New Features for 9i OCPs
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-055 Exam.
2021 Jun 1Z0-055 Study Guide Questions:
Q201. View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?
A. The DISK_ASYNCH_IO parameter is set to TRUE.
B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.
C. Another session runs the I/O calibration process concurrently.
D. The pending area has not been created before running the I/O calibration process.
Answer: B
Q202. You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packaged procedure.
Answer: A
Leading 1Z0-055 exam cram:
Q203. 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 also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D
Q204. The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
Answer: D
Refined 1Z0-055 courses:
Q205. View the following SQL statements:
Transaction T1
INSERT INTO hr.regions VALUES (5,'Pole');
COMMIT;
Transaction T2
UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;
COMMIT;
Transaction T3
UPDATE hr.regions SET region_name='North and South Poles' WHERE
region_id = 5;
You want to back out transaction T2. Which option would you use?
A. It is possible, but transaction T3 also backs out.
B. It is possible with the NOCASCADE_FORCE option.
C. It is possible with the NONCONFLICT_ONLY option.
D. It is not possible because it has conflicts with transaction T3.
Answer: B
Q206. Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A. Undo retention guarantee must be enabled.
B. Database must be running in archivelog mode.
C. Automatic undo management must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Answer: C,D
Q207. Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
Answer: C,E