1z0-034 | Improve Oracle 1z0-034 dumps
Q21. 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
Online Patching Regular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain .so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll back online patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaround time for installing or de-installing Online Patches.
A regular RDBMS patch can require many minutes to install, since it requires instance shutdown,
a relink, and instance startup. On the other hand, you can install an online patch in just a few
seconds.
Online patches are only applicable for Oracle RDBMS and not any other products. Online patches
are currently supported on the following Windows and UNIX platforms for version 11.2.0.1.0 and
later:
About Patch Conflicts:
All patches may not be compatible with one another. For example, if you apply a patch, all the
bugs the patch fixes could reappear after you apply another patch. This is called a conflict
situation. OPatch detects such situations and raises an error when it detects a conflict.
Q22. Which two statements are true about the duplexing of the backups taken by RMAN?
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: B,D
Q23. You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP
=>'group1', COMMENT => 'New Group'); This command errors out displaying the following message:
ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1
What action would you take to overcome this error?
A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area
Answer: B
Q24. Which two statements are correct about database transportation? (Choose two.)
A. The source and target platforms must be the same
B. Redo logs, control files and temp files are also transported
C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
Answer: D,E
Q25. Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'
}
Which statement is true regarding the approach in the command?
A. The RMAN multiplexing level is 4.
B. It is the use of asynchronous I/O by RMAN.
C. It is a case of parallelization of the backup set.
D. It is an implementation of a multi section backup.
Answer: C
Q26. While designing a database, you created the EMPLOYEES table as an index-organized table (IOT).
You must create a bitmap index on the EMPLOYEES .JOB_ID column.
Which must you do to enable the creation of the bitmap index?
A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.
Answer: B
Q27. You issued the following commands to configure settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived logfile
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived logfile
Answer: D
Q28. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?
A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
Answer: A
Q29. SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
704 SQL> ALTER TABLE altb SHRINK SPACE COMPACT; Table altered. SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*; BLOCKS
704 View the Exhibit and examine the output and commands executed on the ALTB table. Why does the number of blocks for the table remain the same after the shrink operation?
A. because the table did not contain migrated or chained rows
B. because the row IDs remain the same for all rows during the shrink operation
C. because the progress of the shrink operation is not saved in the bitmap blocks of the table
D. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation
Answer: D
Q30. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: B,E