You can pass easily using 1Z0-055 dumps. We keep postings these 1Z0-055 exam questions answers on this site regularly. Some search words are 1Z0-055 braindumps, study material, past papers, real questions, practice test dumps.
splitQ71. Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
splitQ31. 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 Q32. Following is the
splitQ101. What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.) A. selection of SQL plan baselines B. partitioning of tables and indexes C. creation of index-organized tables D. creation of bitmap, function-based, and B-tree indexes E. optimization of materialized views for maximum query usage and fast refresh Answer: B,D,E Q102. Wh
splitQ171. The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework? A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendati
splitQ1. Evaluate the following command: SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command? A. The LOB values are automatically compressed. B. The LOB values are cached by default in the buffer cache. C. The LOB values are automatically stored in encrypted mode. D. All LOB data that is iden
splitQ11. In which two aspects does hot patching differ from conventional patching? (Choose two.) A. It consumes more memory compared with conventional patching. B. It can be installed and uninstalled via OPatch unlike conventional patching. C. It takes more time to install or uninstall compared with conventional patching. D. It does not require down time to apply or remove unlike conventiona
splitQ61. What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.) A. ORACLE_BASE should be set explicitly. B. An Oracle base should have only one Oracle home created in it. C. Flash recovery area and data file location should be on separate disks. D. Flash recovery area and data file location should b
splitQ91. Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning? A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR). B. The VALIDATE DATABASE command has detected new failur
splitQ81. Which three actions are required to configure the Flashback Database? (Choose three.) A. set Flash Recovery Area B. enable Flashback logging C. create FLASHBACK tablespace D. start the database in the ARCHIVELOG mode E. start the database in the NOARCHIVELOG mode Answer: A,B,D Q82. While deploying a new application module, the software vendor ships the application software along
splitQ161. You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.) A. It stores only the temporary table but not it
splitQ51. View the Exhibit and examine the Data Pump architecture. Identify the numbered components. A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump Answer: A Q52. You performed the R
splitQ41. The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do? A. Create two custom ADDM tasks. B. Modify the AWR snapshot time interval to two hours. C. Cr
splitQ151. You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.) A. You are backing up to tape and your tape device performs its own compression. B. You are making image copies, and you have not enabled tablespace compression. C. You are using disk-based backups and disk space in your Flash Recovery Area, or o
splitQ141. You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.) A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. B. The value of the MEMORY_MAX_TARGET
splitQ131. View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session: RMAN> REPAIR FAILURE; Which statement describes the consequence of the command? A. The command performs the recovery and closes the failures. B. The command only displa
splitQ121. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.) A. Its entries are specific to a single database. B. It contains file systems that have been mounted by Direct NFS. C. It is globally available to all Oracle 11g databases on the machine. D. I
splitQ111. Which three actions are required to configure the Flashback Database? (Choose three.) A. set Flash Recovery Area B. enable Flashback logging C. create FLASHBACK tablespace D. start the database in the ARCHIVELOG mode E. start the database in the NOARCHIVELOG mode Answer: A,B,D Q112. Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose tw
splitQ21. Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? A. when ASM disk goes offline B. when one or more ASM files are dropped C. when some disks in a disk group are offline D. when some disks in a failure group for a disk group are rebalancing Answer: C Q22. View the Exhibit to examine the parame