1Z0-055 | A Review Of Tested 1Z0-055 vce
Q41. 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. Create a new scheduler window for a time period of two hours.
D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
Answer: B
Q42. 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
Q43. ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
Answer: C
Q44. 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
Q45. 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.)
A. Define the POWER option while adding or removing the disks.
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
Answer: A,B
Q46. USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
B. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.
Answer: A,B,C
Q47. View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.
What is the reason for this error?
A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
Answer: A
Q48. Which two prerequisites are needed for performing workload capture and replay? (Choose two.)
A. setting up the directory to capture the workload
B. running the database in shared server mode
C. Close all sessions performing queries using database links.
D. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
Answer: A,D
Q49. You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data older than three years is purged from the flashback archive FLA1.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
Answer: B
Q50. You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Answer: C