OCP认证052考试最新考试题库解析-20180727
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工具支持压缩和加密功能，但是加密的时候需要用到密码。
压缩的级别分别是ALL, DATA_ONLY, METADATA_ONLY,DEFAULT 或NONE。
默认是会采用DEFAULT的压缩方式采用METADAT A_ONLY级别压缩。
加密的级别是ALL,DATA_ONLY, METADATA_ONLY,ENCRYPTED_COLUMNS_ONLY 或NONE。
如果当前的dump文件已经存在，需要使用参数REUSE_DUMPFILES ＝y 覆盖目标转储文件30. Which two statements are true regarding the Oracle Data Pump export and import operations?（choose two）A) You cannot export data from a remote database.B) You can rename tables during an import operation.C) You can overwrite existing dump files during an export operation.D) You can compress the data during export but not the metadata because it is not supported. Answer: BC31. Examine these facts about objects in the SYSTEM schema:1.EMP is a table.2.EMP_PK is a primary key constraint on EMP.ENO.3.EMP_IDX is an index on EMP.MGR_NO.4.EMP_SEQ is a sequence used to generate values for EMP.ENO.5.EMP_OPS_PKG is a package that performs DML operations on EMP.6.EMP_VU is a view on EMP.7.EMP_TRG is a trigger on EMP.Examine this command:$ expdp system/oracle \> FULL =Y \> EXCLUDE=TABTLE:"= 'EMP' "\> DIRECTORY=data_pump_dir \> DUMPFILE=full_db.dmp \> LOGFILE=full_db.1ogWhich three objects will be exported?A) EMP_PKB) EMP_SEQC) EMP_OPS_PKGD) EMP_VUE) EMP_IDXF) EMP_TRGG) EME_FNAnswer：BCD ( 已验证）expdp system/oracle DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott EXCLUDE=TABLE:\"IN\(\'EMP\'\)\" SCHEMAS=scott如果在导出的过程中排除了一张表，那么跟这张表相关的数据就不会导出，比如表的结构、数据、索引、约束、触发器等。
跨境电商人才初级认证考试题库200题(含答案)K
跨境电商人才初级认证考试题库（含答案）一、单选题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、是否由卖方支付海运费。
obcp笔试题库
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）。
跨境电商人才初级认证考试题库200题(含答案)NO
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、随托收项下的汇票
OCP考试052最新考试题库原题-8-20180727
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. 百度搜索引擎的核心算法包括网页排名算法、词频算法、向量空间模型和机器学习算法。
Oracle OCP 052最新考试题库解析-20180608
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｜052]-最新考试题库解析-6-20180615
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 题库解析OCP（Open Closed Principle）是面向对象设计中的一个重要原则，它要求软件实体（类、模块、函数等）应该对扩展开放，对修改关闭。
也就是说，一个软件实体应该是可以扩展的，而不需要修改。
OCP 题库解析指的是对 OCP 原则相关题目的解析和讨论。
首先，我们来看一些关于 OCP 原则的基本概念。
OCP 原则要求我们设计软件实体时要考虑未来的扩展性，避免对现有代码进行修改，而是通过扩展现有代码来实现新功能。
这通常可以通过使用抽象类、接口、多态等方式来实现。
例如，我们可以定义一个接口或抽象类，然后针对不同的需求编写不同的实现类，这样在新增功能时只需要新增实现类，而不需要修改原有的代码。
在解析 OCP 题库时，我们需要深入理解 OCP 原则，并且掌握如何在实际代码中应用这一原则。
我们可以从以下几个方面来分析和解答相关题目：1. OCP 原则的含义和作用，首先我们可以解释 OCP 原则的概念，以及它对软件设计的重要性和作用。
我们可以举例说明采用OCP 原则的优点，以及不遵守该原则可能带来的问题。
2. 如何设计满足 OCP 原则的代码，我们可以讨论如何设计满足 OCP 原则的代码结构，比如通过接口、抽象类、依赖倒置等方式来实现代码的可扩展性和灵活性。
可以举例说明如何利用设计模式来实现 OCP 原则，比如策略模式、装饰者模式等。
3. 题目分析和解答，针对具体的 OCP 题目，我们可以逐个进行分析和解答，包括题目中涉及的代码设计、扩展需求、可能的修改方式等。
我们可以通过具体的例子来说明如何设计满足 OCP 原则的代码，并且讨论每种设计方式的优缺点。
总的来说，解析 OCP 题库需要对 OCP 原则有深入的理解，同时需要具备丰富的实际编程经验和设计能力。
通过深入的讨论和分析，我们可以帮助学习者更好地掌握和应用 OCP 原则，从而提高代码的质量和可维护性。
OCP认证052最新考试原题题库解析-4-20180601
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 •
OCP考试052最新考试题库原题-9-20180803
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.。