1Z0-055 | Pinpoint Database 11g 1Z0-055 vce
Q21. 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 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
Answer: C
Q23. You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
A. to minimize plan regression due to the use of a new optimizer version
B. to completely avoid the use of new plans generated by a new optimizer version
C. to prevent plan capturing when the SQL statement is executed after the database upgrade
D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
Answer: A
Q24. 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: C
Q25. Which two statements regarding a SQL profile are true? (Choose two.)
A. It is built by Automatic Tuning Optimizer.
B. It cannot be stored persistently in the data dictionary.
C. It can be used by the query optimizer automatically.
D. It can be created manually by using the CREATE PROFILE command.
Answer: A,C
Q26. Which two statements about workload capture and replay operations are true? (Choose two.)
A. The clients must be created manually on the test machines to perform more realistic testing.
B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Answer: C,D
Q27. You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'
Which statement regarding the above command is correct?
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.
Answer: C
Q28. Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B
Q29. You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1:
DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?
A. The tablespace having Flashback Archive is dropped.
B. The Flashback Data Archive FLA1 is dropped only if it is empty.
C. The Flashback Data Archive FLA1 and historical data are dropped.
D. The Flashback Data Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
Answer: C
Q30. Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
Answer: B