The safer , easier way to help you pass any IT exams.
148.Which dependent object will get invalidated even if it is not affected by the table edefinition? A. packages B. triggers C. synonyms D. views Answer: B
149.You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?
A. A different procedure is required to restore a database from compressed backups
B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C. Using this command to create backups minimizes the bandwidth consumed
D. Using this command to create backups improves the performance of the backup process Answer: C
150.You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?
A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up C. Backup optimization is permanently disabled
D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified Answer: B
151.Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance Answer: ABC
152.You are performing incomplete recovery using RMAN. You execute the following RUN block: RUN {
SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE; }
Which statement is true about the result?
A.RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
36 / 193
The safer , easier way to help you pass any IT exams.
B.RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
C.RMAN restores all datafiles and control files from the most recent backup
D.The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command Answer: B
153.You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5;
You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?
A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5; B. ALTER DISKGROUP dg1 UNDROP;
C. ALTER DISKGROUP dg1 UNDROP DISKS; D. You cannot cancel the pending disk drops. Answer: C
154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:
Which is the recommended sequence of operations you need to perform for the query successfully? A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs. 不完全恢复才能使用resetlogs
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. Answer: C
155.Observe the structure of the table employees: The table contains 8475 records.
One of the employees wants to know the names of all employees of the company. For this, he fires the following query: SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to
37 / 193
The safer , easier way to help you pass any IT exams.
complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result? A. Rollback segment B. Temporary segment C. Data segment D. Index segment Answer: B
156.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter? A. The number of DBWR processes increases B. The number of ASMB processes increases C. The number of DBWR_TO_SLAVES increases
D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead
Answer: D
157.The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?
A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Answer: E
158.You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this? A. Implement job classes
B. Implement Scheduler windows
C. Implement the mapping rule for the consumer groups
D. Set the SWITCH_TIME resource plan directive for both the resource plans Answer: B
159.Which package provides API's for the SQL Tuning Advisor? A. DBMS_MONITOR B. DBMS_STATS C. DBMS_SQLTUNE D. DBMS_ADVISOR Answer: C
160.Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.) A. It's only supported for the backups performed on the tape
B. It is not supported for backup operations that produce image copies
C. Duplex backups need a parallelism for the device to be equal to number of copies
D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously Answer: BD
38 / 193
The safer , easier way to help you pass any IT exams.
161.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.) A. Reregistering the target database in recovery catalog
B. Transporting the new tablespaces to the recovery catalog database C. Syncronizing the recovery catalog with the target database control file
D. Performing a fresh backup of the target database to include the new data files in the catalog database
Answer: CD
162.View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities: SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US
FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?
A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
B. The database instance is running with manual shared memory management.
39 / 193
The safer , easier way to help you pass any IT exams.
C. The database instance is running with manual PGA management.
D. The database instance has the MEMORY_TARGET value set to a nonzero value. Answer: D
163.View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented? A. setting the PRE_PAGE_SGA parameter to TRUE B. locking the SGA in memory
C. increasing the value of SGA_MAX_SIZE D. automatic memory management Answer: D
164.View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?
A. The incident has been newly created and is in the process of collecting diagnostic information.
B. The incident is now in the Done state and the ADR can select the incident to be purged. C. The DBA is working on the incident and prefers that the incident be kept in the ADR.
D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support. Answer: D
40 / 193