A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
您可能感兴趣的试卷
你可能感兴趣的试题
A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation（）
A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction.
Given below is a list of scenarios：
1）A user terminates his session abnormally.
2）The connection between the server and the client application terminates because of a network failure.
3）A schema is accidentally dropped.
4）The tablespace is accidentally dropped from the database.
5）The hard disk gets corrupted and the data files in the disk are lost.
6）The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery（）
A.4 and 5
B.1，3，and 6
C.4，5，and 6
D.3，4，and 5
E.1，2，and 6
A.The alert log file is corrupted.
B.A tablespace is accidentally dropped.
C.One of the redo log members is corrupted.
D.A database user terminates the session abnormally.
E.The hard disk on which the data file is stored is corrupted.
View the Exhibit and examine the parameters.
User A executes the following command to update the TRANS table： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；
Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table：
SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；
What would happen in this scenario（）
A.The ALTER TABLE command modifies the column successfully.
B.The DDL operation gets higher priority and transaction for user a is rolled back.
C.The ALTER TABLE command waits indefinitely until user a ends the transaction.
D.The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？ （）
A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache.
View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings，respectively.
Why are advisors not available for the shared pool and the buffer cache()
A.because the DB_CACHE_ADVICE parameter is set to OFF
B.because Automatic Memory Management （AMM） is disabled for the database instance
C.because Automatic Shared Memory Management （ASMM） is enabled for the database instance
D.because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not setinitially
View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities：
SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0；
What do you infer from this（）
A.The database instance is running with manual PGA management.
B.The database instance is running with manual shared memory management.
C.The database instance has the MEMORY_TARGET value set to a nonzero value.
D.All sessions are connected to the database instance in dedicated mode， and no RMAN or parallelquery operations have been performed.
Automatic Shared Memory Management （ASMM） has been enabled for your database instance.
Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；
Which statement is true in this scenario（）
A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
View the Exhibits and examine lock waits.
Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）
A.Kill the session of the user SCOTT with session ID118.
B.Issue manual checkpoint using the ALTER SYSTEM command.
C.Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
D.Flush the Shared Pool to remove the SQL statement causing "wait" in memory.
最新试题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
In a new installation of Oracle Database 11g， you perform these activities：1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）
Which statements are true regarding listeners（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command：SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable：ERROR at line 1：ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；Which statements describe the effect of the command（）