1Z0-040 Oracle Oracle Database 10g New Features for Administrators
QUESTION: 190 Which statement correctly describes setup of a server-persistent parameter file (SPFILE) when used with Real Application Clusters? A. One SPFILE, created from a text parameter file (PFILE), is required for each instance B. You must create a separate text parameter file (PFILE) for each instance and merge them with the CREATIVE SPFILE FROM PFILE= ( list of files); command to create one common SPFILE C. You can add the instance-specific parameters to a common SPFILE with the ALTER SYSTEM ?SCOPE=SPFILE SID=name ; command. D. One common SPFILE is required for all instances; it has a parameter INSTANCE_name_SPFILE, which in turn points to the instance-specific SPFILE Answer: C All instances in the cluster database use the same SPFILE at startup. Oracle recommends, you to use one shared server parameter file (SPFILE) with instance-specific entries. For example, you assign undo tablespaces in your RAC database by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your SPFILE or individual PFILEs. REF. Oracle(r) 10g Database Oracle Clusterware and Oracle Real Application Clusters Guide, 5-7 QUESTION: 191 Which command meets these two criteria? 1 Runs the backup at full speed 2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time. A. RMAN> BACKUP AS COPY DURATION 300 MINIMIZE LOAD DATABASE; B. RMAN> BACKUP AS COPY DURATION 300 MINIMIZE TIME DATABASE; C. RMAN> BACKUP AS COPY DURATION 300 PARTIAL MINIMIZE LOAD DATABASE; D. RMAN> BACKUP AS COPY DURATION 300 PARTIAL MINIMIZE TIME DATABASE; Answer: B 123
By default, when a BACKUP... DURATION command runs out of time before the backup completes, RMAN reports an error. (The effect of this is that if the command is running in a RUN block, the RUN block terminates.) You can control this behavior by adding the PARTIAL option to the BACKUP... DURATION command, as in this example BACKUP DURATION 400 PARTIAL TABLESPACE users FILESPERSET 1; When PARTIAL is used, no error is reported when a backup command is interrupted due to the end of the backup window. Instead, a message showing which files could not be backed will be displayed. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block will continue to execute. When using DURATION you can run the backup with the maximum possible performance, or run as slowly as possible while still finishing within the allotted time, to minimize the performance impact of backup tasks. To extend the backup to use the full time available, use the MINIMIZE LOAD option, REF. Oracle(r) 10g Backup and Recovery Guide, 2-40 and 2-41 QUESTION: 192 Exhibit Which two statements regarding the result of the query shown in the Exhibit are correct? (Choose
You've reached the end of your free preview.
Want to read all 9 pages?
- Fall '20
- Oracle Database