ocp 042答案解析

1、1. in your oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm在oracle 10g 10g的 database , you have scheduled a job to update the optimizer statistics at 05:00 pm數(shù)據(jù)庫(kù)，你安排了工作，更新統(tǒng)計(jì)信息，優(yōu)化器在下午05:00 every friday 。 the job has successfully completed 。 which three pie

2、ces of information would you check to 每個(gè)星期五 。every friday. the job has successfully completed這項(xiàng)工作已順利完成. which three pieces of information哪三個(gè)信息塊的， would you check toconfirm that the statistics have been collected? (choose three.)你會(huì)檢查 confirm that the statistics h ave been collected ? 確認(rèn)，統(tǒng)計(jì)等皆 被收集a. av

3、erage row size平均行大小b. last analyzed date最后分析日期c. size of table in bytes表的大小 ，以字節(jié)d. size of table in database blocks表中的數(shù)據(jù)庫(kù)塊大小e. number of free blocks in the free list塊數(shù)的免費(fèi)自由列表f. number of extents present in the table人數(shù)程度存在于表answer: abd一個(gè)工作一行日期老方塊2. you are in the middle of a transaction交易 and very cr

4、ucial重要 data has been modified. 您在交易過(guò)程中的一個(gè)，非常重要的數(shù)據(jù)已被修改 。 because of a hardwarefailure由于硬件 failure, the instance has shut down before synchronizing all the database files 。 失敗, the instance has shut down before synchronizing同步 all the database files. 該實(shí)例已關(guān)閉前同步所有數(shù)據(jù)庫(kù)文件 。which two statements are true? 哪

5、兩種說(shuō)法 是正確的 ？ (choose two.)a. on startup, smon coordinates instance recovery. 在啟動(dòng)時(shí)，坐標(biāo)的smon實(shí)例恢復(fù)b. on startup, ckpt coordinates instance recovery. 在啟動(dòng)時(shí)，珠江客運(yùn)坐標(biāo)實(shí)例恢復(fù)c. on startup, use rman to perform instance recovery. 在啟動(dòng)時(shí)，使用rman執(zhí)行實(shí)例恢復(fù)d. uncommitted changes will be rolled back after the database is opened

6、. 未提交的更改將回滾后打開(kāi)數(shù)據(jù)庫(kù)e. on startup, perform media recovery and then instance recovery. 在啟動(dòng)時(shí)，執(zhí)行介質(zhì)恢復(fù)，接著實(shí)例恢復(fù)f. on startup, all the files will be synchronized and you get both committed and uncommitted data. 在啟動(dòng)時(shí)，所有的文件將被同步，你會(huì)得到提交和未提交的數(shù)據(jù)answer: ad硬件失敗打開(kāi)再啟動(dòng)由于硬件損壞，數(shù)據(jù)庫(kù)意外掉電，這就意味著shutdown abort,當(dāng)重新啟動(dòng)后smon進(jìn)程會(huì)自動(dòng)回復(fù)實(shí)

7、例，uncommited的數(shù)據(jù)會(huì)自動(dòng)rollback同時(shí)， commited的數(shù)據(jù)而又未寫(xiě)到datafile中的會(huì)被寫(xiě)進(jìn)datafile中。3. you are using the backup scheduler in enterprise manager (em) to schedule a backup of your database. 您使用的是在企業(yè)管理器備份調(diào)度（em）的安排你的備份 database 。 數(shù)據(jù)庫(kù) 。which type of script does the backup scheduler generate? 哪種類(lèi)型的腳本是否備份調(diào)度 產(chǎn)生 ？a. sql s

8、cript sql腳本b. pl/sql script pl / sql的腳本c. operating system (os) script作業(yè)系統(tǒng)（os）腳本d. enterprise manager (em) script企業(yè)管理器（em）腳本e. recovery manager (rman) script恢復(fù)管理器（rman）腳本answer: eem備份用rman4. you executed the following command to export the employees table from a remote machine: 您執(zhí)行以下命令導(dǎo)出雇員表的遠(yuǎn)程計(jì)算機(jī)從一個(gè)

9、：$ expdp hr/hrdumpfile=my_dir:exp_hr.loglogfile=data_pump_dir:log_hr.logtables=employeeswhat would be the outcome of this command? 什么是這個(gè) 命令 的結(jié)果 ？a. the command would execute successfully and the export dump file would be created in the destination命令執(zhí)行成功，將導(dǎo)出轉(zhuǎn)儲(chǔ)文件將被創(chuàng)建在目標(biāo) of the directory object my_dir

10、。 of the directory object my_dir. 目錄的對(duì)象my_dir。b. the command would execute successfully. but log file would not be created as data_pump_dir命令將成功執(zhí)行 。 但日志文件將不會(huì)被創(chuàng)建為data_pump_dirdirectory is only accessible to user with sysdba privilege. 目錄訪問(wèn)權(quán)限的用戶只擁有sysdba。c. the command fails with an error because data

11、_pump_dir directory have higher precedence over命令失敗的優(yōu)先級(jí)高，上面有一個(gè)目錄有錯(cuò)誤，因?yàn)閐ata_pump_dirthe perfile在 perfiledirectory. 目錄 。d. the command fails with an error because no absolute path is specified for log file and dumpfile. 命令失敗文件并轉(zhuǎn)存同一個(gè)錯(cuò)誤，因?yàn)闆](méi)有日志絕對(duì)路徑指定 。answer: a使用導(dǎo)出命令是最大的成功5. which step do you need to per

12、form to enable a user with the sysdba privilege to log in as sysdba in sql*plus?哪一步，你需要執(zhí)行，以使在sysdba權(quán)限登錄用戶以sysdba 與 iisql * plus中a. the user must be granted the database administrator (dba) privilege. 用戶必須被授予數(shù)據(jù)庫(kù)管理員（dba）的特權(quán)b. the user must be listed in the password file for the authentication. 用戶必須被列在

13、認(rèn)證密碼文件 。c. no special setup is needed for the user to connect as sysdba in isql*plus. 沒(méi)有特殊的設(shè)置，需要為用戶sysdba的身份連接在 isql * plus中 。d. set up a user in the oracle application server containers for j2ee (oc4j) user manager, and grant the webdba role to the user.設(shè)置一個(gè)管理器用戶在oracle應(yīng)用服務(wù)器的j2ee容器（oc4j）中的用戶，并授予web

14、dba角色給用戶 。the webdba role to the user 。answer: disql * plus 須用webdba。6. which two statements regarding the logging記錄 clause子句 of the create tablespace. . 哪兩個(gè)說(shuō)法關(guān)于在建表空間日志子句的規(guī)定 。 statement are correct? 說(shuō)法是正確的？ (choose two.)a. this clause is not valid for a temporary or undo tablespace. 這一語(yǔ)句不是有效期對(duì)于臨時(shí)的或撤

15、消表空間b. if the tablespace is in the nologging mode, no operation on the tablespace will generate redo. c. the tablespace will be in the nologging mode by default, if not specified while creating a tablespace. d. the tablespace levellogging attribute can be overridden by logging specifications at the

16、table, index, 該tablespacelevel日志屬性可以覆蓋指數(shù)表，通過(guò)記錄在規(guī)格，materialized view, materialized view log, and partition levels. 實(shí)例視圖，實(shí)例視圖日志和分區(qū)的水平 。answer: adlogging clause這個(gè)子句聲明這個(gè)表空間上所有的用戶對(duì)象的日志屬性（缺省是logging），包括表，索引，分區(qū)，物化視圖，物化視圖上的索引，分區(qū)。 force logging使用這個(gè)子句指出表空間進(jìn)入強(qiáng)制日志模式。此時(shí)，系統(tǒng)將記錄表空間上對(duì)象的所有改變，除了臨時(shí)段的改變。這個(gè)參數(shù)高于對(duì)象的nologgi

17、ng選項(xiàng)。注意：設(shè)置這個(gè)參數(shù)數(shù)據(jù)庫(kù)不行open并且出于讀寫(xiě)模式。而且，在臨時(shí)表空間和回滾表空間中不能使用這個(gè)選項(xiàng)。7. which two statements are true about the primary key constraint in a table? (choose two.) 哪兩個(gè)說(shuō)法是正確的有關(guān) 表格 中的主鍵約束a. it is not possible to disable the primary key constraint. b. it is possible to have more than one primary key constraint in a s

18、ingle table.。c. the primary key constraint can be referred by only one foreign key constraint. 主d. the primary key constraint can be imposed by combining more than one column. 主鍵約束相結(jié)合，可處以超過(guò)一列 。e. the nondeferrable primary key constraint creates an unique index on the primary key column if it is not

19、already indexed. 該nondeferrable主鍵約束創(chuàng)建一個(gè)主鍵列的唯一索引，如果它不 already indexed 。 已經(jīng)編入索引 。answer: de當(dāng)定義主鍵約束時(shí)，默認(rèn)情況下oracle會(huì)自動(dòng)基于唯一約束建立唯一索引，并且索引名與約束名完全一致，一張表只能有一個(gè)主鍵約束。 一個(gè)主鍵約束可以由多個(gè)列組成。8. you want the user app_dba to administer the oracle database from a remote machine. 您希望用戶app_dba來(lái)管理遠(yuǎn)程計(jì)算機(jī)oracle數(shù)據(jù)庫(kù)的。app_dba is gran

20、ted the sysdba privilege to perform administrative tasks on the database. app_dba是 granted the sysdba privilege to perform administrative tasks on the database 。授予sysdba權(quán)限才能執(zhí)行數(shù)據(jù)庫(kù)管理任務(wù)上 。which file is used by the oracle database server to authenticate app_dba? 哪個(gè)文件是使用oracle數(shù)據(jù)庫(kù)服務(wù)器來(lái)驗(yàn)證app_dba？a. control

21、file控制文件b. password file密碼文件c. listener controller file監(jiān)聽(tīng)器控制器文件d. control file and password file控制文件和密碼文件answer: b驗(yàn)證權(quán)限password在這里的os認(rèn)證和口令文件認(rèn)證都是針對(duì)特權(quán)用戶來(lái)說(shuō)的 a、其中文件sqlnet.ora是來(lái)選定是否支持os認(rèn)證和口令文件認(rèn)證的，修改為all就是都支持修改為none只支持口令文件認(rèn)證。 b、文件remote_login_passwordfile是用來(lái)管特權(quán)用戶是否可以遠(yuǎn)程登錄。 c、orapwora10g該文件應(yīng)該是遠(yuǎn)程特權(quán)用戶登陸時(shí)需要使用的密

22、碼文件。9. which three statements are true regarding the logical structure邏輯結(jié)構(gòu) of the oracle database? 哪三個(gè)方面的陳述是真實(shí)的oracle數(shù)據(jù)庫(kù)的邏輯結(jié)構(gòu)？ (choosethree.)a. each segment contains one or more extents. 每個(gè)段包含一個(gè)或多個(gè)擴(kuò)展 。b. multiple tablespaces can share single data file. 多個(gè)表空間可以共享數(shù)據(jù)文件的單c. a data block is the smallest

23、unit of i/o for data files. 一個(gè)數(shù)據(jù)塊是最小單位的i / o的數(shù)據(jù)文件d. it is possible to have tablespaces of different block sizes in a database. 這是可能的數(shù)據(jù)庫(kù)塊大小不同的表空間中e. each data block in the database always corresponds to one os block. 每次總是在數(shù)據(jù)庫(kù)中的數(shù)據(jù)塊對(duì)應(yīng)一個(gè)os塊 。answer: acd邏輯結(jié)構(gòu)可大可小可擴(kuò)展oracle的邏輯結(jié)構(gòu)10. which is the memory area

24、that is created when a dedicated server process is started, and contains data and control information for that server process? 哪一個(gè)是內(nèi)存區(qū)域時(shí)創(chuàng)建一個(gè)專用服務(wù)器進(jìn)程已啟動(dòng)，并包含 data and control information for that server process? 數(shù)據(jù)和控制信息，該服務(wù)器進(jìn)程？a. sgab. pgac. shared pool d. streams pooanswer: bpga-獨(dú)立服務(wù)進(jìn)程啟動(dòng)時(shí)，里面包括這個(gè)進(jìn)程的數(shù)據(jù)和

25、控制信息在oracle9i中，只需要調(diào)整 pga_aggregate_target。11. you find that the database performance degrades while you backup the prod database using recovery manager (rman). 您會(huì)發(fā)現(xiàn)數(shù)據(jù)庫(kù)的性能下降，而你的數(shù)據(jù)庫(kù)使用備份督促 recovery manager (rman) 。 the prod database is running in shared server mode 。 the database 恢復(fù)管理器（rman）。 the prod

26、database is running in shared server mode. 數(shù)據(jù)庫(kù)的督促在共享服務(wù)器模式下運(yùn)行。the database instance is currently using 60% of total operating system memory. you suspect the shared pool fragmentation to be the reason. 例如目前使用的系統(tǒng)內(nèi)存60的總經(jīng)營(yíng) 。 您懷疑共享池 fragmentation to be the reason 。 碎片是原因 。which action would you consider t

27、o overcome the performance degradation? 你會(huì)考慮哪些行動(dòng)來(lái)克服的性能退化？a. configure java pool to cache the java objects. b. configure streams pool to enable parallel processing. c. increase shared pool size to cache more pl/sql objects. d. increase database buffer cache size to increase cache hits. e. configure l

28、arge pool to be used by rman and shared server. 配置大水池要使用rman和共享服務(wù)器 。f. increase the total system global area (sga) size to increase memory hits. 增answer: e發(fā)現(xiàn)rman就rmanrman備份需配池使用rman備份數(shù)據(jù)庫(kù)時(shí)，由于在共享服務(wù)器模式下，共享池已經(jīng)不夠用了，所以使用大池以供ramn和共享服務(wù)使用。12. you execute the following command to audit the database activities

29、: 您執(zhí)行以下命令，以審計(jì)數(shù)據(jù)庫(kù)的活動(dòng)：sql audit drop any table by scott by session whenever successfulwhat is the effect of this command? 什么是命令的影響呢？a. one audit record is created for the whole session if user scott successfully drops one or more tables in his session. 一個(gè)審計(jì)記錄創(chuàng)造了整個(gè)會(huì)議，如果用戶scott成功滴一個(gè)或多個(gè)表 in his session 。

30、 在他的會(huì)議 。 b. one audit record is created for every session when any user successfully drops a table owned by. c. one audit record is created for each successful drop table command executed by any user to drop tables owned by scott.d. one audit record is generated for the session when scott grants the

31、 drop any table privilege toother users in his session. e. one audit record is created for each successful drop table command executed in the session of scott.answer: a如果用戶scott成功的drop掉一個(gè)或多個(gè)表在他的會(huì)話中，一條審計(jì)信息將被在所有會(huì)話中創(chuàng)建。13. the save_amt column in the accounts table contains the balance details of custome

32、rs in a bank. 帳戶表中的列包含save_amt細(xì)節(jié)銀行客戶的平衡研究 。as part of the yearend由于年底部分tax and interest calculation process, all the rows in the table need to be accessed. 及利息計(jì)算過(guò)程中，所有的表行中需要進(jìn)行訪問(wèn) 。the bank authorities want to track access to the rows containing balance amounts exceeding $200,000, 銀行部門(mén)要跟蹤訪問(wèn)的行包含余額為超過(guò)20

33、萬(wàn)美元，and then send an alert message to the administrator. 然后發(fā)送警報(bào)消息給管理員 。which method would you suggest to the bank for achieving this task? 哪種方法，你會(huì)向銀行提出實(shí)現(xiàn)這一任務(wù)呢？a. implementing valuebased auditing by using triggers b. implementing finegrained 實(shí)施 finegrainedauditing with audit condition and event handl

34、er auditing with audit condition and event handler 審計(jì)與審計(jì)情況和事件處理程序 c. performing standard database auditing to audit object privileges by setting the audit_trail parameter to extendedd. performing standard database auditing to audit sql statements with granularity level set to accessanswer: b20萬(wàn)獎(jiǎng)金需用手

35、fga精細(xì)審計(jì)，精確到行列的審計(jì)就要使用精細(xì)審計(jì)。14. which three statements are true regarding the finegrained哪三個(gè)方面的陳述是真實(shí)finegrainedauditing (fga)? 審計(jì) （fga的）？(choose three.)a. fga is possible on select statements only. b. the audit trail for fga is stored in the fga_log$ table. fga審計(jì)線索對(duì)于存儲(chǔ)在fga_log $表 。c. the audit trail fo

36、r fga is stored in the aud_log$ table. d. fga enables a sql predicate to define when to audit an event. fga的實(shí)現(xiàn)了sql謂詞來(lái)定義事件時(shí)審核 。e. fga audits delete statements only when audit columns are specified.f. fga includes the sql statement used by the user as part of the audit event entry. fga的包括sql語(yǔ)句的用戶使用，作為

37、項(xiàng)目的一部分，審計(jì)事件 。answer: bdffga fga sqlfga的審計(jì)信息，存放在fga_log$中15. you plan to use static database registration for a new listener when you create it. what could be the two reasons for this?您計(jì)劃使用一個(gè)新的偵聽(tīng)靜態(tài)資料庫(kù)登記，因?yàn)楫?dāng)你創(chuàng)建它 。 可能是什么 two reasons for this? 兩個(gè)原因何在呢？ (choose two.)a. more than one database is to be reg

38、istered with the listener. b. the users will connect the database by using the host naming method. b. the users will connect the database by using the host naming method.c. the oracle enterprise manager is to be used to monitor an oracle9i database. oracle企業(yè)管理器是用來(lái)監(jiān)視oracle9i數(shù)據(jù)庫(kù) 。d. the database that

39、is to be registered with the listener is configured in shared server mode.e. the listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.偵聽(tīng)器上沒(méi)有配置默認(rèn)的1521端口和實(shí)例配置為不登記 with a nondefault port 。 一個(gè)非默認(rèn)端口 。 answer: ce什么是注冊(cè)？ 注冊(cè)就是將數(shù)據(jù)庫(kù)作為一個(gè)服務(wù)注

40、冊(cè)到監(jiān)聽(tīng)程序。 客戶端不需要知道數(shù)據(jù)庫(kù)名和實(shí)例名，只需要知道該數(shù)據(jù)庫(kù)對(duì)外提供的服務(wù)名就可以申請(qǐng)連接到數(shù)據(jù)庫(kù)。這個(gè)服務(wù)名可能與實(shí)例名一樣，也有可能不一樣。 靜態(tài)注冊(cè)： 靜態(tài)注冊(cè)就是實(shí)例啟動(dòng)時(shí)讀取listener.ora文件的配置，將實(shí)例和服務(wù)注冊(cè)到監(jiān)聽(tīng)程序。無(wú)論何時(shí)啟動(dòng)一個(gè)數(shù)據(jù)庫(kù)，默認(rèn)地都有兩條信息注冊(cè)到監(jiān)聽(tīng)器中：數(shù)據(jù)庫(kù)服務(wù)器對(duì)應(yīng)的實(shí)例和服務(wù)。 靜態(tài)注冊(cè)時(shí)，listener.ora中的global_dbname向外提供服務(wù)名，listener.ora中的sid_name提供注冊(cè)的實(shí)例名。 動(dòng)態(tài)注冊(cè) 動(dòng)態(tài)注冊(cè)是在instance啟動(dòng)的時(shí)候pmon進(jìn)程根據(jù)init.ora中的instance_nam

41、e,service_names兩個(gè)參數(shù)將實(shí)例和服務(wù)動(dòng)態(tài)注冊(cè)到listener中。16. which three pieces of information are to be mandatorily provided while creating a new listener using enterprise manager database control?哪三個(gè)信息塊的硬性規(guī)定要在創(chuàng)建一個(gè)新的監(jiān)聽(tīng)器使用企業(yè)管理器數(shù)據(jù)庫(kù)控制？enterprise manager database control? (choose three 。 ) (choose three.)a. the port us

42、ed by the listener監(jiān)聽(tīng)的端口使用b. the protocol used by the listener聽(tīng)者所使用的協(xié)議c. the server name where the listener runs服務(wù)器的名稱監(jiān)聽(tīng)器運(yùn)行d. the log file and trace file destination for the listenere. the database services to be registered with the listeneranswer: abc新監(jiān)聽(tīng)需要端口協(xié)議服務(wù)器當(dāng)創(chuàng)建一個(gè)監(jiān)聽(tīng)時(shí)需要提供協(xié)議、端口、服務(wù)名17. you have bee

43、n recently hired as a database administrator. your senior manager您在最近聘請(qǐng)作為數(shù)據(jù)庫(kù)管理員 。 你的高級(jí)經(jīng)理問(wèn)你學(xué)習(xí) asks you to study theproduction database server and submit a report on the settings done by the previous dba. 生產(chǎn)數(shù)據(jù)庫(kù)服務(wù)器，并提交報(bào)告上的dba通過(guò)設(shè)置完成 。while observing the server settings, you find that the following param

44、eter has been set in the parameter file of the database: 盡管觀察服務(wù)器設(shè)置，你會(huì)發(fā)現(xiàn)以下參數(shù)被設(shè)置在參數(shù)文件 the database: 數(shù)據(jù)庫(kù) ：remote_os_authent = truewhat could have been the reason to set this parameter as true? what could have been the reason to set this parameter as true? 可能是什么原因來(lái)設(shè)置此參數(shù)為true？ a. to enable operating syst

45、em authentication for a remote client使遠(yuǎn)程客戶端操作系統(tǒng)身份驗(yàn)證b. to restrict the scope of administration to identical operating systemsc. to allow the start up and shut down of the database from a remote clientd. to enable the administration of the operating system from a remote cliente. to disable the adminis

46、tration of the operating system from a remote clientanswer: aos=operating system初始化參數(shù)remote_os_authent用來(lái)控制是否允許遠(yuǎn)端操作系統(tǒng)驗(yàn)證，默認(rèn)情況下，數(shù)據(jù)庫(kù)只運(yùn)行本地服務(wù)器上的操作系統(tǒng)驗(yàn)證。18. which naming method uses the tnsnames. 哪個(gè)命名方法使用tnsname中 。ora file to store the connect descriptor used by the client奧拉文件來(lái)存儲(chǔ)連接描述符所使用的客戶端while connecting

47、 to the database instance from a remote machine? while connecting to the database instance from a remote machine? 而從遠(yuǎn)程計(jì)算機(jī)連接到數(shù)據(jù)庫(kù)實(shí)例？ a. host naming methodb. local naming method本地命名方法c. external naming methodd. directory naming methodanswer: b tnsnames.ora在oracle中,oraclenetworkadmintnsnames.ora 文件很重要,它

48、作用是： 本地命名的配置。 本地名可以用簡(jiǎn)單的名稱就可以訪問(wèn)到所需的數(shù)據(jù)庫(kù)或服務(wù)器所需的信息。19. your tnsnames.ora file has the following entry for the service alias orcl:orcl =( description =(address = (protocol = tcp)(host = 10.156.24.216)(port = 1521)(connect_data =(server = dedicated)(service_name = )the tnsping command executes successfull

49、y when tested with orcl but you are not able to connect to the database instance with the following command: the tnsping command executes successfully when tested with orcl but you are not able to connect 命令執(zhí)行成功的tnsping進(jìn)行測(cè)試時(shí)，與orcl的，但你無(wú)法連接下面的命令與數(shù)據(jù)庫(kù)實(shí)例：sql connect scott/tigerorclwhat could be the reaso

50、n for this? what could be the reason for this? 可能是什么原因呢？ a. the listener is not running at the server.b. the tns_admin environmental variable is set to a wrong value.c. the database service is not registered with the listener.沒(méi)有注冊(cè)到監(jiān)聽(tīng)器d. the default_domain parameter is set to a wrong value in the sql

51、net.ora file.answer: c當(dāng)service_name填寫(xiě)不正確時(shí)，你可以tnsping通數(shù)據(jù)庫(kù)實(shí)例，但是卻無(wú)法連接到數(shù)據(jù)庫(kù)實(shí)例，因?yàn)槟闾顚?xiě)錯(cuò)的service_name并沒(méi)有注冊(cè)到listener當(dāng)中20. your database is open and users are connected using the listener listener. the new dba of the system stops the listener by using the following command: 你的數(shù)據(jù)庫(kù)是開(kāi)放的，用戶連接使用監(jiān)聽(tīng)器監(jiān)聽(tīng)器 。 這個(gè)新的dba sys

52、tem stops the listener by using the following command: 系統(tǒng)停止監(jiān)聽(tīng)器通過(guò)以下命令使用：lsnrctl stopwhat would happen to the sessions that are presently connected to the database instance? 會(huì)發(fā)生什么樣的實(shí)例會(huì)話目前連接到數(shù)據(jù)庫(kù)？a. the sessions are able to perform only queries.b. the sessions are not affected and continue to function n

53、ormally. 會(huì)話不會(huì)受到影響，繼續(xù)正常運(yùn)行 。c. the active transactions are rolled back and the sessions get terminated.d. the sessions are not allowed to perform any operations till the listener is started.answer: b已連接的會(huì)話，當(dāng)停止監(jiān)聽(tīng)時(shí)不會(huì)中斷監(jiān)聽(tīng)器停止已連接會(huì)話不會(huì)受到影響。stop continue21. your database is started with spfile. you want the d

54、atabase instance to be dynamically registered你的數(shù)據(jù)庫(kù)啟動(dòng)與spfile文件 。 您希望數(shù)據(jù)庫(kù)實(shí)例，動(dòng)態(tài)注冊(cè)with a listener l2 with the following details: 與一二級(jí)以下細(xì)節(jié)與聽(tīng)眾：protocol: tcphost: indl151eport: 1525which is the correct order of the steps that you would follow to achieve this? 哪一個(gè)是正確的步驟順序，你會(huì)遵循實(shí)現(xiàn)這一目標(biāo)？1. set the local_listener

55、 parameter to l2 dynamically. local_listener參數(shù)設(shè)置到l2動(dòng)態(tài) 。2. make an entry for l2 in tnsnames.ora on the database server. 做一個(gè)l條目 2 in 2 tnsnames 。 ora on the database server 。 tnsname中 。 服務(wù)器邑上數(shù)據(jù)庫(kù) 。3. restart l2. 重新啟動(dòng)二級(jí) 。4. modify the listener.ora file to add the instance name in sid_list of l2. 修改監(jiān)聽(tīng)器 。

56、 奧拉文件，以添加二級(jí)實(shí)例sid_list名稱質(zhì)疑 。a. 1, 2, 4, 3b. 1, 2, 3 4 is not required.c. 2, 1 3 and 4 are not required.d. 1, 2 3 and 4 are not required.answer: c首先需要把參數(shù)local_listener改為dynamically，因?yàn)閯?dòng)態(tài)注冊(cè)pmon進(jìn)程從參數(shù)文件自動(dòng)注冊(cè)到listener.ora中。這是我們修要在tnsname.ora中添加相關(guān)的動(dòng)態(tài)注冊(cè)信息。22. your database is not configured for session failov

57、er控制轉(zhuǎn)移. your tnsnames.ora file contains the following details:您的數(shù)據(jù)庫(kù)未配置為故障恢復(fù) 。 您的tnsname中 。 奧拉文件包含以下 details : 詳細(xì)資料 ： =(description=(address_list=(load_balance=off)(failover=on)(address=(protocol=tcp)(host=test1server)(port=1521)(address=(protocol=tcp)(host=test2server)(port=1521)(connect_data=(service_name=)which feature is enabled in this case? 啟用的這個(gè)案子哪些特征？a. load balancingb. instance failoverc. database failoverd. connecttime failover 連接時(shí)間 控制轉(zhuǎn)移。e. tr