You are managing an Oracle Database 11g database with the following backup strategy: 1.On Sunday, an incremental level 0 tape backup is performed. 2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed. Which two statements are true regarding the backups performed()
You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group?()
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario?()
You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are: 1:Configure the database to operate in shared server mode. 2:Disable automatic maintenance tasks such as optimizer statistics collection. 3:Configure a naming method to help the remote user connect to the database instance. 4:Use Automatic Storage Management (ASM) for storing the database files. 5:Configure daily database backup to flash recovery area. 6:Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database()
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file: ORA-19815: WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area()
You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database()
How many different calendars does Oracle 11g support?()
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?()
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? ()
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?()