[bbk4344]小布-OCP 042全真试题讲解
参考视频:小布-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 databasewith 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.
页:
[1]