The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()
相似题目
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
-
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()
-
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)
-
The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()
-
A customer is deploying a new database on a PS701 Blade in a BladeCenter H, and requires redundant network and SAN adapters. Which configuration supports the customer requirement?()
-
You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN,and adequate storage is available. Which of the following options should youchoose for your quorum configuration?()
-
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
-
The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command: RMAN>CONFIGURE MAXSETSIZE 10MB; What will be the impact of the above setting?()
-
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
-
Which command is used to alter the attributes of "log type" defined in the alog configuration database?()
-
Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
-
You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()
-
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?()
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
-
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()
-
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
-
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
In your database, the flash recovery area (FRA) is configured as the default for RMAN back
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()