参考视频:
[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.