OCP认证052考试最新考试题库解析-20180727

跨境电商人才初级认证考试题库（含答案）一、单选题1．产品的图片、标题等产品重要信息高度重复,被认定为构成( )的作弊行为A、重复发布B、产品侵权C、重复铺货D、类目错放参考答案：C2．西联汇款属于以下哪种交易模式？A、新型交易模式B、传统交易模式C、以上都不对参考答案：B3．当有1000元让步空间时,下列让步策略描述正确的是？A、所有答案都不对B、可以使用500,200,100,50均匀的让步策略C、可以使用250,250,250,250 平均幅度的让步策略D、可以使用600,400,0,0大跨度的让步策略参考答案：B4．买家搜索词是有（）个字符限制的A、40B、50C、60D、70参考答案：B5．在T/T付款方式下,单据是通过（）传递的A、卖方向买方银行B、卖方向买方货代C、卖方直接向买方D、买方向卖方银行参考答案：C6．下列关于销售现状发生变化中“双赢”描述正确的是？答案选项 :CA 单纯的经济利益上的盈利B 单纯的心理上的双赢C保证经济利益的同时满足心理上的愉悦 D 所有答案都不对7．当有1000元让步空间时，下列让步策略描述正确的是？答案选项: BA可以使用250,250,250,250 平均幅度的让步策略B可以使用500,200,100,50均匀的让步策略C可以使用600,400,0,0大跨度的让步策略D所有答案都不对8．如下关于俄罗斯市场相关内容描述错误的是？答案选项: BA 俄罗斯人很注重仪表，很爱干净B Google搜索引擎在俄罗斯拥有很高的市场份额，都多俄罗斯人都在用C 俄罗斯人善饮伏特加酒D 在俄罗斯上网费用较贵9．欧洲大部分人的宗教信仰是？答案选项: AA 基督教 B佛教 C伊斯兰教 D天主教10．如下关于阿拉伯国际风俗习惯描述错误的是？答案选项:见面握手时间越长说明关系越好见面拥抱时间越长说明关系越好见面拥抱时间越短说明关系越好阿拉伯人都信任伊斯兰教11．关于客户等级,下列说法正确的是？A、客户等级一旦形成,无法改动B、客户等级是系统根据客户质量自动评分的C、以上说法都不对D、客户等级分1-5星参考答案：D12．在P4P中，关键词共分为几个级别星级？答案选项:456713．如果您的一个客户的公司网址是,为了找到更多的客户,你可以尝试以下哪个技巧？A、intitle:B、site:C、inur:D、related:参考答案：D14．下列哪一个不满足可以推广的产品的要求A、多语言产品B、公共产品C、已通过网站审核的产品D、未在其他推广计划中添加过的产品参考答案：A15．关于中大买家采购服务给供应商带来的影响,下列说法错误的是？A、公开频道不符合报价条件的供应商点击报价后,会有对应的文案提示B、中大买家发的RFQ,可以有20个报价席位；符合报价的供应商完成报价后,审核时间比普通报价略长C、符合报价资格的供应商收到的通知信会提示是来自中大买家的采购需求D、中大买家采购服务不利于中小企业的外贸发展参考答案：D16．通过以下哪种方法,可以在国际站找到买家的求购信息?A、BUYERSB、SUPPLIERS参考答案：A17．对于有回复未成交的客户,该如何跟进？A、已报价情况B、特价或有新产品时及时通知C、定期关怀D、其他产品的推介参考答案：B18．金砖5国是指哪5个国家？A、中国、欧洲、美国、德国、法国B、中国、印尼、俄罗斯、南非、巴西C、中国、泰国、俄罗斯、日本、巴西D、中国、印度、俄罗斯、南非、巴西参考答案：D19．邮政的航空大包航程一般需要多久？A、2周B、1周C、4周D、3周参考答案：A20．如下关于非洲市场相关内容描述错误的是？答案选项: DA非洲35%-60%的人口仍在贫困线上挣扎，收入较低B非洲5%-15%的人口通常来自世界各地，收入较高C非洲25%-40%的人口拥有较强的刚需，生活不算穷也不富裕D非洲每年进口到国内的货物量很小21．欧洲大部分人的宗教信仰是？答案选项:基督教佛教伊斯兰教天主教22．As you are wear and children’s clothes, we are writing to enquire whether you are willing to _______with us.A、in the line of, relateB、specialized in, enter into business relation参考答案：B23．一份完整的报价单包含A、价格,贸易术语,产品名称B、价格,贸易术语,产品名称,规格,包装C、价格,贸易术语,产品名称,规格,包装,MOQ ,付款方式D、价格,贸易术语,产品名称,规格,包装,MOQ ,付款方式,报价有效期参考答案：D24．如下关于绝大多数中东阿拉伯客户特点描述错误的是？答案选项:性格急躁交货期限卡的紧样品跟成品一致性要求高不喜欢接收各种有地方特色的小礼物25．商标权俗称：A、牌子B、牌坊参考答案：A26．我国出口商品检验时,对产地和报关地相一致的出境货物,经检验检疫合格的,出入境检验检疫局出具A、《出境货物通关单》B、《出境货物不合格通知单》C、《出境货物换证凭单》D、《出境货物换证凭条》参考答案：A27．在信用证项下的制单结汇中,如发现单证不符,且不能及时更正时,进出口企业可以选择的处理方法是A、电提B、定期结汇C、押汇D、收妥结汇参考答案：A28．FOB和CFR最大的区别主要在于？A、是否由卖方支付海运费。

1、在Oracle数据库中，哪个命令用于创建新的表空间？A、CREATE DATABASEB、CREATE SCHEMAC、CREATE TABLESPACED、CREATE USER（答案：C）2、关于OCP（Oracle Certified Professional）认证，以下哪项描述是错误的？A、OCP认证是Oracle公司提供的专业级认证B、OCP认证需要通过相应的考试才能获得C、OCP认证只需通过理论考试，无需实际操作经验D、OCP认证有助于提升数据库管理员的职业竞争力（答案：C）3、在SQL语句中，哪个关键字用于选择满足特定条件的记录？A、INSERTB、UPDATEC、DELETED、SELECT（答案：D）4、Oracle数据库中的redo log文件主要作用是？A、记录数据库的所有变更操作B、用于数据库的恢复和重建C、记录用户的登录信息D、存储数据库的临时数据（答案：A）5、以下哪项不是Oracle数据库管理员（DBA）的职责？A、数据库的安装与配置B、数据库的性能调优C、数据库的安全管理D、应用程序的开发与维护（答案：D）6、在Oracle数据库中，哪个工具通常用于图形化管理数据库？A、SQL*PlusB、Oracle Enterprise ManagerC、RMAND、Data Pump（答案：B）7、关于Oracle数据库的归档日志模式，以下哪项描述是正确的？A、归档日志模式仅适用于大型数据库B、归档日志模式可以提高数据库的性能C、归档日志模式可以保护数据库免受介质故障的影响D、归档日志模式会显著降低数据库的存储空间（答案：C）8、在Oracle数据库中，哪个视图可以显示当前会话的详细信息？A、DBA_USERSB、V$SESSIONC、ALL_TABLESD、USER_PRIVILEGES（答案：B）。

A、错放类目将导致买家流失
B、产品类目选择准确是第一步
C、排名由产品的类目决定
D、用于产品的归类
参考答案：C
44．以下关于PI的说法错误的是
A、形式发票可以当做销售合同
B、买方可以用形式发票申请外汇许可、进口许可和开立信用证
C、形式发票是一种数量化的报价
D、形式发票没有法律效力
参考答案：D
45．在什么情况下,物权危险性最高,如买家与船公司无提货单凭证提货？
参考答案：ACDE
58．如下描述中,正确的是？
A、CFR=成本+运费B、CFR=成本+运费+保险费C、CIF=成本+运费D、CIF=成本+运费+保险费
参考答案：AD
59．产品详情中至少需要由哪些要素组成？
A、图片B、视频C、表格D、文字
参考答案：ACD
60．在阿里巴巴国际站上发布产品时，通过哪些模块的描述可以提高产品专业度？
A、提单后三天
B、提单后一个月
C、提单当天
D、即提即通知
参考答案：A
49．自2009年1月1日起,我国一般纳税人在进口设备作为固定资产时所发生的（）,可从销项税额中抵扣
A、进口环节消费税
B、进口关税
C、进口环节增值税和进口环节消费税
D、进口环节增值税
参考答案：D
50．详细描述可使用自带功能插入表格和图片,可最多上传（）张图片
C、往来磋商、签订合同、生产备货、装船、制单交单、结汇退税
D、往来磋商、签订合同、生产备货、报关前准备、报关、装船、结汇退税
参考答案：A
34．L/C与托收相结合的支付方式,其全套货运单据应
A、随信用证项下的汇票
B、随托收项下的汇票

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工具支持压缩和加密功能，但是加密的时候需要用到密码。

百度初级认证考核试题题库及答案一、选择题（每题5分，共25题，满分125分）1. 以下哪项不是百度搜索引擎的核心算法？（）A. 网页排名算法B. 词频算法C. 向量空间模型D. 机器学习算法2. 百度关键词规划师工具中，以下哪项功能可以帮助我们找到适合我们广告的关键词？（）A. 关键词建议B. 关键词竞争对手分析C. 关键词搜索量分析D. 关键词广告效果预测3. 百度推广中，以下哪个功能可以帮助我们创建和管理我们的广告？（）A. 推广计划B. 推广创意C. 推广关键词D. 推广效果分析4. 在百度推广中，以下哪个功能可以帮助我们了解我们的广告效果？（）A. 推广计划B. 推广创意C. 推广关键词D. 推广效果分析5. 以下哪个不是百度云产品的核心应用？（）A. 百度智能云B. 百度大数据C. 百度AID. 百度网盘6. 以下哪个不是百度AI的核心技术？（）A. 自然语言处理B. 计算机视觉C. 语音识别D. 区块链技术7. 以下哪个不是百度大数据的核心应用？（）A. 百度统计B. 百度云分析C. 百度指数D. 百度地图大数据8. 以下哪个不是百度搜索引擎的优点？（）A. 搜索结果精准B. 广告投放效果好C. 拥有海量的数据D. 能够实时更新网页排名9. 以下哪个不是百度云产品的优点？（）A. 安全稳定B. 高效便捷C. 价格实惠D. 支持定制化开发10. 以下哪个不是百度AI的优点？（）A. 准确率高B. 响应速度快C. 易于部署D. 完全免费11. 以下哪个不是百度大数据的优点？（）A. 数据量大B. 数据更新快C. 数据分析精准D. 完全免费12. 以下哪个不是百度搜索引擎的缺点？（）A. 搜索结果广告太多B. 搜索结果不够精准C. 数据更新不够及时D. 需要付费才能使用高级功能13. 以下哪个不是百度云产品的缺点？（）A. 需要付费才能使用B. 部署和使用有一定门槛C. 部分产品价格较高D. 稳定性略有不足14. 以下哪个不是百度AI的缺点？（）A. 需要专业人员开发和维护B. 部分技术应用成本较高C. 需要大量数据训练D. 完全免费15. 以下哪个不是百度大数据的缺点？（）A. 数据隐私和安全问题B. 数据分析需要专业技能C. 部分服务价格较高D. 完全免费16. 以下哪个不是百度搜索引擎的工作原理？（）A. 爬取网页B. 索引建立C. 网页排名算法D. 关键词广告投放17. 以下哪个不是百度云产品的工作原理？（）A. 云计算B. 大数据处理C. AI技术应用D. 网页排名算法18. 以下哪个不是百度AI的工作原理？（）A. 机器学习B. 深度学习C. 自然语言处理D. 网页排名算法19. 以下哪个不是百度大数据的工作原理？（）A. 数据采集B. 数据存储C. 数据分析D. 网页排名算法20. 以下哪个不是百度搜索引擎的优势？（）A. 搜索结果丰富B. 搜索速度快C. 支持多种语言搜索D. 能够实时更新网页排名21. 以下哪个不是百度云产品的优势？（）A. 安全稳定B. 高效便捷C. 价格实惠D. 支持定制化开发22. 以下哪个不是百度AI的优势？（）A. 准确率高B. 响应速度快C. 易于部署D. 完全免费23. 以下哪个不是百度大数据的优势？（）A. 数据量大B. 数据更新快C. 数据分析精准D. 完全免费24. 以下哪个不是百度搜索引擎的局限性？（）A. 搜索结果广告太多B. 搜索结果不够精准C. 数据更新不够及时D. 需要付费才能使用高级功能25. 以下哪个不是百度云产品的局限性？（）A. 需要付费才能使用B. 部署和使用有一定门槛C. 部分产品价格较高D. 稳定性略有不足二、判断题（每题5分，共20题，满分100分）1. 百度搜索引擎的核心算法包括网页排名算法、词频算法、向量空间模型和机器学习算法。

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备份时没有发生检查点，无需更改数据文件头部，所以可以备份数据库。

R O
G 家 U 专 U C 航 领 训 培 E L C A
2、In which state must a database be to enable ARCHIVELOG? • A. NOMOUNT • B. OPEN in RESTRICTED mode • C. OPEN in READ WRITE mode • D. MOUNT • E. OPEN in READ ONLY mode • Correct Answer: D
R O
G 家 U 专 U C 航 领 最新15道题 训 培 E L C A
052题库解析
1、Which two can be configured with profiles?
• • • • • • • A. tablespace quotas for users B. the time after which an idle session is terminated C. default tablespace for users D. default object privileges for users E. session CPU limits F. default system privileges for users Correct Answer: BE
R O
G 家 U 专 U C 航 领 训 培 E L C A
4、Which three are true about Oracle database security?
• • • • • • A. By default, SYSDBA connections have access to all schema objects. B. SYSDBA connections are always subject to mandatory auditing. C. By default, SYSOPER connections have access to the data dictionary. D. Fine Grained Auditing can be used to restrict access to sensitive data. E. SYSOPER connections are always subject to mandatory auditing. F. Mandatory auditing is enabled by setting AUDIT_SYS OPERATIONS to TRUE. • Correct Answer: ABE

ocp 题库解析OCP（Open Closed Principle）是面向对象设计中的一个重要原则，它要求软件实体（类、模块、函数等）应该对扩展开放，对修改关闭。

也就是说，一个软件实体应该是可以扩展的，而不需要修改。

OCP 题库解析指的是对 OCP 原则相关题目的解析和讨论。

首先，我们来看一些关于 OCP 原则的基本概念。

OCP 原则要求我们设计软件实体时要考虑未来的扩展性，避免对现有代码进行修改，而是通过扩展现有代码来实现新功能。

这通常可以通过使用抽象类、接口、多态等方式来实现。

例如，我们可以定义一个接口或抽象类，然后针对不同的需求编写不同的实现类，这样在新增功能时只需要新增实现类，而不需要修改原有的代码。

在解析 OCP 题库时，我们需要深入理解 OCP 原则，并且掌握如何在实际代码中应用这一原则。

我们可以从以下几个方面来分析和解答相关题目：1. OCP 原则的含义和作用，首先我们可以解释 OCP 原则的概念，以及它对软件设计的重要性和作用。

我们可以举例说明采用OCP 原则的优点，以及不遵守该原则可能带来的问题。

2. 如何设计满足 OCP 原则的代码，我们可以讨论如何设计满足 OCP 原则的代码结构，比如通过接口、抽象类、依赖倒置等方式来实现代码的可扩展性和灵活性。

可以举例说明如何利用设计模式来实现 OCP 原则，比如策略模式、装饰者模式等。

3. 题目分析和解答，针对具体的 OCP 题目，我们可以逐个进行分析和解答，包括题目中涉及的代码设计、扩展需求、可能的修改方式等。

我们可以通过具体的例子来说明如何设计满足 OCP 原则的代码，并且讨论每种设计方式的优缺点。

总的来说，解析 OCP 题库需要对 OCP 原则有深入的理解，同时需要具备丰富的实际编程经验和设计能力。

通过深入的讨论和分析，我们可以帮助学习者更好地掌握和应用 OCP 原则，从而提高代码的质量和可维护性。

7、 You are planning a software installation for both Oracle Database 11g Release 1 and Release 2. You plan to have at lease one database for each release managed by Grid Infrastructure for a Standalone Server. Which three are true in this scenario? • A) Oracle 11g Release 1 databases must be managed by Grid Infrastructure 11g Release 1. • B) Both databases can be managed by Grid Infrastructure 11g Release 2. • C) Both Oracle versions and Grid Infrastructure can be owned by the same O/S account. • D) Gird Infrastructure must be installed before both Oracle Database versions. • E) Each version of the database may be managed by a separate version of Grid Infrastructure. • F) Both Oracle versions and Grid Infrastructure can be installed under the same ORCALE_BASE. • Answer:ADE •

52题库解析OCP 考试 052 最新考试题库原题-9-20210803十三 .Audit32.YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME. Which typeofauditingmust youuse?A)standardauditing B)mandatoryauditing C)value-basedauditingD)?ne-grainedauditingAnswer ：DA)Auditingis activeonlywhenthedatabaseis OPEN.B)Auditrecords arealwaysstored inthedatabase.C)Auditof theuseofsystemprivilegescanbeenabledfor individual databaseusers.D)DDLstatements canbe auditedwhentheyfailtoexecute.E)AllOracleauditingoperationsoccurbydefault.F)DMLstatements canbeauditedwhentheyexecutesuccessfully. Answer ：CDFA)DMLstatementscanbeauditedwhentheyfailtoexecuteB)Select statementscanbeauditedwhentheyexecutesuccessfully.C)AllOracle auditingoperationsoccurby default. D) NoOracleauditingoperationsoccurby default.E)DDLstatements canbe auditedwhentheyfailtoexecute.F)Someauditingis activebeforethedatabaseis open.G)Auditrecordsareneverstored inthe database.H)Auditrecordsarealwaysstored inthedatabase.Answer ：ABEFSQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename ='audit_trail';NAMEVALUE----------------------------------------audit_trailDBSQL>auditall onemp; Auditsucceeded.。

高考052题库解析OCP考试052最新考试题库原题-2-20180518题库新特点：●更加灵活，题库的顺序与考试时的顺序每场都在变化●更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案●不断有新的考题出现，目前最新已经更新到130道题1、.Whichtwoaretrueaboutthe Archive (AR)processes? ❑A)Theyautomaticallydelete obsoletearchivelogstomake spacefornewarchivelogs. ❑B)TheyareusedduringInstancerecovery.❑C)Theyarchiveredodirectly fromthe redologbuffer. ❑D)Theyareenabled only when thedatabaseIsInARCHTVELOC mode.❑E)Theycreatearchivelogs afterevery logswitch.•Answer:DE2、Which twoaretrueaboutOptimizerStatistics?❑A)Theydo notpersist acrossInstancerestarts.❑B)TheyareautomaticallyupdatedwhenDDL statements execute.❑C)TheyaregatheredbytheManageabilityMonitor(MMON) backgroundprocess.❑D)Theycanbe gatheredbyexecutingthe PL/SQL procedures in theDBMS_STATSpackage.❑E)Theycanbe used todeterminethe eventsonwhicha database instancewaited.❑F)TheyprovideInformationtothe Optimizer sothatitcan determine optimal executionplans forSQLstatements.•Answer:DF3、Which structurecanspan multipledatafiles?❑A)a permanenttablespace❑B)a bigfiletablespace❑C)a temporarytablespace❑D)asegment❑E)an extent•Answer:ACD4、Forwhichrequirementshouldyouconfiguresharedservers?❑A)acmodatingan increasingnumberof userswhorunshort-duration,infrequentqueries in an OLTPenvironmentwithlimitedmemory❑B)acmodatinganincreasingnumberof userswhorun analyticalqueries in aDSS environmentwithlimitedmemory❑C)submittingbackupjobsatregular,24-hourIntervalsin an OLTPenvironmentwith limitedmemory❑D)performingbulk-load operations in a DSS environmentwith limitedmemory❑E)usingRecovery Manager (RMAN)torecoveradatabase•Answer:A5、Which twoaffectthetimetakenforinstancerecovery?❑A)sizeof redologs❑B)sizeof UNDO tablespace❑C)FAST_START_MTTR_TARGETvalue❑D)sizeofarchivelogs ❑E) sizeof existingRMANbackupsets❑F)UNDO_RETENTIONvalue•Answer:AC6、You areinstallingOracle Grid Infrastructurebyusingthe OracleUniversalInstaller(OUI).You selectthe "Installand ConfigureGrid InfrastructureforaStandalone Server" option.Which taskis performedbyOUIaspartof this installation? ❑A)creationand configuration of Enterprise Manager Cloud Control onthe server❑B)creationof privileged operating systemgroupsthatare used forOSauthentication❑C)creationof a generalpurpose database❑D)creationof an ASMdisk group andregistrationof ASM ponentswithOracleRestart•Answer:D7、Which istrue about externaltables?❑A)TheORACLE_DATAPUMPaccessdrivercanbe used towrite datatoexternaltables.❑B)Segments areallocatedforexternaltables.❑C)Theydonotsupportpartitioning.❑D)TheymayhaveIndexes. ❑E)DML operationsmay be performedonexternaltables.•Answer:C8、Which twoaretrueaboutthe FastRecoveryArea(FRA)?❑A)Itshould be largerthan thedatabase.❑B)SpacemanagementIn theFRAIsInfluenced bythe database backupretentionpolicy.❑C)A databasemustbe in ARCHIVELOGmodetousethe FRA.❑D)Itmust resideonthe samefile systemas thedatabasedata files.❑E)Onlyconsistentbackupscan be storedin the FRA.•Answer:AB9、Which istrue abouttheAutomaticDiagnosticRepository (ADR)? ❑A)Itincludesdiagnostic dataforcriticalerrorsforeachserver and backgroundprocess.❑B)Itslocationis alwayssetbytheORACLE_BASEvariable. ❑C)Itis usedonlyif the DIAGNOSTIC_DESTparameter is manuallyconfigured.❑D)Itonly containsthe alertlogand trace files forbackground processes.•Answer:A10、Which twoaretrueaboutconsistentdatabase backups?❑A)Theycanonly be taken when a RECOVERYCATALOGis used.❑B)Theycanonly be taken if the database Isin ARCHIVELOG mode.❑C)Theycanonly be taken Ifshutdown NORMAL, TRANSACTIONAL,or IMMEDIATEshutdownhas beenperformedand the backupis takenbeforethe database is reopened.❑D)Theycanonlybe takenbyusing RMANmands. ❑E)Theycanonlybe takenbyusing RMANwhen thedatabaseis inMOUNTstate.•Answer:CE11、Which threearetrue aboutUNDOdata?•❑A)Itis used torollbackfailedtransactions.•❑B)Itis used torewind adatabasebyusing FLASHBACK DATABASE.•❑C)Itisusedtorecoverdroppedtables byusing FLASHBACK TABLE…TOBEFOREDROP.•❑D)Itis used toenable ROLLBACKstatementstoroll back unmittedupdates.•❑E)Itis used toprovidereadconsistency.•❑F)Itis used duringonlinebackupstoguaranteetheir consistency.•Answer:ADE12、Which twotypes ofInformationcanbe foundinthe alert log?•❑A)instancerecoverydetails•❑B)a recordof allDDL statementsperformed bynon-DBA users•❑C)a recordofall actionsperformed bySYSand SYSTEM•❑D)criticalerrorsencounteredbybackgroundprocesses•❑E)valuesofallInitialization parameterswheneveran InstanceIs restarted•Answer:AD13、Which twoaretrueaboutAWRsnapshots?•❑A)TheyarestoredIn theSYSAUXtablespace.•❑B)Theyarenot generatedif STATISTICS_LEVELIssetto TYPICAL.•❑C)Theycanbe modified byusing DMLs.•❑D)Theycanbe retained forever.•❑E)Theyarealwayscreatedautomatically.•Answer:AD14、Which mandis used todisplayfiles thatno longer conformtothebackup retentionpolicy? •❑A)REPORTOBSOLETE•❑B)SHOWDATAFILEBACKUPCOPIES•❑C)CROSSCHECKBACKUP•❑D)LISTEXPIREDBACKUP•Answer:A•15、Which twoaretrueaboutspacemanagementin tablespaces?•❑A)Locally managed tablespaceshaveeitherASSMormanualsegmentspacemanag ement(MSSM),and allthesegmentsin thesetablespacesaremanagedonewayortheother.•❑B)Locallymanaged tablespacestrackadjacentfreespace automaticallybyusing bitmaps.•❑C)Extentallocationmustbe specifiedas automaticfor automaticsegmentspacemanagement(ASSM)tablespaces.•❑D)ASSMtablespacespreventrowchaining.•❑E)Freelistsareusedformanagingfreespaceforsegments高考in locallymanagedtablespaces. •Answer:AB。

Oracle_OCP11g考试题库1.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 valueAnswer: C2.View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.) A. SELECT promo_id, DECODE (NVL(promo_cost,0), promo_cost,promo_cost * 0.25, 100) "Discount"FROM promotions;B. SELECT promo_id, DECODE (promo_cost, 10000,DECODE (promo_category, 'G1', promo_cost *.25, NULL), NULL) "Catcost"FROM promotions;C SELECT promo_id, DECODE(NULLIF(promo_cost, 10000), NULL,promo_cost*.25, 'N/A') "Catcost"FROM promotions;D. SELECTpromo_id,DECODE(promo_cost, >10000, 'High',<10000, 'Low')"Range"FROM promotions;Answer: A, B3.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cust _last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST LAST NAME is Roberts and CREDIT LIMIT is 600? A. INSERT INTO orders VALUES (1, '10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust last name= 'Roberts' ANDcredit_limit=600), 1000);B. INSERT INTO orders (order_id,order_date,order_mode,(SELECT customer_idFROM customersWHERE cust last name= 'Roberts' ANDcredit_limit=600),order_total)VALUES(1, '10-mar-2007', 'direct', &&customer_id, 1000); C. INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_totalFROM orders o, customers cWHERE o.customer_id=c.customer_idAND c.cust_last_name='Roberts' ANDc.credit_limit=600 |VALUES (1,'10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name= 'Roberts' AND credit_limit=600 ), 1000);D. INSERT INTO orders (order_id,order_date,order_mode,(SELECT customer_idFROM customersWHERE cust_last_name= 'Roberts' ANDcredit_limit=600),order_total)VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);Answer: A4.View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statementSQL> SELECT cust_city, COUNT(cust_last_name)FROM customersWHERE cust_credit_limit > 1000GROUP BY cust_cityHAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000;Which statement is true regarding the outcome of the above query? A. It executes successfullyB. It returns an error because the BETWEEN operator cannot be usedin the HAVINGclauseC. It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statementD. It returns an error because WHERE and HAVING clauses cannot be used to applyconditions on the same columnAnswer: A5.View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:Which statement is true regarding the above two SQL statements? A. statement 1 gives an error, statement 2 executes successfully B. statement 2 gives an error, statement 1 executes successfully C. statement 1 and statement 2 execute successfully and give the same output D. statement 1 and statement 2 execute successfully and give a different outputAnswer: D6.You created an ORDERS table with the following description:You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column. Which statement is true in this scenario?A. You cannot have two constraints on one columnB. You cannot add a primary key constraint if data exists in the columnC. The primary key constraint can be created only at the time of table creationD. You can add the primary key constraint even if data exists, provided that there are no duplicate valuesAnswer: D7.When does a transaction complete? (Choose all that apply.)A. when a DELETE statement is executedB. when a ROLLBACK command is executedC. when a PL/SQL anonymous block is executedD. when a data definition language (DDL) statement is executedE. when a TRUNCATE statement is executed after the pending transact ion Answer: B, D, E8.You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character'a' in the second last position Which query would give the required output?A. SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e') <>0 ANDSUBSTR(cust_first_name, -2, l) ='a';B. SELECT cust first nameFROM customersWHERE INSTR(cust_first_name, 'e') <>" ANDSUBSTR(cust_first_name, -2, l)='a';C. SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e') IS NOT NULL ANDSUBSTR(cust_first_name, l, -2)='a';D. SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e')<>0 ANDSUBSTR(cust_first_name, LENGTH(cust_first_name),-2)='a';Answer: A9.The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?SELECT * FROM ord;A. CREATE SYNONYM ord FOR orders; This command is issued by OEB. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OEC. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administratorD. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issuedby the database administratorAnswer: D10.View the Exhibit and examine the structure of the PRODUCTS table You need to generate a report in the following format:Which two queries would give the required output? (Choose two.) A. SELECT prod_name || q"'s category is ' || prod_category CATEGORIES FROM products;B. SELECT prod_name || q'['s]'category is' || prod_category CATEGORIESFROM products;C. SELECT prod_name || q'\'s\' category is '|| prod_category CATEGORIESFROM products;D. SELECT prod_name ||q'<'s>'|| 'category is ' || prod_category CATEGORIESFROM products;Answer: C, D11.Which statement is true regarding the INTERSECT operator?A. It ignores NULL valuesB. Reversing the order of the intersected tables alters the resultC. The names of columns in all SELECT statements must be identicalD. The number of columns and data types must be identical for all SELECT statements in the queryAnswer: D12.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)A. Both USING and ON clauses can be used for equijoins and nonequijoinsB. A maximum of one pair of columns can be joined between two tables using the ON clauseC. The ON clause can be used to join tables on columns that have different names but compatible data typesD. The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clauseAnswer: C, D13.Examine the structure of the PROGRAMS tableWhich two SQL statements would execute successfully? (Choose two.) A. SELECT NVL(ADD_MONTHS(END_DATE,l),SYSDATE)FROM programs;B. SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE))FROM programs;C. SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing')FROM programs;D. SELECTNVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing')FROM programs;Answer: A, D14.Where can subqueries be used? (Choose all that apply.) A. fieldnames in the SELECT statementB. the FROM clause in the SELECT statementC. the HAVING clause in the SELECT statementD. the GROUP BY clause in the SELECT statementE. the WHERE clausein only the SELECT statement F. the WHERE clause in SELECT as well asall DML statementsAnswer: A, B, C, F15.View the Exhibits and examine the structures of the PRODUCTS, SAL ES, andCUSTOMERS tablesYou need to generate a report that gives details of the customer'slast name, name ofthe product, and the quantity sold for all customers in 'Tokyo' Which two queries give the required result? (Choose two.) A. SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM sales s JOIN products pUSING(prod_id)JOIN customers cB. SELECT c.cust_last_name, p.prod_name, s.quantity_soldFROM products p JOIN sales s JOIN customers cON(p.prod_id=s.prod_id)ON(s.cust_id=c.cust_id)WHERE c.cust_city='Tokyo';C. SELECT c.cust_last_name, p.prod_name, s.quantity_soldFROM products p JOIN sales sON(p.prod_id=s.prod_id)JOIN customers cON(s.cust_id=c.cust_id)AND c.cust_city='Tokyo';D. SELECT c.cust_id, c.cust_last_name, p.prod_id, p.prod_name, s.quantity_soldFROM products p JOIN sales sUSING(prod_id)JOIN customers cUSING(cust_id)WHERE c.cust_city='Tokyo';Answer: A, C16.View the Exhibit and evaluate the structure and data in theCUST_STATUS table You issue the following SQL statementSQL> SELECT custno, NVL2(NULLIF(amt_spent,credit_limit), 0, 1000) "BONUS"FROM cust_status;Which statement is true regarding the execution of the above query?A. It produces an error because the AMT_SPENT column contains a null valueB. It displays a bonus of 1000forall customers whose AMT_SPENT is less than CREDIT_LIMITC. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is nullD. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 functionAnswer: C17.Examine the structure and data in the PRICE LIST tableYou 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(prod_price* .25, '$99,999.99')FROM PRICE_LIST;B. SELECT TO_CHAR(TO_NUMBER(prod_price)* .25, '$99,999.00')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: C18.You need to generate a list of all customer last names with their credit limits from theCUSTOMERS table. Those customers who do not have a credit limitshould appear last in the list.Which two queries would achieve the required result? (Choose two.) A. SELECT cust_last_name, cust_credit_limitFROM customersORDER BY cust_credit_limit DESC;B. SELECT cust_last_name, cust_credit_limitFROM customersORDER BY cust_credit_limit;C. SELECT cust_last_name, cust_credit_limitFROM customersORDER BY cust_credit_limit NULLS LAST;D. SELECT cust_last_name, cust_credit_limitFROM customersORDER BY cust_last_name, cust_credit_limit NULLSLAST;Answer: B, C19.Which two statements are true regarding the COUNT function? (Choose two.) A. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data typesB. COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columnsC. COUNT (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID columnD. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT columnE. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clauseAnswer: B, D20.Which two statements are true regarding single row functions? (Choose two.) A. They accept only a single argumentB. They can be nested only to two levelsC. Arguments can only be column values or constantsD. They always return a single result row for every row of a queried tableE. They can return a data type value different from the one that is referencedAnswer: D, E21.View the Exhibit and examine the data in the COSTS table.You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.You issue the following query:SQL>SELECT prod_idFROM costsWHERE unit_price >= unit_cost * 1.25ORDER BY unit_cost * 0.25 DESC;Which statement is true regarding the above query?A. It executes and produces the required resultB. It produces an error because an expression cannot be used in the ORDER By clauseC. It produces an error because the DESC option cannot be used with an expression in the ORDER BY clauseD. It produces an error because the expression in the ORDER BYclause should also be specified in the SELECT clauseAnswer: A22.View the Exhibit and examine the structure of the CUSTOMERS table Which statement would display the highest credit limit available in each income levelin each city in the CUSTOMERS table?A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)FROM customersGROUP BY cust_city, cust_income_level, cust_credit_limit; B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)FROM customersGROUP BY cust_city, cust_income_level;C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)FROM customersGROUP BY cust_credit_limit, cust_income_level, cust_city; D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)FROM customersGROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);Answer: B23.Which two statements are true regarding subqueries? (Choose two.) A.A subquery can retrieve zero or more rowsB. Only two subqueries can be placed atone levelC. A subquery can be used only in SQL query statementsD. A subquery can appear on either side of a comparison operatorE. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statementAnswer: A, D24.View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:The above query generates an error on execution.Which clause in the above SQL statement causes the error? A. WHEREB. SELECTC. GROUP BYD. ORDER BYAnswer: C25.You need to create a table for a banking application One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period 2) The data in the column should be stored in a format such that it can be easily addedand subtracted with DATE data type without using conversion functions 3) The maximum period of the credit provision in the application is 30days 4) The interest has to be calculated for the number of days an individual has taken acredit for.Which data type would you use for such a column in the table? A. DATEB. NUMBERC. TIMESTAMPD. INTERVAL DAY TO SECONDE. INTERVAL YEAR TO MONTHAnswer: D26.View the Exhibit to examine the description for the SALES table Which views can have all DML operations performed on it? (Choose all that apply.)A. CREATE VIEW v3AS SELECT * FROM SALESWHERE cust_id = 2034WITH CHECK OPTION;B. CREATE VIEW vlAS SELECT * FROM SALESWHERE time_id <= SYSDATE - 2*365WITH CHECK OPTION;C. CREATE VIEW v2AS SELECT prod_id, cust_id, time_id FROM SALESWHERE time id <= SYSDATE -2*365WITH CHECK OPTION;D. CREATE VIEW v4AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALESWHERE time id <= SYSDATE -2*365GROUP BY prod_id, cust_idWITH CHECK OPTION;Answer: A, B27.Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER(4));B. CREATE TABLE 9emp$# (emp_no NUMBER(4));C. CREATE TABLE emp*123 (emp_no NUMBER(4));D. CREATE TABLE emp9$# (emp_no NUMBER (4), date DATE);Answer: A28.View the Exhibit and examine the data in the PRODUCTS table. Youneed to display product names from the PRODUCTS table that belong to the'Software/Other' category with minimum prices as either $2000 or $4000 and no unitof measure.You issue the following query:SQL>SELECT prod_name, prod_category, prod_min_priceFROM productsWHERE prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> "; Which statement is true regarding the above query? A. It executes successfully but returns no result B. It executes successfully and returns the required result C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not validD. It generates an error because the condition specified for the PROD_CATEGORYColumn is not validAnswer: A29.View the Exhibit to examine the description for the SALES and PRODUCTS tables. You want to create a SALE _PROD view by executing the following SQL statement:Which statement is true regarding the execution of the above statement? A. The view will be created and you can perform DML operations on the view B. The view will be created but no DML operations will be allowed on the view C. The view will not be created because the join statements are not allowed for creating a viewD. The view will not be created because the GROUP BY clause is not allowed for creating a viewAnswer: B30.Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per tableB. A TIMESTAMP data type column stores only time values with fractional secondsC. The BLOB data type column is used to store binary data in an operating system fileD. The minimum column width that can be specified for a VARCHAR2 data type column is oneE. The value for a CHAR data type column is blank-padded to the maximum defined column widthAnswer: A, D, E31.View the Exhibit and examine the structure of the PRODUCTS table.Evaluate the following query:What would be the outcome of executing the above SQL statement?A. It produces an errorB. It shows the names of all products in the tableC. It shows the names of products whose list price is the second highest in the tableD. It shows the names of all products whose list price is less than the maximum list priceAnswer: C32.View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. The ORD_NO column is PRIMARY KEY in the ORD table and the ORD NO and ITEM_NO columns are composite PRIMARY KEY in the ORD ITEMS table. Which two CREATE INDEX statements are valid? (Choose two.) A. CREATE INDEX ord_idxlON ord(ord_no);B. CREATE INDEX ord_idx2ON ord_items(ord_no);C. CREATE INDEX ord_idx3ON ord_items(item_no);D. CREATE INDEX ord_idx4ON ord,ord_items(ord_no, ord_date,qty);Answer: B, C33.Which statement is true regarding subqueries?A. The LIKE operator cannot be used with single-row subqueriesB. The NOT IN operator is equivalent to IS NULL with single-row subqueriesC. =ANY and =ALL operators have the same functionality in multiple-row subqueriesD. The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueriesAnswer: D34.You are currently located in Singapore and have connected to a remote database in Chicago.You issue the following command:SQL> SELECT ROUND (SYSDATE-promo_begin_date, 0)FROM promotionsWHERE (SYSDATE-promo_begin_date)/365 >2;PROMOTIONS is the public synonym for the public database link forthe PROMOTIONS table.What is the outcome?A. an error because the ROUND function specified is invalidB. an error because the WHERE condition specified is invalidC. number of days since the promo started based on the current Chicago date and timeD. number of days since the promo started based on the current Singapore date and timeAnswer: C35.View the Exhibit and examine the structure of the PRODUCTS table. Using the PRODUCTS table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price fallsbelow $10 after a discount of 25% is applied on it.SQL>SELECT prod_name, prod_list_price,prod_list_price-(prod_list_price*.25) "DISCOUNTED_PRICE"FROM productsWHERE discounted_price < 10;The query generates an error.What is the reason for the error?A. The parenthesis should be added to enclose the entire expressionB. The double quotation marks should be removed from the column aliasC. The column alias should be replaced with the expression in the WH ERE clauseD. The column alias should be put in uppercase and enclosed within double quotation marks in the WHERE clauseAnswer: C36.View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base location.Examine the following two SQL statements:Which statement is true regarding the outcome?A. Only statement 1 executes successfully and gives the required resultB. Only statement 2 executes successfully and gives the required resultC. Both statements 1 and 2 execute successfully and give different resultsD. Both statements 1 and 2 execute successfully and give the same required resultAnswer: D37.View the Exhibit and examine the structure of CUSTOMERS and SALES tables. Evaluate the following SQL statement:Which statement is true regarding the execution of the above UPD ATE statement? A. It would not execute because two tables cannot be used in a single UPDATE statementB. It would not execute because the SELECT statement cannot be used in place of the table nameC. It would execute and restrict modifications to only the columns specified in the SELECT statementD. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statementAnswer: C38.Evaluate the following query:SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL;What would be the outcome?A. 16B. 100C. 160D. 200E. 150Answer: C39.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.Evaluate the following SQL statement:Which statement is true regarding the output of the above query? A. It gives the details of promos for which there have been sales B. It gives the details of promos for which there have been no sales C. It gives details of all promos irrespective of whether they have resulted in a sale ornotD. It gives details of product 105 that have been sold irrespective of whether they had a promo or notAnswer: C40.View the Exhibit and examine the description of SALES and PROMOTIONS tables You want to delete rows from the SALES table, where thePROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values Which DELETE statements are valid? (Choose all that apply.)A. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale' )AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price' );B. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale' )OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price' ); C. DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale' )OR promo_name = 'everyday low price' ); D. DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN ('blowout sale', 'everyday lowprice' ));Answer: B, C, D41.View the Exhibit and examine the structure of the PROMOTIONS table.You have to generate a report that displays the promo name and start date for allpromos that started after the last promo in the' INTERNET' category. Which query would give you the required output?A. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date)FROM promotions )ANDpromo_category = 'INTERNET');B. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date IN (SELECT promo_begin_date)FROM promotionsWHERE promo_category = 'INTERNET');C. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');D. SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');Answer: C42.View the Exhibit and examine the data in the CUSTOMERS table Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT, MIDPOINT+100AS "MAX LOWER LIMIT"FROM customers;The above query produces an error on executionWhat is the reason for the error?A. An alias cannot be used in an expressionB. The alias NAME should not be enclosed within double quotation marksC. The MIDPOINT+100 expression gives an error because CUST_CREDIT _LIMIT contains NULL valuesD. The alias MIDPOINT should be enclosed within double quotation marks for theCUST_CREDIT_LIMIT/2 expressionAnswer: A43.View the Exhibit and examine the structure of the ORD tableEvaluate the following SQL statements that are executed in a user session in the specified order.What would be the outcome of the above statements?A. All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST ID 101B. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specifiedC. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specifiedD. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20 Answer: A44.Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.Which query would give the required result?A. SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50AS "50% Credit Limit"FROM customers;B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit *0.50AS "50% Credit Limit"FROM customers;C. SELECT DISTINCT cust_income level || ' ' || cust_credit_limit *0.50AS "50% Credit Limit"FROM customers;D. SELECT cust income level || ' ' || cust_credit_limit * 0.50 AS "50% Credit Limit"ROM customers;Answer: C45.View the Exhibit and examine the structure of the CUSTOMERS table Evaluate the query statement:What would be the outcome of the above statement?A. It executes successfully。

实用文档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 （已验证。

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。

OracleOCP认证考试题库Oracle OCP认证考试题库Oracle开发的关系数据库产品因性能卓越而闻名，Oracle数据库产品为财富排行榜上的前1000家公司所采用，许多大型网站也选用了Oracle系统，是世界最好的数据库产品。

以下是店铺整理的关于Oracle OCP认证考试题库，希望大家认真阅读!QUESTION 1You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A. Disable automatic checkpoint tuningB. Check the size of the redo log file size and increase the size if it is smallC. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR AdvisorD. Decrease the number of redo log members if there are more than one redo log members available in each redo log groupCorrect Answer: BCExplanation/Reference:检查点进程:The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, location in online redo log to begin recovery, and so on. CKPT does not write data blocks to data files or redo blocks to online redo log files.检查点作用:(1)定期促进DBWn进程把内存的脏块写回到数据文件,数据库故障时不会丢数据(2)减少实例恢复的时间(3)确保所有已提交的数据在一致性关闭期间会被写入数据文件实例恢复时间:指的是将数据文件的最后一个检查点(检查点位置)推进到控制文件中记录的最新SCN所需的时间.管理员可以通过设置MTTR 目标以及调整重做日志组的大小来控制该时间.MTTR:Mean Time T o Repair,即平均修复时间.是指可修复产品的平均修复时间,就是从出现故障到修复中间的`这段时间.MTTR越短表示易恢复性越好.在数据库中可以通过设置参数FAST_START_MTTR_TARGET(单位为秒),控制数据库对单个实例执行崩溃恢复所花费的时间.FAST_START_MTTR_TARGE=非0值, 启用快速启动检查点功能,自动控制发检查点速度.FAST_START_MTTR_TARGE=0,禁用快速启动检查点功能.如果重做日志文件的size太小,会频繁切换日志,即会频繁发生检查点,故可以增大重做日志文件的size减少检查点发生频率.FAST_START_MTTR_TARGET如果设置的太小,为了要控制数据库单实例的实例恢复时间，则必须频繁发生检查点,确保内存中已修改的数据块能够定期写入到磁盘,故可以使用MTTR Advisor来设置推荐的值.QUESTION 2Identify the memory component from which memory may be allocated for:Session memory for the shared server, Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and restore operationsA. Large PoolB. Redo Log BufferC. Database Buffer CacheD. Program Global Area (PGA)Correct Answer: AExplanation/Reference:Large PoolThe large pool is an optional memory area intended for memory allocations that are larger than is appropriate for the shared pool. The large pool can provide large memory allocations for the following:UGA for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)Message buffers used in the parallel execution of statements Buffers for Recovery Manager (RMAN) I/O slavesBy allocating session memory from the large pool for shared SQL, the database avoids performance overhead caused by shrinking the shared SQL cache. By allocating memory in large buffers for RMAN operations, I/O server processes, and parallel buffers, the large pool can satisfy large memory requests better than the shared pool.QUESTION 3You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SIZE 100MSEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES_DATA tablespace? (Choose two)A. The database automatically determines the extent-sizing policy for the tablespace.B. The segments are automatically shrunk when the contents are removed from them.C. The allocation of extents within the tablespace is managed through the dictionary tables.D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.E. The space utilization description of the data blocks in segments is managed through free lists.Correct Answer: ADExplanation/Reference:段空间管理: 本地管理的表空间中的段空间管理方式可指定为:自动:Oracle DB 使用位图管理段中的空闲空间.位图描述了段中每个数据块的状态,该状态与可插入行的块中的空间量有关.当数据块中可用空间增多或减少时,位图中会反映数据块的新状态.通过使用位图,Oracle DB 可以提高管理空闲空间的自动化程度.因此,这种空间管理方式称为"自动段空间管理(ASSM)".手动:此方法指定要使用空闲列表来管理段中的空闲空间.空闲列表是由一些数据块组成的列表,这些数据块中有可插入行的空间.由于这种管理段空间的方式需要为在表空间中创建的方案对象指定并优化PCTUSED、FREELISTS和FREELIST GROUPS存储参数,因此这种方式称为"手动段空间管理".支持使用此方法是为了向后兼容,建议使用ASSM.可通过dba_tablespaces查看分区和段空间管理方式:SYS@ENMOEDU> select tablespace_name,extent_management,segment_space_manage ment from dba_tablespaces;TABLESPACE_NAME EXTENT_MAN SEGMENSYSTEM LOCAL MANUALSYSAUX LOCAL AUTOTEMP LOCAL MANUALUSERS LOCAL AUTOEXAMPLE LOCAL AUTOUNDOTBS1 LOCAL MANUALQUESTION 4In which of the scenario will the DBA perform recovery? (Choose all that apply.)A. The alert log file is corruptedB. A tablespace is accidentally droppedC. One of the redo log members is corruptedD. A database user terminates the session abnormallyE. The hard disk on which the data files is stored is corruptedCorrect Answer: BEExplanation/Reference:DBA一般在数据库出现介质损坏的时候执行恢复操作.A: 错误,alert日志损坏数据库不会丢失数据,不需要恢复.B: 正确,表空间在操作系统改名需要执行恢复,数据库找不到表空间对应的数据文件.C: 错误,丢失redo成员,不会丢失数据,不需要执行恢复操作.D: 错误,会话异常终止不会丢失数据,不需要恢复,数据库会释放异常会话占用的资源.E: 正确,磁盘损坏会导致在该磁盘的数据文件损坏,需要执行恢复操作.【Oracle OCP认证考试题库】。

2018年新版直通车车手基础认证（70题）单项选择题：1、单项选择题无线直通车的关键词展现资格用手机标识予以区分，关键词在移动设备的质量得分和手机标识有一一对应的关系，请问以下哪种颜色标志不包含在手机标识中？黑色标识2、若买家在淘宝网首页电脑端“搜索宝贝”中输入购买的关键词，点击搜索。

此时买家在结果页面底端可以看到几个横向直通车展位？5个3、若商家想查看直通车推广产品在不同地区的受喜爱程度，则可通过直通车数据报表中哪个列表进行查看？地域列表4、直通车在全网有不同的展现位置，请问以下哪项不是直通车展位？淘宝无线首屏置顶轮播5、“系统从买家行为中分析出买家特点或购物倾向，将这些属性打包为人群包，由广告主进行选择和竞价，出价高且买家反馈好的产品被展现”，根据信息判断，以下哪种推广方式的展示逻辑如上所述？直通车定向推广6、伴随店铺的发展，若是卖家想推广多个同类型宝贝、传递店铺独特品牌形象，则可以通过以下哪项直通车推广功能实现该需求？店铺推广7、请问以下哪种因素不会影响质量得分？竞争度8以下哪种直通车定向推广投放适合所有店铺，且能综合多种维度挖掘最适合推广宝贝的人群？智能投放9、在直通车手淘首页溢价计划中，请问以下哪种操作可以更好地帮助其抢占手淘流量？定向推广-展示位置-手机淘宝首页_猜你喜欢溢价调整为150%10、宝贝推广是直通车最基础的一种推广方式，但是宝贝新建标准推广计划有数量限制，请问一般来说，卖家目前最多可拥有几个直通车标准推广计划？8个11、关于直通车质量得分的更新频率，以下哪种说法是正确的？质量得分随定时更新12、某卖家店铺冬季上新，要从5款中选其一个作为主推款，这时该卖家的第一操作是添加关键词。

针对该场景，以下哪种直通车推广宝贝的关键词设置建议更合理？以相关性排序，添加30个左右13、某卖家设置的人群出价中的智能投放为1.0元，“喜欢我店铺”的访客溢价为10%，在展示位置中已买到的宝贝溢价为50%。

R O
G 家 U 专 U C 航 领 训 培 E L C A
7、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2. SYS executes this command: SQL> REVOKE UPDATE ON user1.emp FROM user1; What will be the outcome? • ❑ A) It will succeed and only USER2 will be unable to perform SELECT, INSERT, Or UPDATE on USER1. EMU. • ❑ B) It will succeed and only USER1 will be unable to perform SELECT, INSERT, Or UPDATE on USER1. EMP. • ❑ C) It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1. EMP. 0 • ❑ D) It will fall because USER1 Is the owner of USER1. EMP. • ❑ E) It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1. EMP, but both will be able to query USER1. EMP). • Answer:D
R O
G 家 U 专 U C 航 领 训 培 E L C A