OCP 052
EVISWANG
这个作者很懒,什么都没留下…
展开
-
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (
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 the th原创 2016-01-24 11:07:06 · 636 阅读 · 0 评论 -
46: Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter
46: Which two statements are true about setting the FAST_START_MTTR_TARGETinitialization parameter to a nonzero value? (Choose two.)选项A.The MTTR advisor will be disabled.B.Automatic checkpoint原创 2016-01-13 18:42:50 · 1373 阅读 · 0 评论 -
50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert
50:Which two statements are true about alerts? (Choose two.)选项A.Clearing an alert sends the alert to the alert history.B.Response actions cannot be specified with server-generated alerts.C.The原创 2016-01-21 12:35:09 · 2072 阅读 · 0 评论 -
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the proce
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept( v_deptno NUMBER, v_dname VARCH原创 2016-01-21 15:37:42 · 1487 阅读 · 0 评论 -
Identify two situations in which the block header grows in a data block. (Choose two.) 选项 A.when ro
Identify two situations in which the blockheader grows in a data block. (Choose two.)选项A.when row directories need more row entriesB.when there is rowmigration in the data blockC.when there is原创 2016-01-21 15:48:36 · 1303 阅读 · 0 评论 -
Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able
63: Some non-DBAusers in your database have been granted ANY TABLE system privileges andthey are able toaccess data dictionary base tables. You decide to restrict their access to datadictionaryobj原创 2016-01-21 15:42:27 · 770 阅读 · 0 评论 -
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, yo原创 2016-01-21 15:52:10 · 820 阅读 · 0 评论 -
Your database instance is running with full workload after database creation. You have decided to us
Your database instance is running with full workload after database creation. You have decidedto use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity ofthe u原创 2016-01-21 15:58:34 · 1157 阅读 · 0 评论 -
Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can
Which three statements are correct about temporary tables? (Choose three.)A. Indexes and views can be created on temporary tablesB. Both the data and structure of temporary tables can be exported原创 2016-01-21 16:40:19 · 1129 阅读 · 0 评论 -
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPAC
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.)A. T原创 2016-01-21 16:29:41 · 1210 阅读 · 0 评论 -
You want to configure and schedule offline database backups to run automatically. Which tool or util
You want toconfigure and schedule offline database backups to run automatically. Whichtoolor utility wouldyou use to achieve this?A.the XML scriptB.the PL/SQL scriptC.the DBMS_SCHEDULER packag原创 2016-01-21 16:35:48 · 1123 阅读 · 0 评论 -
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database i
You are working on a database that must be functioning 24 hours a day, 7 days a week. Thedatabase is configured in ARCHIVELOG mode. Which two options do you have for performinguser-managed backups原创 2016-01-21 16:50:26 · 1068 阅读 · 0 评论 -
Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not
Which statement istrue about loading data using the conventional path of SQL*Loader?A.Redo is notgenerated while performing conventional path loads.B.Only PRIMARY KEY,UNIQUE KEY, and NOT NULL cons原创 2016-01-24 11:52:23 · 1163 阅读 · 0 评论 -
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or a
User SCOTT executes the following command on the EMP table but has not issued COMMIT,ROLLBACK, or any data definition language (DDL) command:SQL> SELECT ename FROM emp2 WHERE job='CLERK' FOR UPD原创 2016-01-24 11:49:09 · 760 阅读 · 1 评论 -
QUESTION 56 Automatic Shared Memory Management is disabled for your database instance. You realize t
QUESTION 56 Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, result原创 2016-01-13 18:44:25 · 1028 阅读 · 0 评论