You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command: RMAN>BACKUP DATABASE; At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?()
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration, you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE? ()
The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective?()
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()
You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file: DB_CREATE_FILE_DEST=’devices/grp1/P’ DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’ DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’ BACKGROUND_DUMP_DEST=’devices/d_grp1/S’ You have added a new redo log group that contains two redo log members. Where are the redo log members stored?()
In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
The SPFILE for the PROD database specifies the following initialization parameter values: SGA_TARGET = 2G DB_8K_CACHE_SIZE = 128M You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M: SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH; What is the result of this statement?()