网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which two events will cause a slave server to create a new relay log file?()
A.Execution of the FLUSH LOGS statement
B.Starting of the SQL thread
C.Reaching the slave_pendign _jobs_size_max limit
D.Execution of FULSH TABLES WITH READ LOCK
E.Starting of the I/O thread
参考答案
更多 “ Which two events will cause a slave server to create a new relay log file?() A.Execution of the FLUSH LOGS statementB.Starting of the SQL threadC.Reaching the slave_pendign _jobs_size_max limitD.Execution of FULSH TABLES WITH READ LOCKE.Starting of the I/O thread ” 相关考题
考题
YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT=$ORACLE_SID_%s_%t.%tDB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD？（）A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST
考题
Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()
A.log_file_name_convertB.convert_log_file_nameC.file_name_convert_logD.redo_log_file_name_convertE.logfile_convert_directory
考题
Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?()
A.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB1’）；B.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB_LOG’）；C.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB1’）；D.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB_LOG’）；
考题
To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()
A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME
考题
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()
A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n
考题
YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；
考题
When backing up a replication slave, which three should also be backed up in addition to data?()
A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table
考题
What command would an operator use to move a file from the ／old_dir directory to the ／new_dir directory without changing the file name?()
A. mv /old_dir/file /new_dirB. mv -p /old_dir/file /new_dirC. mv -k /old_dir/file /new_dirD. mv /old_dir/file /new_dir/new_file
考题
Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D
考题
YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE"dat_tbs.dbf"SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe/u01/oradata/oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?（）A.DB_CREATE_FILE_DESTB.DB_CREATE_ONLINE_LOG_1C.DB_CREATE_ONLINE_LOG_2D.Thedirectoryisanoperatingsystem-specificdefaultvalueinOraclethatcanneigherbespecifiedmanuallynorchanged
热门标签
最新试卷