Free Preparation Discussions
MENU
Oracle 1Z0-034 Exam Questions
- Topic 1: Backup and Recovery Concepts/ Describe ways to tune instance recovery/ Configure ARCHIVELOG mode
- Topic 2: Identify the importance of checkpoints, redo log files, and archived log files
- Topic 3: Identify the types of failure that can occur in an Oracle database/ Perform backup and recovery in NOARCHIVELOG mode
- Topic 4: Using the RMAN Recovery Catalog/ Identify situations that require RMAN recovery catalog/ Back up the recovery catalog
- Topic 5: Create and configure a recovery catalog/ Synchronize the recovery catalog/ Create and use a virtual private catalog
- Topic 6: Using RMAN to Create Backups/ Create an archival backup for long-term retention/ Report on and maintain backups
- Topic 7: Create duplex backup and back up backup sets/ Enable fast incremental backup/ Create a whole database backup and image file backups
- Topic 8: Using RMAN to Perform Recovery/ Perform complete recovery from a critical or noncritical data file loss using RMAN
- Topic 9: Perform incomplete recovery using RMAN/ Perform Disaster recovery/ Recover using incrementally updated backups/ Restore a database onto a new host
- Topic 10: Switch to image copies for fast recovery/ Recover using a backup control file
- Topic 11: Using Flashback Technology/ Restore dropped tables from the recycle bin/ Describe the concepts of transportable tablespaces and databases
- Topic 12: Perform Flashback Query/ Transport tablespaces across different platforms/ Transport Data and Tablespaces/ Use Flashback Transaction
- Topic 13: Monitoring and Tuning RMAN/ Monitoring RMAN sessions and jobs/ Performing User-Managed Backup and Recovery/ Configure RMAN for Asynchronous I/O
- Topic 14: Recover from a lost TEMP file, redo log group, password file/ Perform user-managed complete, incomplete database recovery/ Back up and recover a control file Perform user-managed database recovery/ Perform user-managed and server managed backups/ Identify the need of backup mode
- Topic 15: Implement Automatic Memory Management/ Manually configure SGA parameters/ Configure automatic PGA memory management
- Topic 16: Manage resumable space allocation/ Reclaim wasted space from tables and indexes by using the segment shrink functionality/ Implement partitioning methods
- Topic 17: Reduce space related error conditions through proactively managing tablespace usage/ Use different storage options to improve the performance of queries
- Topic 18: Customize language-dependent behavior for the database and individual sessions/ Query data using non-case-sensitive and accent-insensitive searches
- Topic 19: Obtain globalization support configuration information/ Use automatic undo retention tuning and temporary undo/ Using Globalization Support
- Topic 20: Specify different linguistic sorts for queries/ Use datetime datatypes/ Loading and Unloading Data/ Explain Data Pump architecture
Free Oracle 1Z0-034 Exam Actual Questions
Note: Premium Questions for 1Z0-034 were last updated On 05-07-2020 (see below)
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.)
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?
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks.
Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately.
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before Oracle ASM drops the disk. If a disk is made available before the DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of the instance on which the disk is running. You must reissue the command manually to bring the disk online.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!