【CUUG内部资料】OCP-052-考试原题讲解-第4次课

oracle ocp考试科目-概述说明以及解释1.引言1.1 概述概述Oracle OCP（Oracle Certified Professional）考试科目是为那些希望在Oracle数据库管理领域发展的专业人士而设计的。

这个认证涵盖了一系列的知识和技能，旨在测试考生是否具备高水平的Oracle数据库管理能力。

Oracle OCP考试科目主要分为两个部分：核心要求和选修要求。

核心要求包括数据库管理的基本知识和技能，而选修要求则涵盖了更多专项技术和领域的内容。

在核心要求部分，考生需要对Oracle数据库的体系结构、内部机理和功能特性有深入的了解。

他们需要掌握数据库的安装和配置、数据备份和恢复、性能优化、安全管理等方面的知识和技能。

此外，他们还需要熟悉SQL和PL/SQL编程，以及在Oracle数据库环境中开发和调试应用程序的技巧。

选修要求部分则根据考生的个人需求和职业发展方向提供了多个选择。

考生可以选择深入学习和掌握特定领域的知识和技术，如高可用性、数据仓库、分布式数据库等。

这些选修要求旨在让考生能够根据自己的兴趣和职业需求，更好地应对复杂的数据库管理和开发挑战。

通过Oracle OCP考试科目的学习和认证，考生可以证明自己具备了管理和开发Oracle数据库的能力。

这将为他们在职场上获得更多机会和提升空间，打下坚实的基础。

总之，Oracle OCP考试科目是一项重要的认证，它要求考生具备全面的Oracle数据库管理和开发技能。

通过此认证，考生可以展示他们的专业素养和实力，获得更好的职业发展机会。

1.2文章结构1.2 文章结构本文将围绕Oracle OCP考试的科目展开讨论。

首先，我们将概述Oracle OCP考试的背景和重要性。

接着，文章将分为三个主要部分，分别是引言、正文和结论。

在引言部分，我们将对Oracle OCP考试的整体概述进行阐述。

我们将介绍什么是Oracle OCP考试，它的目的和意义，并解释为什么这是对于那些希望在Oracle数据库管理领域取得认可的人来说必备的考试。

31、（12-11） choose the best answer:Examine the structure and data in the PRICE_LIST table:You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.Which SQL statement would give the required result?A) SELECT TO_CHAR (TO_NUMBER (prod_price)*.25, '$99,999.00')FROM PRICE_LIST; B) SELECT TO_CHAR(prod_price*.25, '$99,999.99')FROM PRICE_LIST; C) SELECT TO_CHAR(TO_NUMBER(prod_price,'$99,999.99')*.25,'$99,999.00')FROM PRICE LIST; D) SELECT TO_NUMBER (TO_NUMBER(prod_price, '$99,999.99')*.25, '$99,999.00') FROM PRICE_LIST; Answer:A (解析：其实B 答案也可以实现要求，但是它不是最好的，这里需要to_number 转换函数，因为prod_price 本身是varchar2类型，可以用如下语句实验： SELECT TO_CHAR(to_number(sal)*.25, '$99,999.99') FROM emp; 原来051的考题） 2018-12-1532、（12-14） choose the best answer:Examine the command to create the BOOKS table. SQL>CREATE TABLE books(book_id CHAR(6) PRIMARY KEY,title VARCHAR2(100) NOT NULL,publisher_id VARCHAR2(4), author_id VARCHAR2(50));The BOOK_ID value 101 does not exist in the table.Examine the SQL statement:SQL> INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)VALUES ('101', 'LEARNING SQL', 'Tim Jones'); Which statement is true?A) It executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement.B) It executes successfully only if NULL is explicity specified in the INSERT statement. C U U G O r a c l e 培训领航专家C) It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement.D) It executes successfully and the row is inserted with a null PUBLISHER_ID .Answer ：D33、（12-15） choose the best answer:View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.You executed the following SQL statement:SELECT order_id, product_id, unit_price*quantity "Total Price"FROM order_itemsWHERE unit_price*quantity > 50000NATURAL JOIN orders; Which statement is true regarding the execution of the statement? A) The statement would not execute because the WHERE clause is before the NATURAL JOIN clause. B) The statement would not execute because the USING keyword is missing in the NATURAL JOIN clause. C) The statement would execute and provide the desired result. D) The statement would not execute because the ON keyword is missing in the NATURAL JOIN clause. Answer ：A （解析：注意语法，where 子句应该出现在各种连接的语句后面，比如right outer join 等等。

2018年OCP 052最新考试题库解析-20180727题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG七. Storage Structures19. Which three structures can span multiple data files？A) migrated rowsB) table extentsC) temporary segment extentsD) index extentsE) chained rowsF) segmentsAnswer：AEF20. Which structure can span multiple data files?A) a bigfile tablespaceB) a permanent tablespaceC) a segmentD) a temporary tablespaceE) an extentAnswer：C21. Which four database objects never have any segments？A) A partitioned indexB) A view selecting from a populated tableC) An empty indexD) An Oracle Loader type external tableE) An empty tableF) A view selecting from an empty tableG) An Oracle Data Pump type external tableAnswer：BDFG22. Which three of these must be accessible to keep a database open?A) Control file.B) All members of a redo log group.C) SYSTEM tablespace.D) SYSAUX tablespace.E) spfileAnswer：ABC23. Which two of these must be available READ/WRITE to keep a database open?A) all copies of the control file.B) the password file.C) all members of the current redo log group.D) spfile.E) TEMP tablespaceF) SYSAUX tablespaceAnswer：AC24. Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’.The parameters, DB_CREATE_ONLINE_LOG_DESN_n and DB_RECOVERY_FILE_DEST, and not specified.Which four are stored in the location specified by DB_CREATE_FILE_DEST?A) audit logsB) control filesC) redo logsD) audit filesE) data filesF) archived redo logsG) temp filesH) RMAN backupsAnswer：BCEG八. Checkpoint25. When does an incremental checkpoint occur ?A) when an online redo log switch occurs.B) when DBWn writes dirty buffers as part of its normal processing.C) when the ALTER SYSTEM CHECKPOINT statement is executed.D) when a user tablespace is tabken offline.Answer：A九. Inventory Directory24. Which two are true about the Inventory directory?A) It is shared by all Oracle software installations on a single server.B) It is required only for Oracle Grid Infrastructure and Oracle Database software Installations.C) It can be created only if the ORACLE_BASE environment variable is set.D) It should be created before installing Oracle software for the first time on a server.E) It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server.Answer：AD⼗. Administer Database25. which four are true about the tools used to administer Oracle database?A) the Data Pump utility can be used to load data from text files.B) SRVCTL can be used to shut down Oracle instances.C) SQL* Plus can be used to create databases.D) SQL*Plus can be used to startup Oracle instances.E) DBCA can be used to upgrade databases.F) RMAN can be used to startup Oracle instances.Answer：BCDF⼗一.Archivelog26. Which state must a database be to enable ARCHIVELOG ?A) NOMOUNTB) OPEN IN READ WRITE modeC) OPEN IN READ ONLY modeD) OPEN IN RESTRICTED modeE) MOUNTAnswer: E⼗二.Data Pump27. Which two can be exported by a non-administrative account by using Data Pump?A) directory objectsB) tablesC) tablespacesD) schemasE) DatabaseAnswer：BD28. Where is an expdp operation tracked?A) dump filesB) control fileC) log filesD) Automatic Diagnostic Repository(ADR)E) master table (MT)Answer：E29. Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?A) If the directory used in the export operation has existing dump files, it overwrites them.B) It allows encryption to be performed without using a password.C) It supports the export of specific views as tables.D) It allows compression levels to be defined for the export.E) It supports the renaming of tables during import.Answer：AE11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。

052题库解析OCP考试052最新考试题库原题-8-20180727题库新特点： 最原有的题库基础上有添加了新的题库七. Storage Structures19.Whichthreestructures canspanmultipledatafiles？A) migratedrowsB) tableextentsC) temporarysegmentextentsD) indexextents E)chainedrowsF)segments Answer：AEF20.Whichstructure canspan multipledatafiles?A)a bigfile tablespaceB) apermanenttablespaceC)asegmentD) a temporarytablespaceE) an extent Answer：C21.Whichfourdatabaseobjectsneverhaveanysegments？A)ApartitionedindexB)Aviewselectingfroma populatedtableC)AnemptyindexD)AnOracle LoadertypeexternaltableE)AnemptytableF)Aviewselectingfrom anemptytableG)AnOracle DataPump typeexternaltableAnswer：BDFG22.Which threeof thesemust beaccessibleto keepa databaseopen?A)Controlfile.B)Allmembers ofa redologgroup.C) SYSTEMtablespace.D) SYSAUXtablespace.E)spfileAnswer：ABC23.Whichtwoofthese mustbeavailableREAD/WRITEtokeep adatabase open?A)allcopiesof the controlfile. B)thepasswordfile.C) allmembers ofthecurrentredologgroup. D)spfile.E)TEMPtablespaceF)SYSAUXtablespaceAnswer：AC24.Archivelogmodeis enabledfor yourdatabaseandDB_CREATE_FILE_DESTis set to‘/u01/oracle/db01’.The parameters,DB_CREATE_ONLINE_LOG_DESN_nandDB_RECOVERY_FILE_DEST, andnot specified.Whichfour arestored inthelocation specified by DB_CREATE_FILE_DEST? A) auditlogs B) control files C) redologs D) auditfiles E) data filesF) archivedredologsG) temp filesH) RMAN backupsAnswer：BCEG八.Checkpoint25. When doesanincrementalcheckpointoccur?A)whenanonlineredologswitchoccurs.B)whenDBWnwrites dirty buffersas partofitsnormal processing.C)whentheALTERSYSTEMCHECKPOINTstatement is executed.D)whena usertablespaceis tabken offline.Answer：A九. InventoryDirectory24.WhichtwoaretrueabouttheInventorydirectory?A) Itissharedby allOraclesoftwareinstallationsona singleserver.B) Itisrequiredonlyfor Oracle Grid InfrastructureandOracleDatabase softwareInstallations.C) Itcanbecreatedonlyif theORACLE_BASE environmentvariableisset.D) It shouldbecreatedbeforeinstallingOraclesoftwareforthefirsttime onaserver.E) Itisownedbytheoinstallgroup,whichmust becreatedbeforeinstallingOraclesoftwareforthe first timeon a server.Answer：AD⼗.Administer Database25.whichfourare true aboutthe toolsusedtoadministerOracle database?A)the DataPumputilitycan beused to loaddatafromtextfiles.B) SRVCTLcanbeusedto shutdownOracleinstances.C) SQL* Plus canbeusedtocreatedatabases.D)SQL*Pluscan beusedto startupOracleinstances.E) DBCAcanbeusedto upgradedatabases.F) RMANcanbeusedto startup Oracle instances.Answer：BCDF⼗一.Archivelog26.Which statemusta databasebe to enableARCHIVELOG?A)NOMOUNTB) OPENIN READ WRITEmodeC) OPEN INREADONLYmodeD) OPEN INRESTRICTEDmodeE)MOUNTAnswer:E⼗二.DataPump27.Whichtwocanbeexportedbyanon-administrativeaccountby usingDataPump?A)directoryobjectsB) tablesC) tablespacesD)schemas E)DatabaseAnswer：BD28.Where isanexpdpoperationtracked?A)dumpfiles B) control file C) logfilesD)Automatic DiagnosticRepository(ADR)E) master table(MT)Answer：E29.Whichtwoaretrue aboutOracleDataPumpinOracleDatabase11gRelease2?A) Ifthedirectory usedinthe exportoperationhasexistingdumpfiles,it overwritesthem.B) Itallowsencryptionto beperformedwithoutusinga password. C) It supportsthe exportof specific viewsas tables.D) Itallowscompressionlevelsto be defined for theexport. E)Itsupportsthe renamingoftablesduringimport.Answer：AE11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。

2018年OCP 052最新考试题库解析-20180608题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG1、Which three are true about undo segments and undo tablespaces in the same database and instance?•A. Multiple transactions run by the same Oracle user can share a single undo segment.•B. Multiple transactions run by different Oracle users can share a single undo segment.•C. A serial transaction can use multiple undo segments.•D. Undo segments are automatically dropped shortly after transactions that use them commit. •E. A new undo segment is always created for each transaction.•F. A database can have multiple undo tablespaces.•Correct Answer: ABF2、Which two are true about the Data Recovery Advisor?•A. It can be used only for databases that are running in ARCHIVELOG mode.•B. It can be used when the database is closed.•C. It can be used to validate database recovery strategies.•D. It provides intelligent database problem analysis.•E. It can be used to validate database backup strategies.•F. It can be used only for databases with FLASHBACK enabled.•Correct Answer: CD3、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?•A. If the directory used in the export operation has existing dump files, it overwrites them. •B. It allows encryption to be performed without using a password.•C. It supports the renaming of tables during import.•D. It supports the export of specific views as tables.•E. It allows compression levels to be defined for the export.•Correct Answer: BE4、For your ORCL database.1. The instance is started using an spfile.2. The database is opened.3. It is in ARCHIVELOG mode.4. CONTROL FILE AUTOBACKUP IS ON.Examine this command:RMAN> backup as copy datafile ‘users01.dbf’,’example01.dbf’; Which four files are backed up?•A. spfile•B. undo01.dbf•C. users01.dbf•D. archivelogs•E. sysaux01.dbf•F. control file•G. system01.dbf•H. example01.dbfCorrect Answer: ACFH5、When does an incremental checkpoint occur?•A. when DBWn writes dirty buffers as part of its normal process •B. when the alter system checkpoint statement is executed. •C. when a user tablespace is taken offline•D. when an online redo log switch occurs•Correct Answer: A6、Examine this query and its output:SQL> select sid,event,blocking_sessionfrom v$sessionwhere blocking_session is not null;SID EVENT BLOCKING_SESSION --- ----------------------------------- --------------------------- 105 enq:TX – row lock contention 15Which two are true?•A. The blocked session is waiting on a shared table lock.•B. The blocked session is waiting on an enqueue.•C. The blocking session is waiting on a row-level lock.•D. Session 105 is blocked by session 15.•E. Session 105 is blocking session 15.•Correct Answer: BD•7、In one of your databases:1. USER1 and USER2 have no system privileges.2. ROLE1 only has these privileges:* create session* create table* create viewExamine these commands:SQL> conn / as sysdbaConnectedSQL> GRANT create table,role1 to user1 with admin option;grant successedSQL> conn user1/oracle_4uConnectedSQL> GRANT role1 to user2;grant successed7、Which command would you execute and as which user, to revoke the create table privilege from USER2?•A. Revoke create table from user2 as user1•B. Revoke create table from user1 as sys•C. Revoke create table from role1 as user1•D. Revoke create table from role1 as sys•E. Revoke create table from user2 as sys•Correct Answer: D如果用user1回收角色的权限，会报错：SQL> revoke create session from role1;revoke create session from role1*ERROR at line 1:ORA-01031: insufficient privileges8、Which two are true about server-generated alerts?•A. Stateful alerts must always be cleared manually.•B. They are visible in Oracle Enterprise Manager by default.•C. All stateful alerts can be found in DBA_ALERT_HISTORY.•D. They can be based only on database metrics.•E. Stateless alerts cannot be found in DBA_OUTSTANDING_ALERTS.•F. They can be based only on instance metrics.•Correct Answer: BE9、Your database instance is in NOMOUNT state.Your select the delete option in the database configuration assistant (DBCA) for your database. What is the outcome?•A. DBCA is able to delete the data files but not the services.•B. DBCA shuts down the instance and deletes the database.•C. DBCA is able to delete the services but not the data files.•D. DBCA prompts you to open the database, and then proceeds with the deletion.Correct Answer: D10、Which is true when a database instance is shut down?•A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions either to commit or rollback and then close the database•B. IMMEIATE, TRANSACTIONAL, and NORMAL modes all result in a checkpoint• C. Only TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions to commit or rollback and then close the database•D. Neither the IMMEDIATE nor the ABORT mode rolls back uncommitted transactions. Correct Answer: B11 、The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tablespace TBS1.There are no existing backups of the database.Examine these commands:$rman target /RMAN> BACKUP DATABASERMAN> exit$sqlplus / as sysdbaSQL>UPDATE USER1.EMP set SAL=5000 WHERE eno=10;1 row updatedSQL>COMMITCommit CompleteSQL>exitRMAN>CONFIGURE EXECUTE FOR TABLESPACE tbs1;RMAN>BACKUP INCREMENTAL LEVEL 1 DATABASE;•What is the outcome?•A. It takes a level 0 incremental backup of ORCL with TBS1.•B. It takes a level 1 incremental backup of ORCL without TBS1.•C. It takes a level 0 incremental backup of ORCL without TBS1.•D. It takes a level 1 incremental backup of ORCL with TBS1.•Correct Answer: C12、Which two statements are true about dispatchers used by the Oracle shared server? •A. Multiple user processes can connect to a single dispatcher.•B. They return completed requests to the appropriate user processes.•C. A dispatcher is created for each user process.•D. Multiple dispatchers can connect to a single server process.•E. They pull requests from the requests queue and process them until they are complete. •Correct Answer: AB13、Examine this session output:SQL>connect scott/tigerConnectedSQL>select name,value from v$parameter where name =’audit_trail’;NAME VALUE-------- --------audit_trail DBSQL>audit all on emp;Audit succeededWhich two will generate an audit record?•A. every DDL statement executed by SCOTT that affects SCOTT.EMP•B. every UPDATE statement executed by SCOTT that updates SCOTT.EMP•C. only the first SELECT statement executed by SCOTT is a session on SCOTT.EMP•D. only the first DML statement executed by SYSTEM in a session on SCOTT.EMP•E. every UPDATE statement executed by SCOTT that updates HR.EMP•F. any DML statement executed by SYS on SCOTT.EMP•Correct Answer: AB14、In which two cases is a consistent database backup created?•A. when the RMAN BACKUP command is used while the database is OPEN READ ONLY• B. when the RMAN BACKUP AS COPY command is used while the database is OPEN RESTRICTED•C. when the RMAN BACKUP AS COPY command is used while the database is OPEN•D. when O/S commands are used to copy database files after a database instance is shut down normally•E. when the RMAN BACKUP command is used while the database is mountedCorrect Answer: AD只读表空间下用rman备份时没有发生检查点，无需更改数据文件头部，所以可以备份数据库。

ocp认证考试试题OCP认证考试试题随着信息技术的不断发展，计算机行业对于专业人才的需求也越来越高。

为了提高自己的竞争力和专业水平，越来越多的人开始参加各种认证考试。

在计算机领域中，Oracle Certified Professional（OCP）认证是一项非常重要的认证之一。

本文将就OCP认证考试试题进行探讨。

OCP认证考试试题是一项全面评估考生在Oracle数据库管理方面知识和技能的考试。

这些试题涵盖了数据库管理的各个方面，包括安装和配置、备份和恢复、性能调优、数据迁移等。

考生需要通过这些试题来证明自己具备了管理Oracle数据库的能力。

首先，我们来看一下OCP认证考试试题的难度。

这些试题既包括基础知识的考察，也包括实际应用能力的考察。

考生需要对Oracle数据库的体系结构、SQL语言、PL/SQL编程等方面有深入的了解，并且能够灵活运用这些知识来解决实际问题。

因此，OCP认证考试试题的难度相对较高，需要考生具备扎实的理论基础和丰富的实践经验。

其次，我们来看一下OCP认证考试试题的形式。

这些试题一般分为选择题和实验题两种形式。

选择题主要考察考生对于Oracle数据库管理方面的理论知识的掌握程度，考生需要根据题目给出的情境选择最合适的答案。

而实验题则要求考生在实际环境中完成一系列的操作，例如安装数据库、创建表、编写SQL语句等，以检验考生的实际操作能力。

接下来，我们来看一下OCP认证考试试题的内容。

这些试题主要涵盖了以下几个方面：1. 数据库安装和配置：考生需要了解Oracle数据库的安装和配置过程，包括选择合适的安装选项、设置数据库参数、创建数据库实例等。

2. 备份和恢复：考生需要了解Oracle数据库的备份和恢复策略，包括全备份、增量备份、归档日志等。

同时，考生还需要掌握如何使用Oracle Recovery Manager（RMAN）工具来进行备份和恢复操作。

3. 性能调优：考生需要了解如何通过调整数据库参数、优化SQL语句、创建索引等手段来提高数据库的性能。

CUUG内部资料OCP最新考试题库-1Z0-062(1)【CUUG内部资料】OCP讨论群：5267481【CUUG 内部资料】OCP 最新考试题库-1Z0-062(1) 序：OCP 认证是 Oracle 的一个中级认证，对于升职加薪跳槽都有很大的帮助，但是想考 OCP 证书其实有一定的难度，比如考试题的内容全部都是英文题、考题的内容会有稍微修改、考题的答案顺序并不固定、不定时的出现新考题等。

这些都增加了考试的难度，所以我们收集了一些考试题并进行了讲解，这部分内容是关于12c-062的考试解析，希望对广大考生有帮助。

QUESTION1 Examine the parameters for your database instance: NAME TYPE VALUE -------------------------- ------------------------------- ---------------------------undo_management string AUTO undo_retention integer 1200 undo_tablespace string UNDOTBS1 You execute the following mand: SQL> ALTER TABLESPACE undotbs1 RETENTIONNOGUARANTEE; Which statement is true in this scenario? A.Undodata is written to flashback logs after1200 seconds.B.Inactive undo data is retained for1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.C.You can perform a Flashback Database operation only within t he duration of1200 seconds.D.An attempt is made to keep inactive undo for1200 seconds but transactions may overwrite the undo before that time has elapsed.CorrectAnswer: D Section: (none) Explanation 验证过 QUESTION2 A user establishes a connection to a database instance by using an Oracle connection.Youwant to ensure the following:1.Theuser account must be locked after five unsuccessful login attempts.2.Data read per session must be limited for the user.3-The user cannot have more than three simultaneous sessions.4.The user must have a maximum of10 minutes session idle time before being logged off automatically.Howwould you acplish this? A.bygranting a secure application role to the user B.by implementing Database Resource Manager C.byusing Oracle Label Security options D.byassigning a profile to the user Correct Answer: D Section: (none) Explanation 验证过 QUESTION 3 As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database.SCOTTs password is TIGER.Theservice mane “HQ“ is used t o connect to the remote HQ database.Whichmand would you execute to create the database link?A.CREATEDATABASE LINK HQ USING HQ ; B.CREATEDATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ S C.CREATEPUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING HQ ; D.CREATEDATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING HQ ; Correct Answer: C Section: (none) Explanation 验证过 QUESTION 4 What happens if a maintenance window closes before a job that collects optimizer statistics pletes? A.Thejob is terminated and the gathered statistics are not saved.B.The job is terminated but the gathered statistics are not published.C.The job continues to run until all statistics are gathered.D.The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.CorrectAnswer: D Section: (none) Explanation 在数据库一直打开的情况下，GATHER_STATS_JOB会伴随维护窗口一起被启动，默认情况下如果到维护窗口关闭该JOB仍未结束则将被终止(这取决于该JOB的属性stop_on_window_close)，剩下的有待收集信息的对象将在下一个维护窗口中得到处理；如果数据库一直处于关闭的状态，并在某维护窗口的时间范围内该DB被打开，那么相应的维护窗口会被立即激活(ACTIVE)，同时GATHER_STATS_JOB自动作业也会被启动，但该自动作业仅会在一个窗口中自动运行一次。

1Z0-052: Administration I 知识点汇总1.请说明Oracle 数据库服务器体系所包含的三种主要结构的名称。

There are three major structures in the Oracle Database server architecture: memory structures, process structures, and storage structures.三种主要结构:内存结构、进程结构和存储结构2.请分别说明数据库写进程(DBWn)、日志写进程(LGWR)、系统监视器进程(SMON)、进程监视器进程(PMON)的作用。

DBWn:Writes modified (dirty) buffers in the database buffer cache to disk: •Asynchronously while performing other processing•To advance the checkpoint将数据库缓冲区高速缓存中经过修改的缓冲区(灰数据缓冲区)写入磁盘有两种方式:•在执行其它处理时异步执行•推进检查点(DBW1 到DBW9 以及DBWa 到DBWz)将缓冲区的内容写入数据文件;LGWR:Writes the redo log buffer to a redo log file on disk•Writes:–When a user process commits a transaction –When the redo log buffer is one-third full–Before a DBWn process writes modified buffers to disk –Every 3 seconds将重做日志缓冲区写入磁盘上的重做日志文件中•在以下情况下执行写操作:–用户进程提交事务处理时;–重做日志缓冲区的三分之一已满时;–DBWn 进程将经过修改的缓冲区写入磁盘之前;–每隔3 秒SMON:The System Monitor process (SMON) performs recovery at instance startup if necessary. •Performs recovery at instance startup •Cleans up unused temporary segments系统监视器进程(SMON) 可在实例启动时执行恢复(如果需要)•在实例启动时执行恢复•清除不使用的临时段PMON: Performs process recovery when a user process fails –Cleans up the database buffer cache –Frees resources that are used by the user process ;•Monitors sessions for idle session timeout •Dynamically registers database services with listeners The Process Monitor process (PMON) performs process recovery when a user process fails.在用户进程失败时执行进程恢复–清除数据库缓冲区高速缓存–释放该用户进程使用的资源•监视会话,查看是否发生空闲会话超时•在监听程序中动态注册数据库服务进程监视器进程(PMON) 在用户进程失败时执行进程恢复。

052题库解析OCP考试052最新考试题库原题-6-20180615题库新特点：●更加灵活，题库的顺序与考试时的顺序每场都在变化●更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案●不断有新的考题出现，目前最新已经更新到130道题1、Which twocanbe configuredwithprofiles?•A.tablespacequotasforusers•B.the timeafterwhichan idlesessionisterminated •C.defaulttablespaceforusers•D.defaultobject privileges forusers•E. session CPUlimits•F.defaultsystemprivileges forusers •CorrectAnswer: BE2、Inwhichstatemusta database be toenable ARCHIVELOG? •A.NOMOUNT•B.OPENin RESTRICTEDmode•C.OPENinREADWRITE mode•D.MOUNT•E. OPENinREADONLYmode•CorrectAnswer: D3、Yourdatabase is openin ARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecovery Area(FRA) anditis100%full when alogswitchtakesplace.Noalternativeor optionalarchivedestinationsaredefined.What istheoutcome?•A.Obsoletebackupsareautomaticallydeletedand now archivelogsare generated.•B.Thearchivelogentriesaremadeinthediagnosticdestinationand when space isavailable,nowarchivelogsaregenerated.•C.Noarchivelogsaregenerated.•D.Allactivesessionsaredisconnectedand theirtransactionsrolledback.•E.Allactivesessionshanguntil thedatabaseadministrator(DBA) makes spaceavailablein theFRA.•CorrectAnswer:E4、Whichthreearetrue aboutOracledatabasesecurity?•A.Bydefault,SYSDBAconnections haveaccesstoallschema objects. •B. SYSDBAconnectionsarealwayssubjecttomandatoryauditing. •C.Bydefault,SYSOPERconnections haveaccesstothedatadictionary. •D.Fine GrainedAuditingcanbeused torestrictaccess tosensitivedata. •E.SYSOPERconnectionsarealwayssubjecttomandatoryauditing. •F.Mandatoryauditingisenabled bysettingAUDIT_SYSOPERATIONSto TRUE.•CorrectAnswer: ABE5.Whichthreestructures canspan multipledatafiles? •A.chainedrows•B.segments•C.temporarysegmentextents•D.indexextents•E. table extents•F.migratedrows•CorrectAnswer: ABF6、Examine these SQLstatementsand theiroutput:A.Inactiveundowillneverberetainedformorethan15 minutes.B.Theundotablespacecangrowautomaticallyifthereisnotenoughspacetoretainactiveundo.C. Inactive undowillberetainedaslongaspossible withinthelimitsofthe currentsizeoftheundotablespace.D.Inactiveundowillalwaysberetainedforatleast15minutes.E. Activeundowillberetainedaslongasneededbytransactions.CorrectAnswer:BE•7Which threecanreducelock contention in an Oracle database?A.TheDatabaseResourceManagerB.profilesC.scheduling OLTPand batchworkloadsatdifferenttimesD.manuallockingofdatabase objects forDMLstatementsE. committingtransactionsin atimelymanner CorrectAnswer: CDE8、Whichtwoaretrueaboutthe Inventorydirectory?•A.Itis ownedbythe oinstallgroup, which mustbe created beforeinstallingOraclesoftwareforthefirst timeona server. •B.Itissharedbyall Oracle softwareinstallationson asingle server.•C.Itshould becreatedbeforeinstallingOraclesoftwareforthe first timeon a server.•D.Itis requiredonlyforOracle Grid Infrastructure and Oracle Database softwareinstallations.•E. It canbe created onlyif the ORACLE_BASEenvironment variableis set.•CorrectAnswer: AB9、Whichis trueaboutunusableindexes?•A.Rebuildingan unusableindexalwaysrequiresatleasttwice the spaceof the original index•B.Rebuildingan unusableindexalways allowsDML statements on the index’s table during the rebuild.•C.Rebuildingoccursautomaticallywhen anunusableindex is chosenbytheoptimizer when creatingan executionplan •D.Rebuilding an unusable index creates a newsegment after droppingthe unusableindex.•CorrectAnswer: D10、Whichtwoaretrueaboutspacemanagementintablespaces? •A. Freelistsareused formanagingfreespaceforsegmentsin locally managed tablespaces.•B.Extentallocation mustbe specified as automaticfor automaticsegmentspace management(ASSM)tablespaces. •C.ASSMtablespacespreventrowchaining.•D.Locally managedtablespacestrack adjacentfreespace automaticallybyusing bitmaps.•E. Locally managed tablespaceshaveeitherASSMor manual segmentspacemanagement(MSSM),and allthe segmentsin thesetablespacesaremanagedonewayorthe other. •CorrectAnswer: DE11、Whichcommandis used todisplayfiles thatno longer conformtothebackup retentionpolicy?•A.CROSSCHECKBACKUP•B.REPORTOBSOLETE•C.LISTEXPIRED BACKUP•D.SHOWDATAFILEBACKUPCOPIES •Answer: B12TableEMP residesintheUSERStablespace.Examine thiscommand:SQL>DROPTABLEempPURGE;Which twomethods wouldyou use torecoverEMP?•A.FlashbackDrop•B.re-creating thetable and reinsertingthe rows•C.performingatablespace pointin time recoveryof USERS •D.FlashbackTransactionBackout•E.FlashbackTable•Answer: BC12Whichistrue aboutenablingAUTOEXTENDfordatafiles?•A.Itcanbe enabledfordatafiles onlyinsmallfiletablespaces. •B.It canbe enabled foran existingdata file in a tablespace byusingtheALTERTABLESPACEcommand.•C.Itcanbe enabled onlyfordatafiles in non-OMFtablespaces. •D.Itcanbe enabled fordata files onlyin bigfiletablespaces. •E. It canbe enabledforanewdatafile thatis added toa tablespaceonly ifthe existingdatafiles in thattablespacehave autoextendenabled.•Answer:B13In oneof yourdatabases: ••ThedatabasedefaulttablespaceisEXAMPLE.••DEFERRED_SEGMENT_CREATIONisFALSE.•Examinethese commands:•SQL>CREATEUSER user1IDENTIFIEDBYoracle_4UPASSWORDEXPIRE; •User created.•SQL>ALTERUSERuser1 ACCOUUNTUNLOCK;•User altered.•SQL>GRANTCREATESESSIONtouser1;•Grantsucceeded.•SQL>GRANTCREATETABLETOuser1 WITHADMIN OPTION; •Grantsucceeded.•Whichthreearetrue?•ER1cangranttheCREATETABLEprivilegetootherusers.•ER1canlogintothe databaseinstance.•C. USER1 cancreatetablesintheEXAMPLEtablespace.•ER1 cancreateindexesinEXAMPLEtablespace•E. USER1mustchange it‟s passwordatfirstlogin.•Answer:ABE14Whichtwo canbe exportedbya non-administrativeaccount byusing DataPump?•A.tables•B.database•C.directory objects•D.tablespaces•E. schemas•Answer: AE15Yourdatabase is usingAutomaticMemoryManagement. Which twoSGAcomponentsmustbe managedmanually? •A. redologbuffer•B. keepbufferpool•C. largepool•D.sharedpool•E. defaultbufferCache•Answer: AB。

1.写一个查询，选择出当前的日期。

SQL> select sysdate from dual;2.查询出雇员表（emp)表中的雇员号、姓名、新的薪水（是原先薪水的1.25倍），并将该列标记为new salary。

将该脚本保存到p3q2.sql中。

select empno,ename,sal*1.25 "new salary" from emp;先保存到d:\p3q2.sq然后用@d:\p3q2.sq3.运行文件p3q2中的查询。

先保存到d:\p3q2.sq然后用@d:\p3q2.sq4.查询出雇员表中所有员工的姓名；雇佣日期；和工资调整日期（工作6个月后的第一个星期一）。

其格式要求是类似于：“1981-09-23”。

select ename,hiredate,to_char(next_day(add_months(hiredate,6),2),'yyyy-mm-dd day') dayfrom emp;5.查出每个员工的名字（ename）、雇佣日期到现在的日期间隔的月数（要求为整数），该列命名为MONTHS_WORKED，并以该列的降序排序select ename,hiredate,trunc(months_between(sysdate,hiredate)) "months worked" from emp;6.写一个查询，查询出雇员的姓名，以及姓名的长度。

要求其姓名的第一个字母为大写，其它的字母为小写。

select initcap(ename),length(ename) from emp;1.写一个查询来查询出雇员的名字，部门号，部门名称。

select e.ename,d.deptno,d.dnamefrom emp e,dept dwhere e.deptno=d.deptno;2.输出30号部门的所有工作的列表，以及部门号。

052题库解析最新15道题052-题库解析-3-20180525题库新特点：●更加灵活，题库的顺序与考试时的顺序每场都在变化●更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案●不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：/course/326223ocp考试讨论群：836361015 验证：ocpCUUG整理，官网：•1、Which twoeventsalwaysrequesttheLGWRtowrite?•❑A)when LGWRis notified bya server processthatperformsa Commitor ROLLBACK•❑B)WhenPMONrestartsa server process•❑C)whenDBWnwritesdirtybuffers•❑D)when alogswitchoccurs•❑E)when acheckpointoccurs•Answer:CD•2、Examinethesecommandsand theiroutput:•SQL>SELECT*FROMemp;•ENONAME•---------•100Adam•101Alan•SQL>INSERTINTOempVALUES(102,'Ben");•1 rowcreated. •SQL>COMMIT;•Commitcompleted.•SQL>UPDATEempSETename='Bryan'WHEREeno=102;•1 rowupdated.•Apowerfailureoccurs.The InstanceIsrestartedandthisquery Isexecuted. •SQL>SELECTenameFROMemp;•WhatIstheoutcome?•❑A) OnlyAdamandAlanaredisplayed.•❑B) Only Adam,Alan,andBryanaredisplayed.•❑C)Adam,Alan,Ben,and Bryanaredisplayed.•❑D)Norowsarereturned.•❑E)Only Adam,Alan, andBenaredisplayed.•Answer:E•3、WhereIs backupmetadatastoredforuse byRecovery Manager (RMAN)?•❑A)In the controlfile•❑B)Inthe SYSAUXtablespace•❑C)in the SPFILE•❑D)in theSYSTEMtablespace•❑E)Inthe diagnosticdestinationflies•Answer:A•4、Which twocanbe backedup byusingRMANwhen a database IsopeninARCHIVELOGmode, so thatmedia recoverycanbe performed If required?•❑A)controlfiles•❑B)passwordfile•❑C)pfile•❑D)onlineredologs•❑E)flashbacklogs•❑F)datafiles•Answer:AF5、Yourdatabase is using AutomaticMemoryManagement. Which two SGAcomponentsmustbe managedmanually? •❑A) defaultbuffercache•❑B)redologbuffer•❑C)largepool•❑D)sharedpool•❑E)keepbufferpool•Answer:BE6、Which twoaretrueaboutroles?•❑A)A rolecanbe granteda combinationof systemand object privileges and other roles.•❑B)TheCONNECT roleIsgrantedautomaticallyto a user when ItIs created.•❑C)RolesareownedbySYSTEM.•❑D)TheRESOURCE roleIsgrantedthe CREATESESSION privilege.•❑E)Asecureapplicationrolecan be setonly byItsassociated PL/SQL package.•Answer:AE7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EM Pto USER2.SYSexecutesthis command:SQL> REVOKEUPDATEONuser1.emp FROMuser1;What willbethe outcome?•❑A) Itwillsucceedand onlyUSER2willbeunabletoperformSELECT, INSERT,OrUPDATEon USER1.EMU.•❑B)Itwill succeedand onlyUSER1willbeunabletoperformSELECT, INSERT,OrUPDATEon USER1.EMP.•❑C) It willsucceedbutneither USER1norUSER2willbeable toperform SELECT,INSERT,orUPDATEon USER1.EMP.0•❑D)ItwillfallbecauseUSER1IstheownerofUSER1.EMP.•❑E)ItwillsucceedandneitherUSER1norUSER2willbeable toperform INSERTorUPDATEonUSER1.EMP,butbothwillbeable toqueryUSER1. EMP).•Answer:D8、Which threearetrueabouttheAutomaticDatabaseDiagnosticMonitor(ADDM)?•❑A)Itsfindings areaccessibleonly byusingOracleEnterprise Manager.•❑B)Itimprovesdatabaseperformance byautomatically implementingOracle'sbest practices.•❑C)Itcan assistthe DBA in diagnosingdatabaseinstance startupfailures.•❑D)Itcanbe used byexecutingthe PL/SQLproceduresin the DBMS_ADDMpackage.•❑E)Itruns automaticallyafter eachAutomatic Workload Repositorysnapshotiscreated.•❑F)Itprovidesrecommendationstoimprovedatabase performance.•Answer:DEF9、Examine these components:•1.Executionplan fora non-embeddedSQLstatement•2.Local,global,and package variablesfora session•3.Executionplan fora SQL statement containedIna PL/SQL programunit•4.Resultsof executedqueries and queryfragments S.PL/SQL function resultsets•Which of these arestoredinthe shared SQLarea?•❑A)1and 4•❑B)1,2and 3•❑C)1and 3•❑D)1,3,4,and 5•Answer:C•10、ExaminethisLISTENER.ORAfile:•LISTENER=•(DESCRIPTION_LIST= •(DESCRIPTION=•(ADDRESS_LIST=•(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1522)) •)))•SID LISTLISTENER=•(SIDLIST =•(SID_DESC=•(GLOBAL_DBNAME=)•(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)•(SID_NAME=orcl)•))•Howshould youconfigureanadditional listenerLISTENER2thatlistensforthesame SID?•❑A) Add relevantdetailsInDESCRTPTIONunder the existingLTRTENERwithadifferentport number inLISTENER.ORA.•❑B) CreateanotherconfigurationfilecalledLISTENER2.ORAwithonlyLISTENER2detailsinit. •❑C) Add relevantdetailsinSID_LIST_LISTENERunder the existingLISTENERinLISTENER.ORA •❑D)AddLISTENER2anditsSID_LISTdetailsseparatelyunder the nameLISTENER2inLISTENER.ORA •Answer:D11、YourdatabaseIsopeninARCHIVELOGmode.•LOG_ARCHIVE_DESTIs settoFastRecoveryArea(FRA)anditIs 100%full whenalog switchtakesplace.•Noalternativeor optionalarchivedestinationsaredefined.•What Is the outcome?•❑A)Allactivesessions aredisconnected andtheir transactionsrolledback. •❑B)Thearchivelogentriesaremade in thediagnosticdestination and whenspace Isavailable,newarchivelogsaregenerated.•❑C) Noarchivelogsaregenerated.•❑D) Obsoletebackupsareautomaticallydeletedandnewarchivelogsare generated.•❑E)Allactivesessionshanguntil thedatabaseadministrator(DBA) makes space availableIn the FRA.•Answer:E12、Which twoaretrueaboutdatadictionaryviews?•❑A)ALL or USERprefixedviewsdisplayoutput thatare subsetsoftheoutputfromtheDBAprefixeddataviews.•❑B)DBAprefixedviewsare accessiblewhen adatabaseisIn mountstate.•❑C)A user maynotnecessarilybe theownerof allobjects that canbeviewedbyusingthe ALLprefixedviews.•❑D)Auser can querythe DBAprefixedviewsonlyif theyhave the SYSDBAprivilege•❑E)AlldatadictionaryviewsareprefixedwithDBA.Or ALL or USER•Answer:AD13、USER1. EMPhasa referentialIntegrityconstraintdefinedonEMP.DNOthat referencesUSER1. DEPT.DNO.•user1 executesthese commands:•SQL>UPDATEdeptSET 1oc=’UK’wheredno=1;•1 rowupdated•SQL>UPDATEempSET sal=1000whoreeno=100;•1 rowupdated•SQL>ALTERTABLEdeptDROP(dno); •Whatwillbethe outcomeandwhy?•❑A)It willfailbecause areferentialIntegrityconstraintIsdefinedon USER1. EMP. •❑B)It willfallbecausethere Is anuncommittedtransactiononUSER1. EMP. •❑C)It willfailbecausethereis anuncommittedtransactiononUSER1. DEPT. •❑D)It willexecutesuccessfully anddropDEPT.DNO.•❑E)It willexecutesuccessfully anddropthe DEPT.DNOandEMP.DNOcolumns. •Answer:A14、Which twoaretrueaboutundotablespaces?•❑A)Theyalwaysretain undoforthe timeperioddefinedby UNDO_RETENTION.•❑B)Theymusthaveonlyonedata file.•❑C)Theycanbe recoveredonly when an InstanceIsIn MOUNT state.•❑D)Tablescanbe created InundotablespacesbySYS.•❑E) Single-Instancedatabases canhaveonly one active undo tablespace.•Answer:CE15、Which fouraretrueaboutthe toolsused toadminister Oracledatabases?•❑A)SQL*Pluscanbe used tocreatedatabases.•❑B)RMANcanbe used tostart up OracleInstances.•❑C)DBCAcanbe used toupgradedatabases.•❑D)TheDataPumputility canbe usedtoload datafromtext files.•❑E)SQL*Pluscanbe used tostartup Oracleinstances. •❑F) SRVCTLcanbe used toshutdownOracleinstances. •Answer:ABEF。

实用文档052题库解析OCP考试052最新考试题库原题-11-20180817⼆十.Initialization parameter70. which is true about initialization parameter administration?A) Some Dynamic parameter values can be modified to affect only onesessionB) Dynamic parameters, when modified, always revert to their originalvalues after the database instance is restartedC) Static parameter values can be changed in the spfile only by usingthe alter system command with scope=spfile when the database isclosedD) Static parameter values can be changed for the current instance byusing alter system command with scope=memoryAnswer：A（验证过）71. You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.Which is true?A) It can be used only if a pfile is used.B) The change occurs immediately in memory for static parameters but it is not persistent afterinstance restart.C) The change occurs immediate in memory for dynamic parameters but it is not persistent afterinstance restart.D) In can be used only if an spfile is used.Answer：C72. which three statements are true about initialization parameters and files?A) An idle instance must start with a PFILE.B) Session modifiable initialization parameters can only be changed by a user with the DBA role.C) The ALTER SYSTEM command can be used to change parameter values for an instance startedusing a PFILE.D) An SPFILE can be created from an idle instance.E) Session modifiable initialization parameters can only be changed once per session.F) The ALTER SYSTEM command can be used to change parameter values for an instance startedusing an SPFILEG) System modifiable initialization parameters can only be changed by the SYS user.Answer：DFG⼆十⼆一.Backup73. Table EMP resides in the USERS tablespace. Examine this command:SQL> DROP TABLE emp PURGE;Which two methods would you use to recover EMP?A) Flashback Table.B) re-creating the table and reinserting the rows.C) performing a tablespace point in time recovery of USERS.D) Flashback Transaction Backout.E) Flashback Drop.Answer：BC实用文档74. Which two are true about consistent database backups?A) They can only be taken by using RMAN commands.B) They can only be taken by using RMAN when the database is in MOUNT state.C) They can only be taken when a RECOVERY CATALOG is used.D) They can only be taken if the database is in ARCHIVELOG mode.E) They can only be taken if a NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.Answer：BE75. Which four are true about consistent database backups?A) They can only be taken using O/S utilities if the database is in mount state.B) They can only be taken using RMAN when the database is in mount state.C) They can be taken using O/S utilities.D) They can only be taken using RMAN when the database instance is shut down.E) They can be taken if the database is in archivelog mode.F) They can be taken by using rman commands.G) They can be taken if the database is in noarchivelog mode. Answer：CEFG76. Which three can be used to schedule automated backups of the database?A) a cron jobB) Enterprise Manager Database ControlC) DBMS_SCHEDULERD) DBMS_BACKUP_RESTOREE) expdp F) RMANAnswer：ABC77. Which four can be used to schedule automated backups of an Oracle database?A) data GuardB) DBMS_JOBC) Enterprise ManagerD) anacron jobsE) cron jobsF) Automatic Storage Management (ASM)Answer：BCDE78. Which two tools or utilities can be used to configure and schedule on- line database backups to run automatically?A) the RMAN command line utilityB) SQL*PLUSC) Enterprise Manager Cloud ControlD) The Database Configuration Assistant(DBCA)E) the DBMS_SCHEDULER packageAnswer：CE79. Your database is open in ARCHIVELOG mode.LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takesplace. No alternative or optional archive destinations are defined.What is the outcome?A) All active sessions hang until the database administrator (DBA)makes space available in the FRAB) B) No archivelogs are generated.C) The archivelog entries are made in the diagnostic destination andwhen space is available, newarchivelog are generated.D) All active sessions are disconnected and their transactions rolledback.E) Obsolete backups are automatically deleted and new archivelogs aregenerated.Answer：E（验证过）80. In which two cases is a consistent database backup created ?A) when the RMAN BACKUP AS COPY command is used while the database is openB) when the RMAN BACKUP command is used while the database is OPEN READ ONLYC) when the RMAN BACKUP AS COPY command is used while the database is OPEN RESTRICTEDD) when the RMAN BACKUP command is used while the database is MOUNTEDE) when O/S commands are used to copy database files after a database instance is shut down normallyAnswer：DE81. Which command is used to display files that no longer conform to the backup retention policy?A) LIST EXPIRED BACKUPB) REPORT OBSOLETE.C) SHOW DATAFILE BACKUP COPIES.D) CROSSCHECK BACKUP.Answer：B⼆十⼆Recover82. Which two affect the time taken for instance recovery?A) Size of archivelogs.B) Size of existing RMAN backupsets.C) FAST_START_MTTR_TARGET value.D) Size of UNDO tablespace.E) UNDO_RETENTION value.F) Size of redo logs.Answer：CF⼆十三.Tablespace83. Which two are true about space management in tablespaces?A) Free lists are used for managing free space for segments in locallymanaged tablespaces.B) Locally managed tablespaces track adjacent free space automaticallyby using bitmaps.C) Locally managed tablespaces have either ASSM or manual segmentspace management (MSSM),and all the segments in these tablespace are managed one way or the other.D) Extent allocation must be specified as automatic for automaticsegment space management (ASSM) tablespaces.E) ASSM tablespaces prevent row chaining.Answer：BC84. Which four statements are true about tablespace space management?A) ASSM prevents row chaining.B) Locally managed tablespaces track adjacent free space using bitmaps.C) Locally managed tablespaces can manage segments with automatic segment space management(ASSM).D) Locally managed tablespaces track adjacent allocated space using bitmaps.E) ASSM prevents row migration.F) Locally managed tablespaces can manage segments with freelistsG) Bigfile tablespaces can be dictionary or locally managed.Answer：BCFG85. Your database is configured in archivelog mode. The USERS01 tablespace is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?A) either the NORMAL or the TEMPORARY clauseB) only the TEMPORARY clauseC) only the NORMAL clauseD) either the NORMAL or the IMMEDIATE clauseE) only the IMMEDIATE clause.Answer：C（验证过）86. which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database instance stores undo data in the SYSTEM tablespace if no undo tablespace exists.C) A database instance hangs if the SYSAUX tablespace becomes unavailable.D) A database can contain only a single temporary tablespace.E) A database with a locally managed SYSTEM tablespace can have dictionary-managed user tablespaces.Answer：AE87. which four statements are true about tablespaces?A) A single instance database can have multiple temp tablespaces created.B) A single instance database can have multiple temp tablespace used simultaneously by the instance. C) The SYSAUX tablespace can be altered OFFLINE.D) A single instance database can have multiple undo tablespaces used simultaneously by the instance.E) The SYSTEM tablespace can be altered OFFLINE FOR RECOVERY.F) A single instance database can have multiple undo tablespace created.G) The SYSAUX tablespace can be altered READ ONLY.(验证过）Answer：ABCF88. Which is true about enabling AUTOEXTEND for data files?A) It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablesapce have autoextend enabled.B) It can be enabled only for data files in non-OMF tablespaces.C) It can be enabled for data files only in bigfile tablespaces.D) It can be enabled for data files only in smallfile tablespaces.E) It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.Answer：E89. Which is true about the SYSTEM and SYSAUX tablespaces？A) Both tablespaces must be online for a database to be accessible .B) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace can not.C) Only the SYSTEM tablespace contains data dictionary tables.D) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.Answer：C90. Which three tablespace can be set to OFFLINE IMMEDIATE in an Oracle Database？A) The SYSTEM tablespace.B) The Undo tablespace currently used by the instance.C) A tablespace containing an RMAN CATALOG.D) A tablespace containing an Enterprise Manager repository.E) The SYSAUX tablespace （除非启用了介质恢复, 否则不允许立即脱机）Answer：CDE91. Examine these facts about a database.1. The database default tabpespace is USERS.2. DEFERRED_SEGMENT_CREATION is TRUE.3. The default tablespace of USER1 is tbs1.4. USER1 has only these privileges:• CREATE SESSION• CREATE TABLE• UNLIMITED quota on tbs1Examine these commands executed by USER1:SQL> CREATE TABLE emp (eno NUMBER, ename VARCHAR2(20)) TABLESPACE TBS1;Table created.SQL> CREATE INDEX emp_inx ON emo(eno) TABLESPACE USERS;Index created.SQL> INSERT INTO emp VALUES (NULL,’Alan’);What will be the outcome of the INSERT operation and why?A) It will fail because an indexed column cannot have NULL values.B) A row will be inserted into EMP and an index entry will be made into EMP_IDX.C) It will fail because USER1 has no quota on USERS.实用文档D) A row will be inserted into EMP and an index entry will be inserted into a virtualcolumn of EMP because USER1 has no quota an USERS.E) A row will be inserted into EMP but no index entry will be made into EXP_IDX.Answer：C实用文档92. SCOTT.CUST is in the SALES tablespace. SCOTT executes these commands:SQL> INSERT INTO cost VALUES(101,’JACK’); 1 row created.SQL> INSERT INTO cost VALUES(102,’SMITH’); 1 row created.AS a DBA, do this in a different session: ALTER TABLESPACE sales READ ONLY; Which two statements are true?A) Scott’s transaction is automatically rolled back and the tablespace becomes read-only.B) The ALTER TABLESPACE command fails.C) Scott’s transaction is automatically committed and the tablespace becomes read-only.D) The command hangs and the hang will end if the transaction is committed.E) The command hangs and the hang will end if the transaction is rolled back. Answer：DE （已验证。