1Z0-055 | how many questions of 1Z0-055 vce?
Q111. 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 two.)
A. Health Monitor checks are always initiated manually when there is some critical error.
B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt, or inconsistent.
Answer: B,D
Q113. In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt)
FROM sales
GROUP BY sale_category;
Where would the result of this query be stored?
A. PGA
B. large pool
C. shared pool
D. database buffer cache
Answer: C
Q114. You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:
RMAN>BACKUP
SECTION SIZE 300M
TABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using the above command?
A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.
B. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.
C. The COMPATIBLE initialization parameter for the database instance must be set to at least
10.0.
D. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.
Answer: B
Q115. 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
Q116. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
Answer: D
Q117. 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
Answer: C
Q118. 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.
Answer: E
Q119. Identify three key features of ASM. (Choose three.)
A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management
Answer: A,B,C
Q120. What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
A. It can recommend partitioning only on tables that have at least 10,000 rows.
B. It cannot generate recommendations that support multiple workload queries.
C. It can recommend only B-tree indexes and not bitmap or function-based indexes.
D. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
Answer: A,D