In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
相似题目
-
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