Exambible offers free demo for 1Z0-055 exam. "Oracle Database 11g: New Features for 9i OCPs", also known as 1Z0-055 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-055 exam, will help you answer those questions. The 1Z0-055 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-055 exams and revised by experts!
♥♥ 2018 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-055 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q11. Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?
A. The database must be running in ARCHIVELOG mode.
B. No special setup is required, and the feature is enabled by default.
C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
Q12. Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:
What is the significance of executing this script?
A. It performs parallel recompilation of only the stored PL/SQL code.
B. It performs sequential recompilation of only the stored PL/SQL code.
C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
Q13. View the Exhibit to examine the parameter values.
You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?
A. 90 MB
B. 272 MB
C. 362 MB
D. 1440 MB
Q14. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'
To which disks in the disk group will the new value be applicable?
A. all disks in the disk group
B. all disks that are currently in OFFLINE mode
C. all disks that are not currently in OFFLINE mode
D. all disks in the disk group only if all of them are ONLINE
Q15. Examine the following RMAN command:
KEEP UNTIL 'SYSDATE+1'
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only if the database is open during the backup.
C. The backup is deleted after one day, regardless of the default retention policy settings.
D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
Q16. View the Exhibit exhibit1 to observe the maintenance window property.
View the Exhibit exhibit2 to examine the output of the query.
Which two statements describe the conclusions? (Choose two.)
A. The window duration should be increased.
B. RESOURCE_PERCENTAGE should be increased.
C. RESOURCE_PERCENTAGE should be decreased.
D. The repeat time for the window should be decreased.
Q17. You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
A. Data Pump Export and Import
B. conventional export and import
C. the CONVERT command of RMAN
D. the BACKUP AS COPY.. command of RMAN
Q18. Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?
A. It produces an error because data already exists in the table.
B. It produces an error because compression can be enabled at table creation only.
C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
Q19. View the Exhibit exhibit1.
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US"
View the Exhibit exhibit2 to examine the commands and query plans.
The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?
A. Set the STATISTICS_LEVEL parameter to TYPICAL.
B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
C. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
D. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns.
Q20. 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.