A Review Of Accurate 1z0-034 braindumps
Act now and download your Oracle 1z0-034 test today! Do not waste time for the worthless Oracle 1z0-034 tutorials. Download Up to the immediate present Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP exam with real questions and answers and begin to learn Oracle 1z0-034 with a classic professional.
Q1. The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?
A. Control files
B. Password file
C. Inactive online redo log file
D. Archived log files required to perform recovery
E. Newly created tablespace which is not backed up
The RESETLOGS options is required in:
1. Imcomplete Recovery
2. Change of control file
So that, the control file and archived redo logs are required.
Q2. View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session:
RMAN> BACKUP DATABASE FILESPERSET 2;
The database has seven data files. Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?
A. Because the progress is reported for each data file
B. Because the progress is reported for each backup set
C. Because other RMAN sessions have issued the same BACKUP command
D. Because new data files have been added to the database while the RMAN backup is in progress
Q3. ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
Q4. UNDO__RETENTION is set to 1000 and retention is not guaranteed.
You configure the database with a fixed size undo tablespace.
Which is true about undo retention in this configuration?
A. Undo expires after 1000 seconds and is deleted.
B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.
C. Inactive undo is retained for at least 1000 seconds if free undo space is available.
D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSAUX tablespace to provide read consistency.
Q5. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Q6. Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)
A. setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.
Q7. For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables (IOTs)
Q8. Which two statements are true about a job chain? (Choose two.)
A. A job chain can contain a nested chain of jobs.
B. The jobs in a job chain cannot have more than one dependency.
C. A job of the CHAIN type can be run using event-based or time-based schedules.
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
Defining Chain Steps After creating a chain object, you define one or more chain steps. Each step can point to one of the following:
You define a step that points to a program or nested chain by using the DEFINE_CHAIN_STEP procedure. An example is the following, which adds two steps tomy_chain1:
Q9. What two are the prerequisites for enabling Flashback Database?
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
Q10. You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
A. The online redo log files and archived redo log files are required to accomplish the recovery
B. The uncommitted transaction will be committed at the next startup of the database instance
C. The uncommitted transaction is rolled back automatically at the next opening of the database
D. The DBA has to perform the recovery on the database to recover the uncommitted transaction