1z0-034 | All About Pinpoint 1z0-034 pdf
Q51. You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
A. ALTER TABLESPACE adtbs RESIZE 20G;
B. ALTER TABLESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
Answer: A,C
C:sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> CREATE BIGFILE TABLESPACE adtbs
DATAFILE'C:adtbs.dbf' SIZE 1G;
Tablespace created.
(A)
SQL> ALTER TABLESPACE adtbs RESIZE 2G
Tablespace altered.
(B)
and (D)
SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:adtbs.dbf' SIZE 1G;
ALTER TABLESPACE adtbs ADD DATAFILE 'C:adtbs.dbf' SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
(C)
SQL> ALTER TABLESPACE adtbs AUTOEXTEND ON;
Tablespace altered.
(E)
SQL> ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:adtbs.dbf' AUTOEXTEND ON;
ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:adtbs.dbf' AUTOEXTEND ON
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
Q52. To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)
A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
Answer: C,D
Q53. Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
A. The MTTR advisor will be disabled.
B. Automatic checkpoint tuning will be enabled.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.
Answer: B,C
Q54. Which four resources can directives be specified by using the Oracle Resource Manager?
A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of I/Os requests
Answer: A,B,E,F
Q55. Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache.
B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
Answer: A,E
Direct NFS provides faster performance that what can be provided by the operating system's NFS driver as Oracle bypasses the operating system and generates exactly the requests it needs (no user configuration or tuning required). Data is cached just once in user space, which saves memory (no second copy in kernel space). Performance is further improved by load balancing across multiple network interfaces (if available).
Q56. You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.
A. The data file backup is done with multiple channels
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing feature
Answer: C,D
Q57. In which two aspects does hot patching differ from conventional patching? (Choose two.)
A. It consumes more memory compared with conventional patching.
B. It can be installed and uninstalled via OPatch unlike conventional patching.
C. It takes more time to install or uninstall compared with conventional patching.
D. It does not require down time to apply or remove unlike conventional patching.
E. It is not persistent across instance startup and shutdown unlike conventional patching.
Answer: A,D
Q58. You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1. Restore an autobackup of the server parameter file.
2. Restore the control file
3. Start the target database instance
4. Mount the database
5. Restore the data files
6. Open the database with RESETLOGS option
7. Recover the data files
8. Set DBID for the target database
Which option illustrates the correct sequence that you must use?
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
Answer: A
Recovering the Database After a Disaster The procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring the database to a new host, then you should also review the considerations described in "Restoring a Database on a New Host". This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database to Oracle Secure Backup and have the tapes available. The scenario assumes the following:
To recover the database on the new host:
1. If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.
2. Start RMAN and connect to the target database instance.
At this stage, no initialization parameter file exists. If you have set ORACLE_SID and
ORACLE_HOME, then you can use operating system authentication to connect as SYSDBA. For
example, start RMAN as follows:
% rman RMAN> CONNECT TARGET /
3. Specify the DBID for the target database with the SET DBID command, as described in
"Restoring the Server Parameter File".
For example, enter the following command:
SET DBID 676549873;
4. Run the STARTUP NOMOUNT command.
When the server parameter file is not available, RMAN attempts to start the instance with a
dummy server parameter file.
5. Allocate a channel to the media manager and then restore the server parameter file from
autobackup.
For example, enter the following command to restore the server parameter file from Oracle Secure
Backup:
RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; RESTORE SPFILE FROM AUTOBACKUP; }
6. Restart the instance with the restored server parameter file.
STARTUP FORCE NOMOUNT;
7. Write a command file to perform the restore and recovery operation, and then execute the command file.
The command file should do the following:
a. Allocate a channel to the media manager.
b. Restore a control file autobackup (see "Performing Recovery with a Backup Control File and No
Recovery Catalog").
c. Mount the restored control file.
d. Catalog any backups not recorded in the repository with the CATALOG command.
e. Restore the data files to their original locations. If volume names have changed, then run SET
NEWNAME commands before the restore operation and perform a switch after the restore
operation to update the control file with the new locations for the data files, as shown in the
following example.
f. Recover the data files. RMAN stops recovery when it reaches the log sequence number
specified.
RMAN> RUN { # Manually allocate a channel to the media manager ALLOCATE CHANNEL t1 DEVICE TYPE sbt; # Restore autobackup of the control file. This example assumes that you have
# accepted the default format for the autobackup name.
RESTORE CONTROLFILE FROM AUTOBACKUP;
# The set until command is used in case the database
# structure has changed in the most recent backups, and you want to
# recover to that point in time. In this way RMAN restores the database
# to the same structure that the database had at the specified time.
ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 1124 THREAD 1;
RESTORE DATABASE;
RECOVER DATABASE;
}
The following example of the RUN command shows the same scenario except with new file
names for the restored data files:
RMAN> RUN
{
# If you must restore the files to new locations,
# use SET NEWNAME commands:
SET NEWNAME FOR DATAFILE 1 TO '/dev/vgd_1_0/rlvt5_500M_1'
SET NEWNAME FOR DATAFILE 2 TO '/dev/vgd_1_0/rlvt5_500M_2'
SET NEWNAME FOR DATAFILE 3 TO '/dev/vgd_1_0/rlvt5_500M_3'
ALLOCATE CHANNEL t1 DEVICE TYPE sbt;
RESTORE CONTROLFILE FROM AUTOBACKUP;
ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 124 THREAD 1;
RESTORE DATABASE;
SWITCH DATAFILE ALL; # Update control file with new location of data files.
RECOVER DATABASE;
}
8. If recovery was successful, then open the database and reset the online logs: ALTER DATABASE OPEN RESETLOGS;
Q59. While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?
A. DBA_JOBS
B. V$SESSION
C. V$SESSION_LONGOPS
D. DBA_DATAPUMP_JOBS
E. DBA_DATAPUMP_SESSIONS
Answer: D
When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself.
* monitor jobs from multiple locations
* stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater
* kill any Datapump job anytime
* see the progress of the import or export operations
REF.: Metalink Note: 262557.1
Q60. The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.
Which statement is true while performing a tape backup in an RMAN session?
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Answer: C
Tape I/O Slaves RMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA),depending on whether I/O slaves are used. If you set the initialization parameter BACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only beaccessed by one process at a time, so RMAN starts as many slaves as necessary for the number of tapedevices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers from thelarge pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA. If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory toholding these large memory allocations. This parameter prevents RMAN I/O buffers from competing with thelibrary cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space in theSGA for them, slaves are not used, and a message appears in the alert log. The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than thenumber of slave processes. Tape devices can only be accessed by one process at a time, and RMAN uses thenumber of slaves necessary for the number of tape devices.