Oracle OCP 052最新考试题库解析-20180608

合集下载

2018ocp 052最新题库及答案整理--6月15日

052题库解析-6.15题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现新版 OCP 题库解析公开课地址：/course/307596收看直播 = 一手 OCP 考试消息 + 学技术涨经验 + 过关考试 + 技术解答更多 OCP 的新题解析资料群：569933648 验证码：ocp1、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: BE2、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: D3、 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 takes place.No alternative or optional archive destinations are defined.What is the outcome?• A. Obsolete backups are automatically deleted and now archivelogs are generated.• B. The ar chivelog entries are made in the diagnostic destination and when space is available, now archivelogs are generated.• C. No archivelogs are generated.• D. All active sessions are disconnected and their transactions rolled back.• E. All active sessions ha ng until the database administrator (DBA) makes space available in the FRA.• Correct Answer: E4、 Which three are true about Oracle database security?• A. By default, SYSDBA connections have access to all schema objects.• B. SYSDBA connections are alw ays 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: ABE5. Which three structures can span multiple data files?• A. chained rows• B. segments• C. temporary segment extents• D. index extents• E. table extents• F. migrated rows• Correct Answer: ABF6、Examine these SQL statements and their output:A. Inactive undo will never be retained for more than 15 minutes.B. The undo tablespace can grow automatically if there is not enough space to retain active undo.C. Inactive undo will be retained as long as possible within the limits of the current size of the undo tablespace.D. Inactive undo will always be retained for at least 15 minutes.E. Active undo will be retained as long as needed by transactions.Correct Answer: BE• 7、Which three can reduce lock contention in an Oracle database?A. The Database Resource ManagerB. profilesC. scheduling OLTP and batch workloads at different timesD. manual locking of database objects for DML statementsE. committing transactions in a timely mannerCorrect Answer: CDE8、 Which two are true about the Inventory directory?• A. It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server.• B. It is shared by all Oracle software installations on a single server.• C. It should be created before installing Oracle software for the first time on a server.• D. It is required only for Oracle Grid Infrastructure and Oracle Database software installations.• E. It can be created only if the ORACLE_BASE environment variable is set.• Correct Answer: AB9、 Which is true about unusable indexes?• A. Rebuilding an unusable index always requires at least twice the space of the original index• B. Rebuilding an unusable index always allows DML statements on the index’s table during the rebuild.• C. Rebuilding occurs automatically when an unusable index is chosen by the optimizer when creating an execution plan• D. Rebuilding an unusable index creates a new segm ent after dropping the unusable index.• Correct Answer: D10、 Which two are true about space management in tablespaces?• A. Free lists are used for managing free space for segments in locally managed tablespaces.• B. Extent allocation must be specifie d as automatic for automatic segment space management (ASSM) tablespaces.• C. ASSM tablespaces prevent row chaining.• D. Locally managed tablespaces track adjacent free space automatically by using bitmaps.• E. Locally managed tablespaces have either AS SM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other.• Correct Answer: DE11、 Which command is used to display files that no longer conform to the backup retention policy?• A. CROSSCHECK BACKUP• B. REPORT OBSOLETE• C. LIST EXPIRED BACKUP• D. SHOW DATAFILE BACKUP COPIES• Answer: B12 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 Drop• 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 Table• Answer: BC12 Which is true about enabling AUTOEXTEND for data files?• A. It can be enabled for data files only in smallfile tablespaces.• B. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.• C. It can be enabled only for data files in non-OMF tablespaces.• D. It c an be enabled for data files only in bigfile tablespaces.• E. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.• Answer:B13 In one of your databases:• • The database default tablespace is EXAMPLE.• • DEFERRED_SEGMENT_CREATION is FALSE.• Examine these commands:• SQL> CREATE USER user1 IDENTIFIED BY oracle_4U PASSWORD EXPIRE;• User created.• SQL> ALTER USER user1 ACCOUUNT UNLOCK;• User altered.• S QL> GRANT CREATE SESSION to user1;• Grant succeeded.• SQL> GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;• Grant succeeded.• Which three are true?• A. USER1 can grant the CREATE TABLE privilege to other users.• B. USER1 can log in to the database ins tance.• C. USER1 can create tables in the EXAMPLE tablespace.• D. USER1 can create indexes in EXAMPLE tablespace• E. USER1 must change it‟s password at first login.• Answer: ABE14 Which two can be exported by a non-administrative account by using Data Pump? • A. tables• B. database• C. directory objects• D. tablespaces• E. schemas• Answer: AE15 Your database is using Automatic Memory Management.Which two SGA components must be managed manually?• A. redo log buffer• B. keep buffer pool• C. large pool• D. shared pool• E. default buffer Cache• Answer: AB。

OCP考题学习

If the POWER clause of a rebalance operation is not specified, then the default power will be the value of ASM_POWER_LIMIT
5. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective? A.The user must have been granted the DBA role.
分区 ORACLE认证试题的第 1 页
A.The user must have been granted the DBA role. B.The user must have been granted the switch privilege as a part of a role. C.The user must have been granted the Resource Manager administrator privilege. D.The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package. Answer: D Note: 资源管理概述: 资源管理器有三个部件组成：资源用户组（Resource consumer group ）资源规划（Resource plan ）资源分配方法（Resource allocation method）资源计划目录(Resource plan directives) 它们的功能如下：资源用户组: 根据数据库资源处理需求，将用户会话分成组资源规划: 指定哪些资源分配给资源用户的命令资源分配方法: 数据库资源管理器分配特殊资源时采用的方法，由资源用户组和资源规划来使用。

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）。

OCP题库及模拟考试2

extensible adj. 可延长的；可扩张的
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour
abbr. 联机事务处理
adj. 最高的；最大值的
Answer: CD adj. 镇定的；收集成的
thereby adv. 从而，因此；在那附近；在那方面
3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
闪回恢复区
C.There is not enough free space in the flashback archive.
consistent adj. 始终如一的，一致的；坚持的
D.The query is unable to place data blocks in undo tablespace
v. 影响（affect的ing形式） n. 破碎；分裂；[计] 存储残片
A.Validate the index structure using the ANALYZE...INDEX command.
vt. 证实，验证；确认；使生效
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
v. 观察；遵守
n. 统计；
v. 分裂；使成碎片
导致，结果是
poor database performance. Which option would you use to reduce fragmentation without affecting the

OCP考试052最新考试题库原题-8-20180727

052题库解析OCP考试052最新考试题库原题-8-20180727题库新特点：最原有的题库基础上有添加了新的题库七. Storage Structures19.Whichthreestructures canspanmultipledataﬁles？A) migratedrowsB) tableextentsC) temporarysegmentextentsD) indexextents E)chainedrowsF)segments Answer：AEF20.Whichstructure canspan multipledataﬁles?A)a bigﬁle 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)Controlﬁle.B)Allmembers ofa redologgroup.C) SYSTEMtablespace.D) SYSAUXtablespace.E)spﬁleAnswer：ABC23.Whichtwoofthese mustbeavailableREAD/WRITEtokeep adatabase open?A)allcopiesof the controlﬁle. B)thepasswordﬁle.C) allmembers ofthecurrentredologgroup. D)spﬁle.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 speciﬁed.Whichfour arestored inthelocation speciﬁed by DB_CREATE_FILE_DEST? A) auditlogs B) control ﬁles C) redologs D) auditﬁles E) data ﬁlesF) archivedredologsG) temp ﬁlesH) RMAN backupsAnswer：BCEG八.Checkpoint25. When doesanincrementalcheckpointoccur?A)whenanonlineredologswitchoccurs.B)whenDBWnwrites dirty buffersas partofitsnormal processing.C)whentheALTERSYSTEMCHECKPOINTstatement is executed.D)whena usertablespaceis tabken ofﬂine.Answer：A九. InventoryDirectory24.WhichtwoaretrueabouttheInventorydirectory?A) Itissharedby allOraclesoftwareinstallationsona singleserver.B) Itisrequiredonlyfor Oracle Grid InfrastructureandOracleDatabase softwareInstallations.C) Itcanbecreatedonlyif theORACLE_BASE environmentvariableisset.D) It shouldbecreatedbeforeinstallingOraclesoftwarefortheﬁrsttime onaserver.E) Itisownedbytheoinstallgroup,whichmust becreatedbeforeinstallingOraclesoftwareforthe ﬁrst timeon a server.Answer：AD⼗.Administer Database25.whichfourare true aboutthe toolsusedtoadministerOracle database?A)the DataPumputilitycan beused to loaddatafromtextﬁles.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)dumpﬁles B) control ﬁle C) logﬁlesD)Automatic DiagnosticRepository(ADR)E) master table(MT)Answer：E29.Whichtwoaretrue aboutOracleDataPumpinOracleDatabase11gRelease2?A) Ifthedirectory usedinthe exportoperationhasexistingdumpﬁles,it overwritesthem.B) Itallowsencryptionto beperformedwithoutusinga password. C) It supportsthe exportof speciﬁc viewsas tables.D) Itallowscompressionlevelsto be deﬁned for theexport. E)Itsupportsthe renamingoftablesduringimport.Answer：AE11g expdp工具支持压缩和加密功能，但是加密的时候需要用到密码。

[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

oracle考试试题及答案.doc

oracle考试试题及答案Questions one by one, fill in the blanks (4 points per question exergy a total of 20 points)1,database management technology has gone through three stages: manual management, file system and database system2,database three level data structure is external mode, mode, internal model3,the Oracle database SGA database buffer by exergy exergy exergy redo log buffer shared pool.4,in the Oracle database integrity constraints exergy types are Primay key constraints・ Foreign key Unique constraint exergyCheck not need exergy exergy constraint constraint constraintDeclare cursor open the cursor cursor exergy exergy exergy extraction in PL/SQL, including 5 close myCursor cursor operationTwo, the true or false questions in every day 2 points 20 points total exergy rateThe basic objects stored in the database is 1, the data rate in T2, the database system is the core of DBMS in the T rate The characteristics of relationship between the 3 and the operation is set in the operating rate of T4,five basic operations in relational algebra, and is the difference,selection, projection, connection in the F rate5,Oracle process is the server process in the F rate6,the oraclet system SGA process server and all users in the process of sharing rate T7,the Oracle database system in the data block size in the T operation of the rate system8,Oracle database system exergy start database and the first step is to start a database instance in the T rateThe cursor 9, PL/SQL data can be changed in the F rate10, the database concept model is mainly used in database conceptual structure design in the F rateThree, use the title in the match each 7 points 35 points total exergy rateLogical independence and physical independence in 1, what is the database system data in the programDBMSProvides a two layer mapping mechanism in external mode threemode structureSchema, image, and modeInternal schema image・ The twoThe layer mapping mechanism guarantees the logicalindependence and physical independence of data in the database system・External modeThe schema image defines the correspondence between the external schema of the different users in the database and the logical schema of the database・When the database schema changes such as a relational database system to increase exergy change with the new relati on ship, the relationship between attribute data types can exergyExternal mode adjustmentThe relationship between image mode exergy guarantee a constant user oriented mode of each. The application is based on the data of the model prepared by the exergyWhich application is not required to ensure the independence of the logicof exergy exergy data and application of logical data independence・PatternThe internal schema image defines the global logical structure of the data in the database and the physical storage organization of those data in the systemCorrespondence・When changing the physical storage of data structures in the database when the internal model changes such as the definition and selection of a storage structure can adjust theThe constant so that the external schema of database system and individual applications do not have to change the database schema in the schema mapping relationship / hold mode・This will ensure that the physical data independence and the independence of the physical data between applications or databases ・2, the relational algebra equi jo ins difference is not a natural connection without contact yesterdayAnswer when the operator connected conditions included in the use of 〃二〃this connection is called equivalent connection. Connection operation General in the two table between for can also be in a table does nothave its own connection between connection operation such as from the ・Answer・The equivalent connections and self connections belong to the internal connection query3, what is the database database design is generally divided into what stage from1)Exergy databaseDatabaseIn according to the data structure to organize, store and manage data warehouse・2)Requirement design conceptual designlogic design physical designImplementation, operation and maintenanceFourBrief descriptionOracleComposition of exergy logical databaseA table space, segment, data blockFiveWell, try any one example of using method from cursorA exergyCreate tableCreate table test(Name char (30),Age char (40),Subject char (20),ID numeric (10))insert dataInsert, into, test, values (' hehe，,' haha，，‘ hh', 4)Define variablesDeclare @name char (30)Declare @age char (40)Declare ©subject char (20)Declare @id numericCreate a CursorDeclare himml cursorFor, select, [name], age, subject, ID, from, test open Open hiininlUse cursors to scroll throughFetch, himml, into, @name, @age, @subject, @id 一一Be careful@@FETCH_STATUS yesSQL SERVERInside variables andORACLEThe@@sqlstatusDiffer・While (@@FETCH_STATUS 二0)BeginPrintPrint @namePrint @agePrint ©subjectPrint @idFetch, hiininl, into, @name, @age,@subject, @idEndClose the cursor rate close the cursor result set in its entirety instead of exergyClose hiimnlClose the cursor cursor rate release the memory in and let the cursor name can be used again exergyDeallocate hiimnl five with employee tablesEMP (empno, ename, age, Sal, Tel, deptno), in which empno -------- name ------ n ame age - number of exergy exergy exergy exergy oftel ---- electric sal ------- age wagewordDeptno ----- Department number・Please program at SQL*PLUS in the morning following the following requirements・In every day 3 points total of 15 points in the 1 exergy rate, home telephone staff information query. In the SQL>SELECT FROM EMP WHERE Tel NOT * NULL; in the 2, query wages in 500 to 800 yuan betweenthe employee information in SQL>SELECT * FROM EMP WHERE BETWEEN 500 AND 800: in 3, according to the age in creasing order display employee nu mber, name, age, salary in the SQL>SELECT empno, ename, age, Sal FROM EMP ORDER BY age ASC; SQL>SELEC, 4As the average wage in the Department of SQL>SELECT AVG DOI (SAL) FROM EMP WHERE deptno二'D_01' ; in the 5, find the department number D OI over 40 years of age and wage of 400 yuan in the list of employees in the SQL>SELECT ename FROM EMP WHERE deptno二'D_01' AND age>40 A7D.An examination question twoTwo, fill in the blanks (each 2 points 30 points total exergy) please fill in the correct answers in the blanks every day. No fill and no "11.1.data model is usually composed of three elements of the data structure, data operation and data __________ constraint _・2.database systems, all types of user requests for database operations (data definition, query, update, and various controls) are made up ofA complex software to complete the exergy this software called DBMS3.in the SQL SELECT statement in the query to remove duplicate records of exergy exergy in the query results should be used —DISTINCT_・Key word・ 4. the use of SQL language SELECT statement for the query packet in the packet if he hoped to get rid of not meet the conditions should beUse the HAVING clause.5.relational database data manipulation language (DML) includes two types of operation in their search and update _■6.in relational database design in the database design is divided into requirement analysis, concept design, logic design, physical design, applicationProgram coding, debugging operation, database operation and maintenance in six stages・What stage of database design is the design relational schema?Exergy ____ task logic design ____7.operations can be divided into _ relational algebra _relational calculus and _______ two categories・The relationship between the 8. INF _ non _ main function to eliminate the dependence on the key attribute in the paradigm after grade to 2NF. 2NFThe relationship between — eliminate non main attributes on the keys of the transfer function can be _ dependent upon his paradigm level increased to 3NF.The three level structure of the 9. database through the concept of the pattern / image within the pattern to ensure ________________ independenee in the physical model of concept mapping / byAs in the ― logic _ independence guarantee.10.the meaning of SQL is _ structured query language _________ ・11.DBMS usually provide the authorization function to control permissions in the data of different users to access the database in its purpose is to numberAccording to the _____ security database・Three, short answer questions (6 points each item in a total of 24 points)Safety protection function 1. database provides four aspects which try to explain their meaning of exergyExergy security database is a rate caused by use of database protection prevent 订legal data leakage, change or damage・ SQL Server 2000The security mechanism consists of four layersThe first layer included operating system loginSecond layer server security management exergy exergySQL ServerLoginSpecial accountSAThird layer database security management database exergyexergy accessDatabase userFourth layer database objects in safety management of exergyexergy exergy database object tables and views in accessDatabase user gets roles2. the referential integrity rules in the purpose of it in the test example donburi・3. to Oracle DBMS for the SQL relational database language support is given in the case of grade three logic schematic 1) SQLLanguage support relational database three level logic structure consists of the outer layer and a memory, the concept of as shown in fig・・2)The concept of recording layer corresponds to the conceptual model is the basic table・The basic table is a table that itself actually exists ・A basic table is a it not by other forms of export table・ The basic table is usedCREATE TABLEStatement built・3)In the outer as seen by the user can be the basic table can also be view can also be the basic table view. A view is a virtual tableIt is composed of one or several basic forms of export table it does not exist in the physical memory directly on the table・ View is usedCREATE SQL VIEWlanguageSentence established.4)In the inner each basic table with a file storage is said by a group of the same type of stored records to indicate the value・DBAYou can manipulate physical storage files.4., briefly describe the DBMS database security control function, including what are the commonly used means?A database management system for data control function data securitycontrol function in order to ensure the safety and reliability of the data within the database to preventThe use of illegal cause data leakage and damage the data that avoid being peeped, tampering or ruining exergy data integrity control refers to the function of insuranceThe data card in the database correctly and effectively and to prevent the compatibility error data is not the semantic input or output.Four, database design (15 points)Suppose there is a relationship between the 1. to record each person，s identity card number, name and work unit・ Also contains every one of his / her childrenThe identity card number, name and place of birth and the he / she has every car brands and models・The real world from known facts thatSome people may have several cars but these cars may be the same type but may also is not the same type of exergySome people do not have the car if someone has the car included his every car has a car includedSome people may have several children but there are some people without children. The relationship model of the preliminary design of the are as followsR (identity cards, the name of the work unit of the C identity cards, the name of the C C was born in the car the model)The 〃C C〃identity cards, the name C was born "are the child，s identity card number, name and place of birth・Please send this pat tern into the pattern of the relationship between BCNF to determine the relationship between the main key. 7 points in a exergy exergy, the citizen identity cards in the name of the work unitThe type of car car exergy the identity card number inThe child identity cards, the exergy of C C C was born in the name of the identity card number in a certain school library2.assumptions to establish a database to save the readers, books and readers of record. In order to build theWe need to design a good database design from the conceptual model is shown and then the figure - the conceptual model intoa relational model・ pleaseDesign fTom La - map・The reader has readers attribute number, name, age, address and unit.Attributes of each book are ISBN, title, author and publisher・Each book for each reader borrowed date and should also have out of date ・ 8 points in exergyA reader reader the name address the exergy number in the unitThe author of the book ISBN Title Exergy in the press・The number of readers to borrow the books ISBN exergy date the date should be in five, calculation (the title 3 items within a total of 16 points)Clients with a commercial relational database the three basic table the table structure is as followsTable Article (commodity goods, the price of the stock in the commodity name)Table Customer (customer clients, the clients name the sex the age the phone)Orderitem order form (the number of the dients, the purchase price of goods number the date)Note that the answer to will give the answers written provisions of the local exergy answer requirements must be clearly not allowed to change the included writing programAnd optionally add sub queries・1.please create a GM_VIEW view of the retrieval clients using SQL language dients, clients and ordering goodsName, amount and date・(the number is equal to the purchase price * amount) 6 points in exergyCREAT VIEW GM_VIEW (clients, the clients name the commodity name the amount of the number of date) * AS SELECT _ clients, clients in a brand name in the purchase price in the amount of as in the date of FROM Artcle, Customer,OrderItemWHERE Customer・clients, =OrderItem・clients, and Article・commodity No.二OrderItem・ Article No. 2. please use the SQL language of female clients buy goods number, commodity name and the total number of out ・ 6 exergy rateSELECT _OrderItem・，commodity number AS, commodity number, Order Item ・ commodity name, AS commodity name, SUM (Order Item ・ quantity)The total quantity of AS is FROM, Orderitem, Artcle, Customer, WHERE _Artcle・,commodity number 二Orderitem・,commodity number AND, OrderItem・,commodity number 二Customer・, commodity number ANDCustomer・=，GROUP BY OrderItem・female gender in commodity trade name No.3.please use the SQL language ALTER TABEL command of a field in a field called the origin will increase the number of goods to table ArticleAccording to the type of the CHAR in the length of 30 in the rate of 4 points exergy command is as followsChar ALTER TABEL —Article ADD (30) — originItem 31, fill in the blanks (each 2 points in a total of 20 points)The SELECT statement for grouping query 1, using the SQL language in the packet will not meet if you want to remove the conditions should beUsing —HAVING..・ _ clause・In 2, in the design of relational database in database design is divided into requirement analysis, concept design, logic design, physical design, should beProgram coding, debugging run, database operation and maintenance in six stages・ What stage of database design is the design relational schema?The task of exergy _ logic designRelational operations in relational algebra and 3, including the selection, projection, __________ connection and division.4,the relationship model of entity integrity in referential integrity in user-defined integrity of three types of integrity・5,two yuan for entity set between A and B between the set in mapping base set must be one of the following four1. , one to one, contact2., one to many con tacts, more than3. to one, contact more than4., many pairs of contacts6,PL/SQL cursor the two types of explicit and implicit cursor cursor ・Two, single choice (3 points per item in a total of 15 points)1, in a relational database management system will create the view in the database three layer structure belongs to (A)A.external modeB. storage modeC. intra schemaD. conceptual schemaThe general characteristics of the 2, in the world of things in reality in the information world is called (A)A. entityB. entity keyThe C・ property D・ key 3 Relationship Model S J P SJP in the S in is students J curriculum P is ranking・ Each student takes in each courseThe performance has a certain rank each course ranking only one student in the column and No. The relationship model belongs to exergy (C)A, 2NF, B, 3NF, C, BCNF, D, 4NF4,the company has a department of a num bet of departments and employees each staff only belongs to a department can have a number of staffThe type of contact from staff to department is (C)A.many to many,B. , one to one,C., one to many, one toD., one to many5,the logical independence of data refers to (A)The concept of A. mode change external mode and not the applicationB.concept mode change mode notIn the C. mode concept mode not changeD. mode change external mode and not the applicationThe correct statement, query on wildcards in the 6. part (D)A・"匚 B・"represents a number of characters _〃can represent zero or more charactersC.〃—〃can not 〃%〃to use D・represents a characterThree, Jane answer1,the referential integrity rules purpose it donburi test example・2,Briefly describe the architecture features of Oracle database system1)contains at least one SYSTEM table space, and the DDL language2)various spatial data dictionary informationThe data stored in the table space, table space exergy is reflected in the form of multiple data files・3,what is the logic of program data independence and physical independence from 4, the DBMS of the database security control functionsincluding what means?5. Sketch the main steps of database conceptual design. (1)Data abstract conceptual model in the design of local exergy (2)The concept of local mode integrated into the global conceptual schema in(3) review 6, what is the function from the rollback segment7,cold and heat Be if eng explain back up different points and advantages from each of the 3 SCG in S#, model C#, grade, S# in the No.C for students course No. grade Exergy for a studentExamination results for a certain course・The average score were going to query the average score over 80 points in the course of the query resultsAccording to the average scores in ascending order average the same number in descending order according to the curriculum・ Write the SQL query・A Select C# AVG analysis (grade), From SCGGroup by C#Having AVG (grade) >80Order by 2, C# desc。

oracle ocp 中文题库

Oracle OCP 中文题库一、引言Oracle OCP（Oracle Certified Professional）认证是全球范围内认可的数据库专业人士认证体系之一，该认证体系包括了数据库管理、应用开发等多个方向。

作为一名希望取得Oracle OCP认证的考生，熟悉并掌握题库中的内容是非常重要的。

本文将针对Oracle OCP中文题库进行详细的介绍和讲解，希望能够对广大考生有所帮助。

二、Oracle OCP中文题库的组成1. 数据库概念部分：包括数据库的概念、体系结构、原理等内容。

2. SQL部分：主要涉及SQL语言的基本语法、查询、数据操作等内容。

3. 数据库管理部分：包括数据库的安装、配置、备份恢复、性能优化等内容。

4. 安全性部分：主要介绍数据库的安全管理和权限控制等内容。

5. 高级应用开发部分：包括存储过程、触发器、PL/SQL等高级内容。

三、Oracle OCP中文题库的重要性1. 作为备考工具：Oracle OCP中文题库是备考的重要工具，通过不断地练习题库中的题目，可以使考生更加熟练地掌握数据库的相关知识和技能。

2. 考核知识点：题库中的题目涵盖了Oracle数据库的各个知识点，考生可以通过题库了解考试的重点和难点。

3. 提高应试技巧：通过练习题库，考生可以提高自己的答题速度和技巧，为顺利通过考试打下基础。

四、如何有效使用Oracle OCP中文题库1. 制定学习计划：考生应根据自身的实际情况，合理制定学习计划，安排每天的学习时间，保证有足够的时间来练习题库。

2. 分模块练习：将题库中的题目按照不同的模块进行分类，有条不紊地进行练习，逐渐提高各个模块的掌握程度。

3. 定期自测：在练习题库的过程中，考生应定期进行自测，了解自己的学习情况和水平，及时调整学习计划。

4. 结合其他学习资源：除了题库，考生还可以结合其他学习资源，比如教材、考试指南、网络课程等，全面提升自己的学习效果。

五、总结Oracle OCP中文题库是备考Oracle OCP认证考试的重要辅助工具，考生应合理利用题库，制定科学的学习计划，通过不断的练习和自我调整，提高自己的学习和应试技巧，从而顺利通过考试取得认证资格。

OCP考试052最新考试题库原题 (2)

实用文档052题库解析OCP考试052最新考试题库原题-11-20180817⼆十.Initialization parameter70. which is true about initialization parameter administration?A) Some Dynamic parameter values can be modiﬁed to affect only onesessionB) Dynamic parameters, when modiﬁed, always revert to their originalvalues after the database instance is restartedC) Static parameter values can be changed in the spﬁle only by usingthe alter system command with scope=spﬁle 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 pﬁle 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 spﬁle is used.Answer：C72. which three statements are true about initialization parameters and ﬁles?A) An idle instance must start with a PFILE.B) Session modiﬁable 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 modiﬁable 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 modiﬁable 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 conﬁgure and schedule on- line database backups to run automatically?A) the RMAN command line utilityB) SQL*PLUSC) Enterprise Manager Cloud ControlD) The Database Conﬁguration 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 deﬁned.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 ﬁles after a database instance is shut down normallyAnswer：DE81. Which command is used to display ﬁles 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 speciﬁed 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) Bigﬁle tablespaces can be dictionary or locally managed.Answer：BCFG85. Your database is conﬁgured in archivelog mode. The USERS01 tablespace is currently online.You are required to take the tablespace ofﬂine.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 ﬁles?A) It can be enabled for a new data ﬁle that is added to a tablespace only if the existing data ﬁles in that tablesapce have autoextend enabled.B) It can be enabled only for data ﬁles in non-OMF tablespaces.C) It can be enabled for data ﬁles only in bigﬁle tablespaces.D) It can be enabled for data ﬁles only in smallﬁle tablespaces.E) It can be enabled for an existing data ﬁle 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 deﬁned.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 （已验证。

OCP考试052最新考试题库原题-6-20180615

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认证考试题库

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认证考试题库】。

(完整word版)oracle考试试题及答案,推荐文档

试题一一、填空题(每小题4分，共20分)1、数据库管理技术经历了人工管理、文件系统、数据库系统三个阶段2、数据库三级数据结构是外模式、模式、内模式3、Oracle数据库中，SGA由数据库缓冲区，重做日志缓冲区，共享池组成4、在Oracle数据库中，完正性约束类型有Primay key约束。

Foreign key约束，Unique约束，check约束，not need约束5、PL/SQL中游标操作包括声明游标，打开游标，提取游标，关闭游标二、正误判断题（每小题2分，共20分）1、数据库中存储的基本对象是数据（T）2、数据库系统的核心是DBMS（T）3、关系操作的特点是集合操作（T）4、关系代数中五种基本运算是并、差、选择、投影、连接（F）5、Oracle进程就是服务器进程（F）6、oraclet系统中SGA所有用户进程和服务器进程所共享（T）7、oracle数据库系统中数据块的大小与操作系统有关（T）8、oracle数据库系统中，启动数据库和第一步是启动一个数据库实例（T）9、PL/SQL中游标的数据是可以改变的（F）10、数据库概念模型主要用于数据库概念结构设计（）三、简答题（每小题7分，共35分）1、何谓数据与程序的逻辑独立性和物理独立性？2、试述关系代数中等值连接与自然连接的区别与联系？3、何谓数据库，数据库设计一般分为哪些阶段？4、简述Oracle逻辑数据库的组成？5、试任举一例说明游标的使用方法？五、设有雇员表emp(empno,ename,age,sal,tel,deptno),其中：empno-----编号，name------姓名，age -------年齡，sal-----工资，tel-----电话deptno-----部门号。

请按下列要求分别晨SQL*PLUS下编程。

（每小题3分，共15分）•1、查询家有电话的职工信息。

•2、查询工资在500至800元之间的雇员信息•3、按年龄递增顺序显示雇员编号、姓名、年龄、工资•4、求部门号为D_01的平均工资•5、查找部门号为D_01的40岁以上而工资在400元以下的雇员名单。

OCP认证052最新考试原题题库解析-9-20180803

十五.External Table 37. which is true about external tables? A) Segments are allocated for external tables. B) They may have indexes. C) They do not support partitioning. D) The ORACLE_DATAPUMP access driver can be used to write data to external tables. E) DML operations may be performed on external tables. Answer：D
33. Which three are true about auditing? A) Auditing is active only when the database is OPEN. B) Audit records are always stored in the database. C) Audit of the use of system privileges can be enabled for individual database users. D) DDL statements can be audited when they fail to execute. E) All Oracle auditing operations occur by default. F) DML statements can be audited when they execute successfully.
Answer：CDF
34. Which four are true about auditing? A) DML statements can be audited when they fail to execute B) Select statements can be audited when they execute successfully. C) All Oracle auditing operations occur by default. D) No Oracle auditing operations occur by default. E) DDL statements can be audited when they fail to execute. F) Some auditing is active before the database is open. G) Audit records are never stored in the database. H) Audit records are always stored in the database. Answer：ABEF

【OCP-052】最新考试题库(考试原题)-3-20180525-

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

ORACLE期末考试试题及答案

ORACLE期末考试试题及答案一、选择题（每题2分，共40分）1. ORACLE数据库系统属于以下哪一种数据库类型？A. 关系型数据库B. 层次型数据库C. 网状型数据库D. 对象-关系型数据库答案：A2. 在ORACLE中，以下哪个命令用来创建一个表？A. CREATE TABLEB. CREATE VIEWC. CREATE INDEXD. CREATE SEQUENCE答案：A3. 数据库的三级模式结构包括以下哪几个层次？A. 外模式、概念模式、内模式B. 概念模式、内模式、物理模式C. 外模式、内模式、物理模式D. 外模式、概念模式、物理模式答案：A4. 在ORACLE中，以下哪个命令用来删除一个表？A. DROP TABLEB. DELETE TABLEC. DROP VIEWD. DELETE VIEW答案：A5. 数据库事务的四个特性包括以下哪些？A. 原子性、一致性、隔离性、持久性B. 原子性、一致性、独立性、持久性C. 原子性、一致性、并发性、持久性D. 原子性、一致性、并发性、独立性答案：A6. 在ORACLE中，以下哪个命令用来修改表的结构？A. ALTER TABLEB. MODIFY TABLEC. UPDATE TABLED. ALTER VIEW答案：A7. 数据库的备份分为以下哪几种类型？A. 冷备份、热备份、逻辑备份B. 冷备份、热备份、物理备份C. 冷备份、热备份、完全备份D. 冷备份、热备份、增量备份答案：D8. 在ORACLE中，以下哪个命令用来创建一个索引？A. CREATE INDEXB. CREATE TABLEC. CREATE VIEWD. CREATE SEQUENCE答案：A9. 数据库的并发控制主要包括以下哪些方法？A. 乐观并发控制、悲观并发控制、时间戳并发控制B. 乐观并发控制、悲观并发控制、锁并发控制C. 乐观并发控制、悲观并发控制、令牌并发控制D. 乐观并发控制、悲观并发控制、版本并发控制答案：B10. 在ORACLE中，以下哪个命令用来创建一个序列？A. CREATE SEQUENCEB. CREATE TABLEC. CREATE VIEWD. CREATE INDEX答案：A二、填空题（每题2分，共20分）1. 在ORACLE中，使用______命令可以创建一个表。