You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases?()
Identify the situations in which you use the alert log file in your database to check the detail.()
You issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
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()
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database: SET UNTIL TIME = ’2000-12-09:11:44:00’; RESTORE DATABASE; RECOVER DATABASE; How should the commands be executed? ()
Identify the two situations in which you use the alert log file in your database to check the details.()
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?()
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 are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file?()
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
Examine the parameter setting in your database: https://assets.asklib.com/images/image2/2018080215045780340.jpg Which statement is correct about the database?()
In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting()
In your database, the flash recovery area (FRA) is configured as the default for RMAN back