[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.