2024年计算机考试-Oracle认证考试近5年真题附答案

（图片大小可自由调整）2024年计算机考试-Oracle认证考试近5年真题荟萃附答案第I卷一.参考题库(共100题)1.Notethefollowingparameterssettingsinyourdatabase: Whatwouldhappen?（）A、ItwillfailbecauseDB_8K_CACHE_SIZEparametercannotbechangeddynamicallyB、ItwillbesuccessfulonlyifthememoryisavailablefromtheautotunedcomponentsC、ItwillfailbecauseanincreaseinDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_TARGETD、ItwillfailbecauseanincreaseintheDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_MAX_SIZE2.Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）A、serviceB、listenerC、dispatcherD、shared server process3.Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）4.ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE WhichINSERTstatementisvalid?（）A、INSERTINTOemployees(employee_id,first_name,last_name,hire_date)VALUES(1000,'John','smith','01/01/01);B、INSERTINTOemployees(employee_id,first_name,last_name,hire_date)VALUES(1000,'John','smith','01january01');C、INSERTINTOemployees(employee_id,first_name,last_name,Hire_date)VALUES(1000,'John','smith',To_date('01/01/01));D、INSERTINTOemployees(employee_id,first_name,last_name,hire_date)VALUES(1000,'John','smith','01-Jan-01');5.Which two statements about Flashback Query are true？（）A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.6.To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，AutomaticSQL Tuning AdvisorC、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQLAdvisors，Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above7.Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  A、 Create new indexes.B、 Modify existing indexes.C、 Implement partitioning on a nonpartitioned table.D、 Create materialized views.E、 All of the above8.You want to enforce a company’s business policy on several objects by using a singlepolicy function.  Which two types of policies can be assigned to the policy_type argument in thedbms_rls.add_policy procedure to achieve the above objective？（）A、DBMS_RLS.STATICB、DBMS_RLS.DYNAMICC、DBMS_RLS.SHARED_STATICD、DBMS_RLS.CONTEXT_SENSITIVEE、DBMS_RLS.SHARED_CONTEXT_SENSITIVE9.WhichSQLstatementreturnsanumericvalue?（）A、SELECTADD_MONTHS(MAX(hire_Date),6)FROMEMP;B、SELECTROUND(hire_date)FROMEMP;C、SELECTsysdate-hire_dateFROMEMP;D、SELECTTO_NUMBER(hire_date+7)FROMEMP;10.在iBatis框架中，（）关联不需要额外的表字段。A、主键关联B、惟一外键关联C、外键关联D、约束关联11.What command would you issue to enable automated backups of control files？（）  A、 alter database controlfile autobackup onB、 alter system controlfile autobackup onC、 configure controlfile autobackup onD、 enable controlfile autobackup12.You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected13.AseniorDBAaskedyoutoexecutethefollowingcommandtoimproveperformance: SQL>ALTERTABLEsubscribelogSTORAGE(BUFFER_POOLrecycle); YoucheckedthedataintheSUBSCRIBE_LOGtableandfoundthatitisalargetablecontainingonemillionrows. Whatcouldbeareasonforthisrecommendation?（）A、Thekeeppoolisnotconfigured.B、AutomaticWorkareaManagementisnotconfigured.C、AutomaticSharedMemoryManagementisnotenabled.D、ThedatablocksintheSUBSCRIBE_LOGtablearerarelyaccessed.E、AllthequeriesontheSUBSCRIBE_LOGtablearerewrittentoamaterializedview14.WhichtwostatementsaretrueconcerningtheResourceManagerplansforindividualpluggabledatabases(PDBplans)inamultitenantcontainerdatabase(CDB)?（）A、IfnoPDBplanisenabledforapluggabledatabase,thenallsessionsforthatPDBaretreatedtoanequaldegreeoftheresourceshareofthatpdb.B、InaPDBplan,subplansmaybeusedwithuptoeightconsumergroups.C、IfaPDBplanisenabledforapluggabledatabase,thenresourcesareallocatedtoconsumergroupsacrossallPDBsinthecdb.D、IfnoPDBplanisenabledforapluggabledatabase,thenthePDBshareintheCDBplanisdynamicallycalculated.E、IfaPDBplanisenabledforapluggabledatabase,thenresourcesareallocatedtoconsumergroupsbasedonthesharesprovidedtothePDBintheCDBplanandthesharesprovidedtotheconsumergroupsinthePDBplan.15.Whichtwoaretrueaboutaggregatefunctions?（）A、YoucanuseaggregatefunctionsinanyclauseofaSELECTstatement.B、YoucanuseaggregatefunctionsonlyinthecolumnlistoftheSELECTclauseandintheWHEREclauseofaSELECTstatement.C、YoucanmixsinglerowcolumnswithaggregatefunctionsinthecolumnlistofaSELECTstatementbygroupingonthesinglerowcolumns.D、Youcanpasscolumnnames,expressions,constants,orfunctionsasparameterstoanaggregatefunction.E、Youcanuseaggregatefunctionsonatable,onlybygroupingthewholetableasonesinglegroup.F、Youcannotgrouptherowsofatablebymorethanonecolumnwhileusingaggregatefunctions.16.在Oracle中，（）程序包中提供了所有预定义的异常的定义。A、DBMS_STANDARDB、DBMS_STDC、DBMS_SQLD、DBMS_TYPES17.You work as a database administrator for Certkiller .com. After being hired， you find that there is only one database that is functional and that is being access by the applications. You want to create a replicate of the database， to be used for testing purposes.  What is the best method to create a replica？（）A、AB、BC、CD、D18.You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A、The database crashes.B、The DBA needs to re-create the file.C、The file gets re-created automatically.D、The file gets restored automatically from the last backup.E、The DBA needs to perform a complete database recovery.F、The DBA needs to perform an incomplete database recovery.19.ExaminethedetailsoftheTop5TimedEventsinthefollowingAutomaticWorkloadsRepository(AWR)report:Whatarethreepossiblecausesforthelatch-relatedwaitevents?（）A、Thesizeofthesharedpoolistoosmall.B、Cursorsarenotbeingshared.C、AlargenumberCOMMITSarebeingperformed.D、Therearefrequentlogonsandlogoffs.E、Thebuffersarebeingreadintothebuffercache,butsomeothersessionischangingthebuffers.20.Examine the following command that is used to duplicate a database on the same host：   RMAN> RUN {  ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）A、 The data files of the read-only tablespaces in the target database are not duplicatedB、 The read-only tablespaces in the target database are still defined in new the databaseC、 The read-only tablespaces in the target database are changed to online after duplicationD、 The data files of the read-only tablespaces in the target database get duplicatedE、 The read-only tablespaces in the target database are not defined in the new database21.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.22.Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started.23.You executed the following code：   SQL> CREATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   In which tablespace will the mapping table be created？（）A、 SYSTEM tablespaceB、 SYSAUX tablespaceC、 Undo tablespaceD、 The tablespace of the Index Organized Table （IOT）24.You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）A、Recreate the query and default the layout. B、Alter the query, default the layout and redo the boiler plates. C、Query and manually change the layout to save the boiler plate. D、Alter the query and make no further change.25.当用户进程失败时，由（）执行恢复操作，负责清除缓存和进程使用的空闲资源。A、SMONB、PMONC、ARCnD、RECO26.Coherence provides the ideal infrastructure for building _____ services， and the ______ applications.（）A、 Data Grid； Client and Server basedB、 Outster； Client and Server basedC、 Data Grid；DNS basedD、 Cloud cluster；Client and Server based27.WhichofthefollowingwouldbeaffectedbysettingNLS_LENGTH_SEMANTICS=CHAR?（）A、AllobjectsinthedatabaseB、TablesownedbySYSandSYSTEMC、DatadictionarytablesD、NCHARcolumnsE、CHARcolumns28.下面哪个用户不是ORACLE缺省安装后就存在的用户（）。A、SYSDBAB、SYSTEMC、SCOTTD、SYS29.WhichisavalidCREATETABLEstatement?（）A、CREATETABLEEMP9$#AS(empidnumber(2));B、CREATETABLEEMP*123AS(empidnumber(2));C、CREATETABLEPACKAGEAS(packidnumber(2));D、CREATETABLE1EMP_TESTAS(empidnumber(2));30.Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）A、Schedule the report's execution in the queue manager. B、Schedule the reports execution using the R30RQM command line with scheduled parameter. C、Create a trigger in the application to execute the report every six hours. D、You cannot schedule a reports execution.31.You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.32.Given： Which statement is true？（）A、This code can throw an InterruptedException.B、This code can throw an IllegalMonitorStateException.C、This code can throw a TimeoutException after ten minutes.D、Reversing the order of obj.wait（） and obj.notify（） might cause this method to complete normally.E、A call to notify（） or notifyAll（） from another thread might cause this method to complete normally.33.Whichstatementexplicitlynamesaconstraint?（）A、ALTERTABLEstudent_gradesADDFOREIGNKEY(student_id)REFERENCESstudents(student_id);B、ALTERTABLEstudent_gradesADDCONSTRAINTNAME=student_id_fkFOREIGNKEY(student_id)REFERENCESstudents(student_id);C、ALTERTABLEstudent_gradesADDCONSTRAINTstudent_id_fkFOREIGNKEY(student_id)REFERENCESstudents(student_id);D、ALTERTABLEstudentgradesADDNAMEDCONSTRAINTstudent_id_fkFOREIGNKEY(student_id)REFERENCESstudents(student_id);E、ALTERTABLEstudentgradesADDNAMEstudent_id_fkFOREIGNKEY(student_id)REFERENCESstudents(student_id);34.The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）A、until SCNB、until timeC、until cancelD、using backup control file35.（）参数用于确定是否要导入整个导出文件。A、constranintsB、tablesC、fullD、file36.What is the maximum database block size supported for the Oracle9i database？（）A、16KBB、32KBC、64KBD、128KB37.View the Exhibit and examine the user information.  The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table：  SQL> CREATE TABLE orders（oid number（6）， odate date， ccode number（4）， oamt number（10，2）） TABLESPACE purchase_space；  The PURCHASE_SPACE tablespace already exists in the database.  Which statement describes theeffect of the command（）A、The command executes successfully and creates the table in the USERS tablespace.B、The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.C、The command produces an error because the user does not have the privilege to create the table.D、The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.38.ForwhichtwoactionscanyouusetheTO_DATEfunction?（）A、convertanydateliteraltoadateB、convertanynumericliteraltoadateC、convertanydatetoacharacterliteralD、format'January101999'forinputE、format'10-JAN-99'to'January101999'39.Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）A、 osB、 localC、 -8：00D、 dbtimezone LiE、 Australia40.Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）A、TARGET_REDO_BLKSB、FAST_START_IO_TARGETC、LOG_CHECKPOINT_TIMEOUTD、RECOVERY_ESTIMATED_IOSE、LOG_FILE_SIZE_REDO_BLKSF、LOG_CHECKPOINT_INTERVAL41.You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.42.The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）A、Minimum widow records. B、Column mode. C、Spacing D、Print direction. E、Source F maximum records per page. F、Maximum records per page.43.Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）A、On Wednesday， the statistics have been purged.B、On Wednesday， the retention period has been set to zero.C、On Wednesday， the collection interval has been set to zero.D、On Wednesday， the collection level has been changed to All.E、On Wednesday， the retention period has been set to one day.F、On Wednesday， the retention period has been set to two daysG、On Wednesday, the collection level has been changed to Typical.H、On Wednesday, the collection interval has been set to 1440 minutes.44.Given： Which statement is true？（）A、All of the assert statements are used appropriately.B、Only the assert statement on line 12 is used appropriately.C、Only the assert statement on line 15 is used appropriately.D、Only the assert statements on lines 15 and 18 are used appropriately.45.You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）A、 Restore the lost data file from the backup， and then flash back the database.B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.46.You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L147.ThedatabaseisrunningintheARCHIVELOGmode.Ithasthreeredologgroupswithonemembereach.Oneoftheredologgroupshasbecomecorrupted.Youhaveissuedthefollowingcommandduringtherecoveryofadamagedredologfile: ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP3; Whichactionshouldyouperformimmediatelyafterusingthiscommand?（）A、YoushouldperformalogswitchB、YoushouldmakeabackupofthedatabaseC、YoushouldswitchthedatabasetotheNONARCHIVELOGmodeD、Youshouldshutdownthedatabaseinstanceandperformacompletedatabaserecovery48.Given the command line java Pass2 and： What is the result？ （）A、 doStuff x = 6 main x = 6B、 Compilation fails.C、 doStuff x = 6 main x = 7D、 An exception is thrown at runtime.E、 doStuff x = 7 main x = 6F、 doStuff x = 7 main x = 749.The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）A、An update in a leaf row takes place.B、The index becomes invalid after the update.C、The leaf block containing the row to be updated is marked as invalid.D、A row in the leaf block of the index for the key value is deleted and inserted.50.You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；51.By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） A list of changes made along with the transaction identifier of each change.  b） The necessary SQL statements to undo the erroneous changes.  Which option would you choose？（）A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.52.如果要设置SQL*PLUS每页打印的数值，则可以使用如下哪个命令（）。A、SETPAGEB、PAGESIZEC、SETPAGESIZED、SIZE53.How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）A、Include an SPFILE parameter in each instance-specified initialization file.B、Create an SPFILE copy on each client from which the instance will be started.C、Store the SPFILE in a raw partition with a vendor-specifies location and name.D、Use a single client to start the instances and create the SPFILE on this client.54.Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you？（）A、AB、BC、CD、D55.The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view56.Whichstatementsaretrueregardingthesystem-definedmovingwindowbaselineinOracleDatabase11g?（）A、Itdoesnotallowyoutochangethemovingwindowsize.B、Adaptivethresholdfunctionalitiesuseitbydefaulttocomputestatistics.C、ItiscreatedbydefaultwiththewindowsizebeingequaltotheAWRretentiontime.D、ItiscreatedwhenthefirstsnapshotiscollectedbytheAutomaticWorkloadRepository(AWR).57.YouinstallacopyofMysql5.6.13onabrandnewLinuxserverbyusingRPMpackages.Theserverstartssuccessfullyasverifiedbythefollowingcommands:$pidofmysqld3132 $tail–n2/var/lib.mysql/hostname.err 2013-08-1808:18:383132[Note]/usr/sbin/mysqld:readyforconnections.Version:'5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock'port;3306MysqlEnterpriseServer–AdvancedEdition(Commercial)Youattempttologinastherootuserwiththefollowingcommand:$mysql–urootERROR1045(28000):Accessdeniedforuser'root'@'localhost'(usingpassword:NO) Whichstatementistrueaboutthisscenario?（）A、TheRPMinstallationscriptsetsadefaultpasswordofpasswordfornewinstallationsB、Thelocalrootusermustloginwithablankpasswordinitially:mysql–uroot–pC、Newsecuritymeasuresmeanthatthemysql_secure_installationscriptmustberunfirstonallnewinstallationsD、Themysql_install_bdpost-installationscriptused–random-password58.InwhichcasewouldyouuseaFULLOUTERJOIN?（）A、BothtableshaveNULLvalues.B、Youwantallunmatcheddatafromonetable.C、Youwantallmatcheddatafrombothtables.D、Youwantallunmatcheddatafrombothtables.E、Oneofthetableshasmoredatathantheother.F、Youwantallmatchedandunmatcheddatafromonlyonetable.59.You sch