1Z0-055 | The Secret of Oracle 1Z0-055 practice test


Q131. 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 displays the advice and the RMAN script required for repair. 

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command. 

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR). 

Answer:

Q132. View the Exhibit. 

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity? 

A. CKPT 

B. SMON 

C. MMON 

D. DBWR 

Answer:

Q133. You executed the following command to drop a user: 

DROP USER scott CASCADE; 

Which two statements regarding the above command are correct? (Choose two.) 

A. All the objects of scott are moved to the Recycle Bin. 

B. Any objects in the Recycle Bin belonging to scott are purged. 

C. All the objects owned by scott are permanently dropped from the database. 

D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command. 

E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command. 

Answer: B,C 

Q134. Which two statements are true regarding hot patching? (Choose two.) 

A. It requires relinking of the Oracle binary. 

B. It does not require database instance shutdown. 

C. It can detect conflicts between two online patches. 

D. It is available for installing all patches on all platforms. 

E. It works only in a single database instance environment. 

Answer: B,C 

Q135. You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.) 

A. Extent management is completely automated. 

B. The allocation unit size may vary but the extent size is fixed. 

C. The au_size disk group attribute determines the size of allocation units in the disk group. 

D. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed. 

Answer: A,C 

Q136. Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload: 

1) Preprocess the captured workload. 

2) Restart the database in RESTRICTED mode. 

3) Set up the Replay Clients. 

4) Restore the test database to the point when the capture started. 

5) Remap connections. 

Arrange the steps required in the correct sequence to accomplish this task on the test machine. 

A. 2, 1, 5, 3, 4 

B. 1, 2, 4, 5, 3 

C. 1, 4, 5, 3 (2 is not required.) 

D. 1, 2, 4, 5 (3 is not required.) 

E. 1, 4, 3, 5 (2 is not required.) 

Answer:

Q137. Your database initialization parameter file has the following entry: 

SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 

Which statement is true regarding this setting? 

A. It is enforced only if the password profile is enabled for the user. 

B. It locks the user account after the specified number of attempts. 

C. It drops the connection after the specified number of login attempts fail for any user. 

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege. 

Answer:

Q138. Which statements are true regarding system-partitioned tables? (Choose all that apply.) 

A. Only a single partitioning key column can be specified. 

B. All DML statements must use partition-extended syntax. 

C. The same physical attributes must be specified for each partition. 

D. Unique local indexes cannot be created on a system-partitioned table. 

E. Traditional partition pruning and partitionwise joins are not supported on these tables. 

Answer: D,E 

Q139. On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.) 

A. fixed tables 

B. heap tables 

C. external tables 

D. temporary tables 

E. Index-Organized Tables (IOTs) 

Answer: B,E 

Q140. You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. 

You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.) 

A. Restore metadata in an existing disk group by passing the existing disk name as an input parameter. 

B. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes. 

C. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations. 

D. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group. 

Answer: A,C