2024年计算机考试-Oracle认证考试近5年真题集锦（频考类试题）带答案

（图片大小可自由调整）2024年计算机考试-Oracle认证考试近5年真题集锦（频考类试题）带答案第I卷一.参考题库(共100题)1.You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）A、 The member jobs would get dropped when the job class is dropped.B、 Both the jobs would be executed concurrently.C、 The member jobs would get disabled when the job class is dropped.D、 The attributes defined at the class level would be applied to both the jobs.E、 Jobs in the job class must have been assigned the same priority.2.Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）A、It readily responds to dynamic changes for concurrent access. B、It improves performance and space utilization in a multiple-instance environment. C、It requires fewer space related options then freelist managed structures. D、It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.3.假定某非本机数据库的全局数据库名为ORCL.COM，数据库实例的SID为ORCL，定义的这个数据库的连接串为ORCLDB，数据库的用户名为scott，口令为tiger.那么以下哪个命令可以登录这个数据库（）A、sqlplusscott/tigerB、sqlplusscott/tiger@ORCL.COMC、sqlplusscott/tiger@ORCLD、sqlplusscott/tiger@ORCLDBE、以上所述都不正确4.Which two statements are true regarding hot patching？（）A、 It requires relinking of the Oracle binary.B、 It does not require database instance shutdown.C、 It can detect conflicts between two online patches.D、 It is available for installing all patches on all platforms. E、 It works only in a single database instance environment.5.What view might you use to try to determine how long a particular backup will take?（）A、V$SESSION_EVENT B、V$SESSION C、V$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS 6.You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.7.ExaminethedescriptionoftheEMPLOYEEStable: Whichstatementshowsthemaximumsalarypaidineachjobcategoryofeachdepartment?（）A、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

WHEREsalary>MAX(salary);B、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id,job_cat;C、SELECTdept_id,job_cat,MAX(salary)

FROMemployees;D、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id;E、SELECTdept_id,job_cat,MAX(salary)

FROMemployees

GROUPBYdept_id,job_cat,salary;8.You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）A、Oracle Management AgentB、Enterprise Manager with Grid ControlC、Enterprise Manager with Database ControlD、Operating System Socket for incoming requestsE、Real Application Cluster （RAC） with three instancesF、Enterprise Manager with Generic Database Management9.在登录到OracleEnterpriseManager时，要求验证用户的身份。下面不属于可以选择的身份是（）。A、NormalB、SYSOPERC、SYSDBAD、Administrator10.WhatistrueofusinggroupfunctionsoncolumnsthatcontainNULLvalues?（）A、GroupfunctionsoncolumnsignoreNULLvalues.B、GroupfunctionsoncolumnsreturningdatesincludeNULLvalues.C、GroupfunctionsoncolumnsreturningnumbersincludeNULLvalues.D、GroupfunctionsoncolumnscannotbeaccuratelyusedoncolumnsthatcontainNULLvalues.E、GroupfunctionsoncolumnsincludeNULLvaluesincalculationsifyouusethekeywordINC_NULLS.11.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER；   Which two statements are true regarding the tasks accomplished with these commands？（）A、 They import all metadata from the RCAT10 catalog.B、 They unregister the database from the RCAT10 catalog.C、 They do not register the databases registered in the RCAT10 catalog.D、 They register all databases registered in the RCAT10 catalog.12.DESCstudent的作用是什么？13.WhichareDMLstatements?（）A、COMMITB、MERGEC、UPDATED、DELETEE、CREATEF、DROP...14.Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table.  Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）A、Grand privileges on the interim table.B、Invoke the dbms_redefinition.can_redef_table procedure.C、Invoke the dbms_redefinition.sync_interim_table procedure.D、Create any triggers， indexes， or constraints on the interim table.E、Create an empty interim table with all the desired characteristics.15.The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic16.ExaminethestructureoftheEMPLOYEESandNEW_EMPLOYEEStables:EMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE NEWEMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey NAMEVARCHAR2(60) WhichDELETEstatementisvalid?（）A、DELETEFROMemployeesWHEREemployee_id=(SELECTemployee_idFROMemployees);B、DELETE*FROMemployeesWHEREemployee_id=(SELECTemployee_idFROMnew_employees);C、DELETEFROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHEREname=('Carrey')'D、DELETE*FROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHERElast_name=('Carrey')'17.下列哪一个操作可以用来为一个备份操作手动分配通道？（）A、ALLOCATECHANNELB、CREATECHANNELC、CHANNELALLOCATED、CREATELINK18.To save time configuring some custom network facilities， a junior administrator in your company  attempts to copy some entries from the /etc/inetd.conf file on a Solaris 8 OS server into the /etc/inetd.conf on a Solaris 10 OS server. The junior administrator is unable to determine why services do not start.  Which two commands can you run on the Solaris 10 OS server to start the services？（）A、 inetconv -fB、 inetcfg -i /etc/inetd.confC、 inetcfg -o /etc/inetd.confD、 inetconv -f -i /etc/inetd.confE、 inetconv -forceimport -o /etc/inetd.conf19.These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null？              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？ （）A、 BEGIN_TIME is the time at which Flashback logging is enabled.B、 END_TIME is the time at which the query is executed on the view.C、 REDO_DATA is the number of bytes of redo data written during the interval.D、 This view contains information about flashback data pertaining to the last 24 hours.E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.20.TheEMPLOYEEtableshasthesecolumns: LAST_NAMEVARCHAR2(35) SALARYNUMBER(8,2) COMMISSION_PCTNUMBER(5,2) Youwanttodisplaythenameandannualsalarymultipliedbythecommission_pctforallemployees.ForrecordsthathaveaNULLcommission_pct,azeromustbedisplayedagainstthecalculatedcolumn. WhichSQLstatementdisplaysthedesiredresults?（）A、SELECTlast_name,(salary*12)*commission_pctFROMEMPLOYEES;B、SELECTlast_name,(salary*12)*IFNULL(commission_pct,0)FROMEMPLOYEES;C、SELECTlast_name,(salary*12)*NVL2(commission_pct,0)FROMEMPLOYEES;D、SELECTlast_name,(salary*12)*NVL(commission_pct,0)FROMEMPLOYEES;21.Given： What creates the appropriate DateFormat object and adds a day to the Date object？（）A、35. DateFormat df = DateFormat.getDateFormat（）；42. d.setTime（ （60 * 60 * 24） + d.getTime（））；B、35. DateFormat df = DateFormat.getDateInstance（）；42. d.setTime（ （1000 * 60 * 60 * 24） + d.getTime（））；C、35. DateFormat df = DateFormat.getDateFormat（）；42. d.setLocalTime（ （1000*60*60*24） + d.getLocalTime（））；D、35. DateFormat df = DateFormat.getDateInstance（）；42. d.setLocalTime（ （60 * 60 * 24） + d.getLocalTime（））；22.You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?（）A、RUN_PRODUCT B、SET_REPORT_OBJECT_PROPERTY C、RUN_REPORT_OBJECT D、FIND_REPORT_OBJECT E、REPORT_OBJECT_STATUS F、COPY_REPORT_OBJECT_OUTPUT23.What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?（）A、Channel failoverB、Restartable backups C、Rescheduable backups D、Automatic backup recovery E、Channel recovery24.Whichtwostatementscompleteatransaction?（）A、DELETEemployees;B、DESCRIBEemployees;C、ROLLBACKTOSAVEPOINTC;D、GRANTSELECTONemployeesTOSCOTT;E、ALTERTABLEemployees

SETUNUSEDCOLUMNsal;F、SelectMAX(sal)

FROMemployees

WHEREdepartment_id=20;25.YouareconnectedusingSQL*Plustoamultitenantcontainerdatabase(CDB)withSYSDBAprivilegesandexecutethefollowingsequencestatements:WhatistheresultofthelastSETCONTAINERstatementandwhyisitso?（）A、ItsucceedsbecausethePDB_ADMINuserhastherequiredprivileges.B、ItfailsbecausecommonusersareunabletousetheSETCONTAINERstatement.C、ItfailsbecauselocalusersareunabletousetheSETCONTAINERstatement.D、IffailsbecausetheSETCONTAINERstatementcannotbeusedwithPDB$SEEDasthetargetpluggabledatabase(PDB).26.用于在启动实例时配置数据库，确定Oracle11g的运行环境文件是（）。A、参数文件B、数据文件C、可执行文件D、控制文件27.You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）A、DATEB、TIMESTAMPC、INTERVAL YEAR TO MONTHD、INTERVAL DAY TO SECONDE、TIMESTAMP WITH LOCAL TIME ZONE28.ClicktheExhibitbuttontoexaminethestructuresoftheEMPLOYEES,DEPARTMENTS,andTAXtables. Forwhichsituationwouldyouuseanonequijoinquery?（）A、tofindthetaxpercentageforeachoftheemployeesB、tolistthename,job_id,andmanagernameforalltheemployeesC、tofindthename,salary,andthedepartmentnameofemployeeswhoarenotworkingwithSmithD、tofindthenumberofemployeesworkingfortheAdministrativedepartmentandearninglessthan4000E、todisplayname,salary,managerID,anddepartmentnameofalltheemployees,eveniftheemployeesdonothaveadepartmentIDassigned29.Which two statements are true about mouse button variables?（）A、SYSTEM.MOUSE_BUTTON_PRESSED returns a string. B、SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders InCertifications Material - T C、A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete. D、SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers. E、SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action. 30.In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）A、the alert log fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files31.You work as a database administrator for S. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager （RMAN） to roll backF、Uses the System Monitor （SMON） background process to perform instance recovery32.WhichthreeareDATETIMEdatatypesthatcanbeusedwhenspecifyingcolumndefinitions?（）A、TIMESTAMPB、INTERVALMONTHTODAYC、INTERVALDAYTOSECONDD、INTERVALYEARTOMONTHE、TIMESTAMPWITHDATABASETIMEZONE33.WhichfouractionsarepossibleduringanOnlineDatafileMoveoperation?（）A、CreatinganddroppingtablesinthedatafilebeingmovedB、PerformingfileshrinkofthedatafilebeingmovedC、QueryingtablesinthedatafilebeingmovedD、PerformingBlockMediaRecoveryforadatablockinthedatafilebeingmovedE、FlashingbackthedatabaseF、ExecutingDMLstatementsonobjectsstoredinthedatafilebeingmoved34.Whichthreearetrueregardingtheuseofouterjoins?（）A、YoucannotuseINoperatorinaconditionthatinvolvesanouterjoin.B、Youuse(+)onbothsidesoftheWHEREconditiontoperformanouterjoin.C、Youuse(*)onbothsidesoftheWHEREconditiontoperformanouterjoin.D、Youuseanouterjointoseeonlytherowsthatdonotmeetthejoincondition.E、IntheWHEREcondition,youuse(+)followingthenameofthecolumninthetablewithoutmatchingrows,toperformanouterjoin.F、YoucannotlinkaconditionthatisinvolvedinanouterjointoanotherconditionbyusingtheORoperator.35.Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES  While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.  Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、drop and re­create the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and re­create the ORDERS tableE、rebuild the index online and move it to another tablespace36.You received these error messages because the client cannot find the desired database：   ORA-12198： TNS：could not path to destination  ORA-12203： TNS：unable to connect to destination  Which action would be appropriate in helping to resolve the errors？（）A、AB、BC、C37.Which dynamic view displays the status of block-change tracking?（）A、V$BLOCK_CHANGE B、V$BLOCK_CHANGE_TRACKING C、V$BLOCKCHANGE D、V$BLOCK_TRACKING38.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）A、An Automatic Workload Repository snapshot has been taken recently.B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.39.Yourdatabaseinstanceisrunning.YouarenotabletoaccessOracleEnterpriseManagerDatabaseControlbecausethelistenerisnotstarted.Whichtoolorutilitywouldyouusetostartthelistener?（）A、OracleNetManagerB、ListenerControlutilityC、DatabaseConfigurationAssistantD、OracleNetConfigurationAssistant40.WhichthreeactionsarerequiredtoconfiguretheFlashbackDatabase?（）A、setFlashRecoveryAreaB、enableFlashbackloggingC、createFLASHBACKtablespaceD、startthedatabaseintheARCHIVELOGmodeE、startthedatabaseintheNOARCHIVELOGmode41.Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database.   What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（） A、 datafileB、 alert logC、 dynamic viewsD、 control file script42.WhichofthefollowinginformationwillbegatheredbytheSQLTestCaseBuilderfortheproblemspertainingtoSQL-relatedproblems?（）A、ADRdiagnosticfilesB、alltheoptimizerstatisticsC、initializationparametersettingsD、PL/SQLfunctions,procedures,andpackagesE、thetableandindexdefinitionsandactualdata43.EvaluatetheSQLstatement: Whatistheresultofthestatement?（）A、Thestatementproducesanerroratline1.B、Thestatementproducesanerroratline3.C、Thestatementproducesanerroratline6.D、Thestatementreturnstheemployeename,salary,departmentID,andmaximumsalaryearnedinthedepartmentoftheemployeeforalldepartmentsthatpaylesssalarythenthemaximumsalarypaidinthecompany.E、Thestatementreturnstheemployeename,salary,departmentID,andmaximumsalaryearnedinthedepartmentoftheemployeeforallemployeeswhoearnlessthanthemaximumsalaryintheirdepartment.44.TheEMPtableexistsinyourschema.Youwanttoexecutethefollowingquery: SELECTename,sal FROMemp ASOFTIMESTAMP(SYSTIMESTAMP-INTERVAL'6'MINUTE) WHEREename='ALLEN'; Whataretheminimumrequirementsforthestatementtoexecutesuccessfully?（）A、ARCHIVELOGmodemustbeenabledB、RowMovementmustbeenabledforthetableC、FLASHBACKmustbesettoONforthedatabaseD、TheUNDO_MANAGEMENTparametermustbesettoAUTOE、TheUNDO_RETENTIONparametermustbesetappropriately45.You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）A、2，1，4，3，5，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，646.You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.47.Given: Whatistheresult?（）A、81B、82C、91D、92E、Compilationfails.F、Anexceptionisthrownatruntime.48.Whendefiningafunctionactivity,whatistrueabouttheResultType?（）(Choosetwo.)A、ResultTypeisoptional.B、ResultTypeismandatory.C、ResultTypecanbechangedafteritisassignedtothefunctionactivity.D、ResultTypeshouldbelongtothesameitemtypeasthefunctionactivity49.Which two operations can be flashed back using the Flashback technology？ （）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；50.Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE51.写出三种以上常用的数据类型。52.Examinethestatement: GRANTselect,insert,update ONstudent_grades TOmanager WITHGRANTOPTION; Whichtwoaretrue?（）A、MANAGERmustbearole.B、ItallowstheMANAGERtopassthespecifiedprivilegesontootherusers.C、ItallowstheMANAGERtocreatetablesthatrefertotheSTUDENT_GRADEStable.D、ItallowstheMANAGERtoapplyallDMLstatementsontheSTUDENT_GRADEStable.E、ItallowstheMANAGERtheabilitytoselectfrom,insertinto,andupdatetheSTUDENT_GRADEStable.F、ItallowstheMANAGERtheabilitytoselectfrom,deletefrom,andupdatetheSTUDENT_GRADEStable.53.Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）A、 functionsB、 packageC、 procedureD、 database triggerE、 anonymous PL/SQL block54.Whichsyntaxturnsanexistingconstrainton?（）A、ALTERTABLEtable_nameENABLEconstraint_name;B、ALTERTABLEtable_nameSTATUS=ENABLECONSTRAINTconstraint_name;C、ALTERTABLEtable_nameENABLECONSTRAINTconstraint_name;D、ALTERTABLEtable_nameTURNONCONSTRAINTconstraint_name;55.Whichtwostatementsaretrueaboutconstraints?（）A、TheUNIQUEconstraintdoesnotpermitanullvalueforthecolumn.B、AUNIQUEindexgetscreatedforcolumnswithPRIMARYKEYandUNIQUEconstraints.C、ThePRIMARYKEYandFOREIGNKEYconstraintscreateaUNIQUEindex.D、TheNOTNULLconstraintensuresthatnullvaluesarenotpermittedforthecolumn.56.比较非归档日志模式和归档日志模式的区别。57.You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.58.Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（） A、The backup will consist of used data blocks only.B、The database must be shut down to accomplish the backup.C、The backup can be accomplished without shutting down the database.D、The backup will contain all database files that have never been backed up59.触发器事件和语句是SQL语句、数据库事件、用户事件，导致触发器触发。触发器时机可以是（）。A、对特别表（视图）的INSERT、UPDATE、DELETE语句B、对特定模式对象的CREATE、ALTER和DROP语句C、数据库启动、实例关闭D、特定的错误消息和任何错误消息60.下列哪一个命令用来显示RMAN通道的配置信息？（）A、LISTB、DISPLAYC、SHOWD、都可以61.在Oracle中，下述（）命令会使挂起的事务完成。A、COMMITB、DELETEC、UPDATED、SELECTE、INSERT62.Which statement is true regarding the COALESCE function?（）A、It can have a maximum of five expressions in a list B、It returns the highest NOT NULL value in the list for all rows C、It requires that all expressions in the list must be of the same data type D、It requires that at least one of the expressions in the list must have a NOT NULL value63.Youhavealteredanon-uniqueindextobeinvisibletodetermineifqueriesexecutewithinanacceptableresponsetimewithoutusingthisindex. Whichtwoarepossibleiftableupdatesareperformedwhichaffecttheinvisibleindexcolumns?（）A、Theindexremainsinvisible.B、TheindexisnotupdatedbytheDMLstatementsontheindexedtable.C、TheindexautomaticallybecomesvisibleinordertohaveitupdatedbyDMLonthetable.