1z0-034 | A Review Of Vivid 1z0-034 dumps
Q11. The DB_BLOCK_CHECKING parameter is set to FALSE.
What level of block checking will be performed?
A. The Oracle database will not perform block checking for any of the data blocks.
B. The Oracle database will perform block checking for the default permanent tablespace only.
C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
Answer: D
Q12. Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Answer: A,D
Q13. You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data older than three years is purged from the flashback archive FLA1.
Answer: D
Q14. You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
A. The time when the last flashback operation in your database was performed
B. The time when the first flashback operation in your database was performed C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
Answer: C
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.
Q15. You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.
What action must you take to achieve this?
A. Run Segment Advisor.
B. Run the SQL Tuning Advisor (STA).
C. Run the Automatic Workload Repository (AWR) report.
D. Run the SQL Access Advisor with a hypothetical workload.
Answer: D
Q16. 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
Q17. You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)
A. It is a smallfile tablespace.
B. It is a bigfile tablespace (BFT).
C. It is a default bigfile tablespace.
D. It is a locally managed tablespace.
E. It is a dictionary-managed tablespace.
Answer: A,D
Specify either SET DEFAULT BIGFILE TABLESPACE or SET DEFAULT SMALLFILE TABLESPACE. If you omit this clause, the default is a smallfile tablespace, which is the traditional type of Oracle Database tablespace. Verify also: SELECT tablespace_name, extent_management, bigfile FROM dba_tablespaces WHERE tablespace_name = 'MYTHBS' TABLESPACE_NAME EXTENT_MANAGEMENT BIGFILE MYTHBS LOCAL NO
Q18. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00'
Identify the files that must be restored to recover the missing tables successfully.
A. Restore the backup of all the data files.
B. Restore the backup of all the data files and the control file.
C. Restore the backup of only the data files that contain the dropped tables.
D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
Answer: A
Q19. Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)
A. An ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Answer: C,D
Q20. Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Answer: D