[bbk4344]小布-OCP 042全真试题讲解

　　参考视频:
　　[bbk4343]小布-OCP 042全真试题讲解
　　什么叫commit？
　　commit就是oracle server process将redo log buffer中的数据，写到redo log file中.

• 1、Which naming method uses the tnsnames.ora file to store connect descriptor used by the client while connecting to the database instance from a remote machine?
  
  
  
  • A.host naming method
    
  • B.local naming method
    
  • C.external naming method
    
  • D.directory naming method
    
  
  
• 2、In which situation would you use the Oracle Shared Server configuration?
  
  
  
  • A.When performing export and import using Oracle Data Pump.
    
  • B.When performing backup and recovery operations using Oracle Recovery Manager
    
  • C.When performing batch processing and bulk loading operation in a data warehouse enviroment.
    
  • D.in an online transaction processing(OLTP) system where large number of client sessions are idle most of the time.
    
  
  
• 3、In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open.
  

　　which two statemnets are true in this scenario?(choose two)

• 
  
  
  
  • A.Event Viewer gives more details on the failure.
    
  • B.The alert log file gives detailed information about the failure.
    
  • C.PMON rolls back the transaction and releases the locks.
    
  • D.SMON rolls back the transaction and releases the locks.
    
  • E.The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.
    
  • F.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
    
  
  
• 4、You are working on the 24*7 database  with high transaction volume,to ensure faster instance recovery on your database,you set the FAST_START_MTTR_TARGET initialization parameter to a very low value.
  

　　What effect it will on the database?

• 
  
  
  
  • A.The database performace would be enhanced.
    
  • B.The redo log files would be get filled more frequently.
    
  • C.The overall database performance would be degraded.
    
  • D.The mean time to recover(MTTR) would be increased.
    
  
  
• 5、What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?
  
  
  
  • A.MTTR Advisor would be disabled.
    
  • B.Redo Log Advisor would be disabled.
    
  • C.Automatic tuning of checkpoint would be disabled.
    
  • D.Checkpoint information would not be written to the alert log file.
    
  
  
• 6、Because of a power outage,instance failure has occurred.From what point in the redo log does recovery begin and where does it end?
  
  
  
  • A.current redo log and inactive redo log
    
  • B.checkpoint position to end of redo log
    
  • C.begining of redo log to end of redo log
    
  • D.all redo logs before the point of last commit
    
  • E.begining of redo log to checkpoint postion
    
  
  

• 7、You want to protect your database from single point of failure by multiplexing the control file.Your database is started using SPFILE.You have to perform the following tasks:
  
  
  
  • 1.shutdown the database instance.
    
  • 2.copy the control file to new location.
    
  • 3.Configure the CONTROL_FILES parameter
    
  • 4.Restart the instance
    
  
  

　　Select the correct order in which these tasks need to be performed.
　　A.1,2,3,4
　　B.3,2,1,4
　　C.3,1,2,4
　　D.2,3,1,4

• 8、Your database is having two control files,three redo log file groups with two members in each group.Failure of which file would cause an instance to shutdown?
  
  
  
  • A.any control file
    
  • B.any archive log file
    
  • C.one of the redo log members
    
  • D.loss of the initialization parameters file
    
  • E.any data file belonging to the default permanent tablespace.
    
  
  

　　multiplexed redo log files主要目的是为了避免单点故障，与归档模式无关.

• 9、Which two statements are true regarding the database in ARCHIVELOG mode?(choose two)
  
  
  
  • A.You have to shut down the database before perform the backups.
    
  • B.Archiving information is written to the data files and redo log files.
    
  • C.You can perform complete database backups without closing the database.
    
  • D.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
    
  • E.All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.