OCP-1Z0-052
文章平均质量分 65
Riveore
这个作者很懒,什么都没留下…
展开
-
OCP-1Z0-052-V8.02-91题
91. View the Exhibit to examine the error that occurred during the database startup.You opened an RMAN session for the database. To repair the failure, you executed the followingcommand as the原创 2013-09-02 11:58:18 · 11819 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-92题
92. You executed the following commands in an RMAN session for your database instance that hasfailures: RMAN> LIST FAILURE; After some time, you executed the following command in the same sess原创 2013-09-02 13:05:03 · 11396 阅读 · 5 评论 -
OCP-1Z0-052-V8.02-77题
77. You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: OR原创 2013-09-17 11:34:02 · 8085 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-79题
79. You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed原创 2013-09-17 11:16:11 · 8945 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-80题
80. You perform differential incremental level 1 backups of your database on each working day and level 0backup on Sundays, to tape. Which two statements are true about differential incremental原创 2013-09-17 10:55:20 · 11258 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-23题
23. Note the following structures in your database server:1: Extents 2: OS Blocks 3: Tablespace 4: Segments 5: Oracle Data Block Which option has the correct arrangement of these structu原创 2013-09-17 13:22:41 · 2252 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-72题
72. You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:1: Shut d原创 2013-09-17 14:49:51 · 7774 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-82题
82. You are managing an Oracle Database 11g database with the following backup strategy:1) On Sunday, an incremental level 0 tape backup is performed.2) Monday through Saturday, a cumulative i原创 2013-09-17 10:59:06 · 9943 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-81题
81. You are managing an Oracle Database 11g database with this backup strategy:- Every Sunday night, level 0 backup is performed.- On Monday night and subsequent days, level 1 incremental back原创 2013-09-17 10:56:01 · 6088 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-157题
157. Examine the commands executed in the following sequence:1: SQL> CREATE ROLE mgrrole; 2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;3: SQL> GRANT select,update O原创 2013-09-17 16:34:39 · 7715 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-20题
20. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when t原创 2013-10-03 14:20:58 · 9930 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-11题
11. Identify the memory component from which memory may be allocated for:1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup a原创 2013-10-03 11:53:52 · 11270 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-12题
12. Which is the correct description of a pinned buffer in the database buffer cache?A.The buffer is currently being accessed.B.The buffer is empty and has not been used.C.The contents of原创 2013-10-03 13:24:05 · 11557 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-17题
17. Note the functionalities of various background processes:1: Perform recovery at instance startup. SMON2: Free the resources used by a user process when it fails. PMON3: Cleanup the databas原创 2013-10-03 13:52:43 · 9349 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-19题
19. Which two statements about the background process of thedatabase writer are true? (Choose two.) A.It is possible to have multiple database writers in an Oracle instance.B.It writes dirty原创 2013-10-03 14:07:55 · 9421 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-21题
21. Which three statements are true about logical structures of the Oracle database? (Choose three.)A.Each segment contains one or more extents.B.Multiple tablespaces can share a single data f原创 2013-10-03 14:34:11 · 10922 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-25题
25. Which three operations require undo data? (Choose three.)A.committing a transaction B.flashing back a transactionC.recovering a failed transactionD.running a read-consistent query原创 2013-10-03 20:30:39 · 9532 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-27题
27. Which two statements are true regarding transactions in an Oracle database? (Choose two.)A.Multiple transactions can use the same undo segment.B.A transaction is assigned an undo segment w原创 2013-10-03 21:14:54 · 11738 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-29题
29. Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee:原创 2013-09-18 11:48:39 · 9442 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-26题
26. Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE parameter is valid in both automatic and原创 2013-10-03 20:51:53 · 13169 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-13题
13. You have executed this command to change the size of the database buffer cache:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;System altered. To verify the change in size, you executed this原创 2013-10-03 13:40:43 · 11552 阅读 · 4 评论 -
OCP-1Z0-052-V8.02-16题
16. Note the following functionalities of various background processes:1: Record the checkpoint information in data file headers. CKPT2: Perform recovery at instance startup. SMON3: Cleanup un原创 2013-10-03 13:45:04 · 11827 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-23题
23. Note the following structures in your database server:1: Extents 2: OS Blocks 3: Tablespace 4: Segments 5: Oracle Data Block Which option has the correct arrangement of these structu原创 2013-10-03 14:36:37 · 6950 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-155题
155. The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using thiscommand: SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;The user SCOTT ex原创 2013-09-18 10:08:20 · 8764 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-156题
156. Examine the following steps performed on a database instance:1: The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.2: The SKD user creates a table. 3原创 2013-09-18 09:42:46 · 8759 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-30题
30. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?A.when the data file of the undo tablespace is autoextensibleB.when there are more than one und原创 2013-10-03 22:10:53 · 11130 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-31题
31. Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled? A.It is the time period after which the undo data becomes obsolete.B.It is the time per原创 2013-10-03 22:17:04 · 10607 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-33题
33. Some non-DBA users in your database have been granted ANY TABLE system privileges and theyare able to access data dictionary base tables. You decide to restrict their access to data dictionary原创 2013-10-04 14:33:32 · 8964 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-34题
34. A user, who is authenticated externally, logs in to a remote machine and connects to the databaseinstance. What action would you take to ensure that a user cannot connect to the database insta原创 2013-10-04 14:43:49 · 9747 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-39题
39. Which two statements are true about standard database auditing? (Choose two.)A.DDL statements can be audited.B.Statements that refer to stand-alone procedure can be audited.C.Operation原创 2013-10-04 22:38:37 · 10857 阅读 · 1 评论 -
OCP-1Z0-052-V8.02-38题
38. To make audit information more productive, the DBA executes the following command before startingan audit operation: SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;Which stat原创 2013-10-04 22:46:09 · 11659 阅读 · 1 评论 -
OCP-1Z0-052-V8.02-161题
161. In your database instance, the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users:1: The user account must be lo原创 2013-10-04 23:21:51 · 8731 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-36题
36. In your production database, data manipulation language (DML) operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. You原创 2013-10-04 22:56:57 · 10998 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-35题
35. You executed the command to create a password file in the database server:$ orapwd file=orapworcl entries=5 ignorecase=NWhich statement describes the purpose of the above password file?原创 2013-10-04 19:28:06 · 11637 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-37题
37. You execute the following command to audit database activities: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command? A.One audit recor原创 2013-10-04 22:58:46 · 10803 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-78题
78. You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose原创 2013-10-06 20:03:09 · 8071 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-87题
87. You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in原创 2013-10-08 16:18:18 · 9650 阅读 · 1 评论 -
OCP-1Z0-052-V8.02-53题
53. You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements a原创 2013-10-09 14:07:00 · 11226 阅读 · 1 评论 -
OCP-1Z0-052-V8.02-51题
51. In a system, large online transaction processing (OLTP) jobs run during the daytime that require alarge database buffer cache. In the night, the system supports batch jobs that require a highe原创 2013-10-09 14:07:44 · 10605 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-123题
123. You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened:1: SGA is allocated. 2: Co原创 2013-10-09 14:16:34 · 7429 阅读 · 0 评论