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

题目
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

相似考题

1.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"DB_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

2.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’）；

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

4.Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()A.log_file_name_convertB.convert_log_file_nameC.file_name_convert_logD.redo_log_file_name_convertE.logfile_convert_directory

参考答案和解析
参考答案：A, E
更多“Which two events will cause a slave server to create a new relay log file?() ”相关问题

  • 第1题：

    Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()

    A.DB_CREATE_FILE_DEST

    B.DB_RECOVERY_FILE_DEST

    C.DB_RECOVERY_FILE_DEST_SIZE

    D.DB_ONLINE_LOG_DEST_n


    参考答案：B, C

  • 第2题：

    When backing up a replication slave, which three should also be backed up in addition to data?()

    A.The master.info and relay.info files

    B.The relay log files

    C.The relay index file

    D.Mysql.slave_master_info table

    E.Mysql.slave_relay_log_info table

    F.Mysql.slave_worker_info table


    参考答案：A, B, C

  • 第3题：

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

    B.B

    C.C

    D.D


    参考答案：D

  • 第4题：

    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’；


    参考答案：B

  • 第5题：

    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_dir

    B. mv -p /old_dir/file /new_dir

    C. mv -k /old_dir/file /new_dir

    D. mv /old_dir/file /new_dir/new_file


    参考答案：A

  • 第6题：

    YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE"dat_tbs.dbf"SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe/u01/oradata/oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?（）

    A.DB_CREATE_FILE_DEST

    B.DB_CREATE_ONLINE_LOG_1

    C.DB_CREATE_ONLINE_LOG_2

    D.Thedirectoryisanoperatingsystem-specificdefaultvalueinOraclethatcanneigherbespecifiedmanuallynorchanged


    参考答案：A

相关内容