下载  >  考试认证  >  Oracle认证  > Oracle 1z0-052题库OCP考试题

Oracle 1z0-052题库OCP考试题 评分

刚考的Oracle 1z0-052认证,覆盖率90%一次性通过有需要的童鞋请下载!
Pir宫texe COME C日 UT日 hared po 58720256 large pool 41罗430县 java pool 419430 GA Targe七 176160768 DEFAulT bu 100白6329日 3 hares工o 83886088388508 PGA里a可e七 17440512 6r吕e1ec七d 弓e0ndeu七i0n: OVE T 一-一一一- shared poo 5日72口25日 gE p 4194304 java pool 419430县 GA① arget 19293798生 DEFAUT卫h11 117440512 3 hared工O 日3880吕 吕3吕8百08 PG点axge七 10066329g 1ec七ed 卫 hird exe1tia COME C吕 IS shared poo 62914560 agp以1 10063296 java pool 41943D且 SGA Targe七 192937984 DEFAULT bu 83吕808 3 hared工 38860838868 PGA Targe七 10后白29后 工口W吕吕e1ec七ed A. The data base instance is running with manual pga managemen B The databaseinstanceis running with manual shared memary management C The database instance has the memory target value set to a nonzero value D.Al1 sessions are connected to the database instance in dedi cated mode. and no rman or parallel query operations have been performed Correct answers c Explanation 3: Identify two situations in which you can use Data Recovery Advisor for recovery:(Choose two. 选项 A. The database files are corrupted whenthe database is open. BThe user has dropped an important table that needs to be recovered C The archived redo log files are missing for which the backup is not available D. The data base is not opering because the required database files are missing Correct answers 4: You have two tables withreferential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage which can be inserted as part of the same transaction View the exhibit to examine the commands used to create tables Which action would you take to delay the referential integrity checking until the end of the lIansuchull 下RA卫里AB园1teM9(itEM0d已m取B思R(4)已C8 TRAINT PK PFIMARY KZY DEFERRABLE 工T工 AtY aMMED工ATB item desc VARCHAR2 (40) goh Nu price NUMBER(10, 2)) CBEAIE TABLE cider( crd id char(5)丹时L item_code NUMEER(4)REFERENCES iter.s(item_code)DN DEIETE CASCADE DEFZRRABLB 工工AY工MED工AB qty NUMBER i 3)CONSTRAINT chk CHECK(aty >U), ord it DATE) Aset the constraint to deferred before starting the transaction B. Alter the constraint to novalidate state before starting the transaction CEnble he i esutrhble inode or thie sessiu be lore slarliiy the irutisuclioil D Set the COMMIT WAIT Parameter to FORCE WAIT for the session before starting the transaction. Correct Answers: A Explanation 5: Your database is open and the lis tener listener is running. The new dBa of the sys the listener by using the command LSNRCTLA STOP What happens to the sessions that are presently connected to the database instance? A. The sessions are able to perform only queries B The sessions are not affected and continue to function normally C The ses sions are terminated and the active transactions are rolled back S arc not allowcd to pcrform any opcrations till the listener is startcd Correct answers: B Explanation: 6: You executed this command to create a temporary table SQL> CREATE GLOBAL TEMPORARY TABLE report work area(startdate DaTE, enddate DATE, class CHAR(20))ON COMMITPRESERVE ROWS statement is truc abou rows inscr the REPORt WORK ARea tablc during transaction A. The rows stav in the table only until session termination B The rows stay in the tablc only until the ncxt transaction starts on thc tablc C. The rows are visible to all current sessions after the transaction is committed D The rows stay available for subs eluent sessions after the transaction is committed Correct Answers: A Explanation: 7: In which of the scenarios will the dBa perform recovery?( Choose all that apply. 选项 A. The alert log file is corrupted B a tablespace is accidentally dropped C. One of the redo log members is corrupted D a database user terminates the session abnormally E. The hard disk on which the data lile is stored is corrupted Correct Answers:B E 8:Notc the following structur cs in your database scrvcr 2. OS Blocks 3. Tab 4.S 5. Oracle data block Which option has the correct arrangement of these structures from the smallest. to the largest? A.2.5,1,4,3 B.1、2,3,4,5 C.5,2,1,3,4 D.2, Correct Answers: A Explanation: 9: You are working on an instance started using the SPFIlE. You want to move the Flash Recovery Area of your database to a new location. You want the flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order 1 Shut down the instance 2) Change the value of the db recoVery FILe dESt initialization parameter to a new 3) Exccutc thc ALTER DATABASE FLASHBACK OFF command 4 Start up che instance and mount the database 5) Execute the ALTER DATAB ASE FLASHBACK on command Den the databas Sclect the correct or dcr in which thesc tasks nced to bc pcrformcd B.1,4,3,2,6,5 C.1,42、623,5 D.3、2,1,4.5,6 Correct Answers: A Explanation: 10: A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database nstance by merely logging in to a remote machine? a Set remote os roles to FALSE B Set the Os roles parameter tO FALSE C Set the remote os authen t parameter to FAlse D Set the REMOtE LoGin PASSWORd FILE parameter to NONE Correct Answers: c Explanation: 11: Your database instance is started using the server parameter file(SPFILE). You executed a command to change the value of the loa BUffER initialization parameter ALTER SYSTEM SET LOG BUFFER=32V SCOPE=BOTH What would be the outcome of this command? A. The command succeeds only if Automatic Memory Management is not enabled B The command succeeds, but you need to restart the clatabase for changes to take effect C The command returns an crror because the si7.c of the redo log butfcr cannot be changcd dynamically DThe parameter value is changed and it comes into effect. as soon as space becomes available in the System Global Area(SGa) Correct Answers: C Explanation: 12: The databa se instance is currently using SPFILE. view the Exhibit and ezamine the error that you received while running the de Structure Integrity check. Given below are the steps to recover fr om the eror inrandom order shut down the instance, if not area dy done 2. Copy one of the remaining cantrol fles to a new location 3. Change the walue of the CoNtROL FileS initialization patameter to correspond to the new location of the control files 4. Start up the database instance to the NOMOUNT stage to the point of failure of the control file 6 the databa Identify the correct sequμELce口fsps 科图4中品d的307,1 A.1.2.4.3.5.6 B2,4,3,5, 6: 1 not required C 4,5,6, 2, 3: 1 not required D5, 2, 3,4, I and b not required Correct ansers:A Explanation 13: view the Exhibit and ezamine the parameters User A execut es the following command to up date the traNs table SQL> UPDATE B trans SET tr am=tr amt+so0 WhERE c code=C005 Before use A issues a COMiMIT o ROLLBACK comtrand, user B executes the following command on the trans table SQL> ALTER TABLE trans MODIFY (tr type VARCHAR2(3)); What would happen inthis scenario? NAME TYPE VA工UTE ddl lock timeout 1n七eger distributed_lock_timeout nteger Irm1 locks integer 748 gc_files_to_locks lock name space Ick Sc 口ea卫 FALSE A The alter tab le command modifies the column successfull B The DDL operat on gets higher pri ority and transaction for user Ais rolled back C The ALTER TABLE command waits indefinitely until user A ends the transacti on D The ALTER TAB LE cOmmand fails at er wating for 60 seconds due to the resource being busy Correct answers dy Explanation: 14: View the exhibit to examine the details for an incident Which st atement is true regarding the status ofthe ind dent? Inc ident Detail: 3937 hx山2,2 BEnT PM DEAd说( m图e丑 s IADCH:Oa-1 Corban s=120537,Paaa4 机铅 H群加影指T the Ready Acth ye 副2们器围 m结?A园aqa 制( Desable Purgin s配ey=ma FELICE 时上 时v ared o ft加 lurciicrinthorir E a以园 A The DBAis working on the indi dent and prefers that the inci dent be kept in the ADr B.The incident is now in the Done state and the ADR can select the incident to be purged. C. The incident has bccn newly crcatcd and is in thc proccss of collecting diagnostic information D The data collection for the incident is complete and the can be packaged and sent to Oracle support Correct Answers: D Explanation 15: LSer A executes the following command to drop a large table in your database SOL> DROP TABLE trans While the drop table operation is in progress, user B executes the following command on the same SQL> DELETE FROM trans WhErE tr type" SL Which statement is true regarding the DEletE command A It fails to delete th ds because the e locked in share mode B It deletes the rows succes sfully because the table is locked in ShArE mode C It fails to delete the records because the table is locked in exclusive made D It deletes thc rows successfully bccausc the table is locked in SHARE ROW EXCI USTVE mo Correct Answers: C Explanation: 16: Which is the correct description of a pinned buffer in the clatabase buffer cache? A Thc buffer is currently bcing accessed B The buffer is empty and has not been used C. The contents of the buffer have changed and must be flushed to the disk by the dbwn process D The buffer is a candidate for immediate aging out and its contents are synchronized with the block n the disk

...展开详情
所需积分/C币:10 上传时间:2014-09-19 资源大小:16.47MB
举报 举报 收藏 收藏
分享 分享
oracle数据库1Z0-052认证题库v10.02

oracle数据库1Z0-052认证题库v10.02

立即下载
ocp 1Z0-052模拟器+210题库vce.zip

OCP 认证考试1z0-052 210题题库文件PDF,题库试题VCE和考试模拟器打包下载

立即下载
Oracle.1z0-061 题库

Oracle Database 12c : SQL Fundamentals 总共有75题 有正确答案

立即下载
oracle 1z0-052题库

oracle 1z0-052 题库,一共172题,应该官方培训的

立即下载
Oracle 1z0-052题库OCP考试题

刚考的Oracle 1z0-052认证,覆盖率90%一次性通过有需要的童鞋请下载!

立即下载
oracle 1z0-042题库

oracle oca考试 1z0-042题库

立即下载
oracle 1Z0-047题库

Oracle学习资料,Oracle ocp认证 047题库资料。格式pdf;望对大家有用;大家可以下载,学习交流经验;

立即下载
Oracle 1Z0-051题库

很好的oracle资料。和大家分享一下。希望大家支持,喜欢。

立即下载
最新oracle 1z0-007题库

报名辅导班给的,10年的最新题库,vce格式,非常方便!

立即下载
最新Oracle 1z0-040题库及答案

最新Oracle 1z0-040模拟考试题库 答案及详解 Oracle Database 10g: New Features for Administrators

立即下载
Oracle 1z0-051题库OCP考试题

刚考的Oracle 1z0-051认证 覆盖率90%的题库有需要的请下载

立即下载
Oracle_OCA_1Z0-052认证题库

Oracle_OCA_1Z0-052认证题库 不知道有没过时

立即下载
Oracle OCA 1Z0-047 题库

Oracle 1Z0-047 题库 Oracle Database Sql Expert ,Oracle9i/10G/11G 使用

立即下载
ORACLE OCP 1Z0-043题库

ORACLE OCP 1Z0-043题库

立即下载
Oracle SOA 1z0-451题库

Oracle SOA 1z0-451题库,Pass4Sure的,有90%以上的命中率

立即下载
Oracle 1z0-051模拟题库

Oracle 1z0-051考试,OCA认证的第一阶段考试模拟题库。这个考试比较简单,而且可以无监考考试,大家可以参考练习

立即下载
oracle ocp认证考试最新题库052-Oracle.HotCerts.1Z0-052

最新的oracle ocp认证考试题库,共一百多道题,为全英文原版文档,很好的练习材料

立即下载
Oracle 1z0-054最新题库分享

Oracle 1z0-054最新题库分享,更新日期:2009-11-19

立即下载
Oracle 1Z0-042 最新题库 part1

2009年3月31日,本人满分通过Oracle 1Z0-042考试,有意准备参加这个考试的同仁,请下载这个题库。 每道题都有标准答案,你可以采用模拟考试随机抽取试题的做法,也可以把题库的所有题目进行练习实践。非常实用,非常准确。分数是要的高一点儿,但绝对物有所值。

立即下载
oracle 1z0-042 考试题库

自己想考oracle ocp,所以四处收集,一共5个pdf题库文档。希望对大家有用。

立即下载