![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OCP
文章平均质量分 76
xiadingling
天道酬勤
展开
-
CONTROL_FILE_RECORD_KEEP_TIME
CONTROL_FILE_RECORD_KEEP_TIME该初始化参数用于指定控制文件可重用记录被覆盖之前可保留的最小天数,其数值范围为0~365,默认值为7.初始化参数Control_file_record_keep_time是动态参数,可以使用ALTER SYSTEM命令进行修改。示例如下:SQL>ALTER SYSTEM SET Control_file_record原创 2013-01-15 16:35:04 · 869 阅读 · 0 评论 -
OCP-043 ORA_SDTZ time zone enviroment variables
107. The current time zone for one of the user sessions is set to the database local time zone. For oneapplication, the user session requires the time zone to be set to the local operating system ti原创 2012-09-10 16:47:14 · 1431 阅读 · 0 评论 -
OCP-043session_longops
V$SESSION_LONGOPSThis view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions,原创 2012-09-07 16:44:14 · 499 阅读 · 0 评论 -
OCP-043 automatic PGA
81. You are working in a dedicated server environment. Your database is running in the automaticProgram Global Area (PGA) memory management mode. Which two statements are correct in thisscenario?原创 2012-09-07 15:57:40 · 405 阅读 · 0 评论 -
OCP-043 large pool
80. Your database is using shared server configuration. Which optional memory structure would youconfigure to store the User Global Area (UGA) information and improve the shared pool performance?A原创 2012-09-07 15:46:41 · 428 阅读 · 0 评论 -
OCP-043 DB_nK_CACHE_SIZE
DB_nK_CACHE_SIZEPropertyDescriptionParameter typeBig integerSyntaxDB_[2 | 4 | 8 | 16 | 32]K_CACHE_SIZE = integer [K | M | G]Default value0 (additional block原创 2012-09-07 15:32:32 · 487 阅读 · 0 评论 -
OCP-043 STATISTICS_LEVEL initialization parameter
STATISTICS_LEVELPropertyDescriptionParameter typeStringSyntaxSTATISTICS_LEVEL = { ALL | TYPICAL | BASIC }Default valueTYPICALModifiableALTER SESSION,原创 2012-09-07 15:14:29 · 892 阅读 · 0 评论 -
OCP-043 alter diskgroup add template
68. You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute thefollowing command to create a template for the disk group:ALTER DISKGROUP dgroup1ADD TEMPLATE my_temp原创 2012-09-07 14:44:04 · 1177 阅读 · 0 评论 -
OCP-043 alter diskgroup power
67. You are using an Automatic Storage Management (ASM) instance to manage the database files ofyour production database. After adding a new disk group to the ASM instance, you execute the following原创 2012-09-07 11:14:56 · 990 阅读 · 0 评论 -
OCP-043 drop diskgroup
66. In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,DGROUP1, is no longer required and you want this disk group to be removed. You execute the followingcomma原创 2012-09-07 10:49:16 · 530 阅读 · 0 评论 -
OCP-043 Sorted Hash Cluster
52. You are designing an application for a telecom company and you have been asked to design adatabase table to facilitate monthly bill generation. The bill would include details of customer calls,原创 2012-09-06 10:58:12 · 666 阅读 · 0 评论 -
OCP-043 bitmap indexes on index-Organized Tables
50. While designing your database, you have created the EMPLOYEES table as an indexorganized table(IOT). You want to create a bitmap index on the JOB_ID column to make queries faster.Which task原创 2012-09-06 10:27:07 · 458 阅读 · 0 评论 -
OCP-043 monitor index use
56. You have many users complaining about slow inserts into a large table. While investigating the reason,you find that the number of indexes on the table is high. You want to find out which indexes原创 2012-09-06 14:20:07 · 427 阅读 · 0 评论 -
OCP-043 SHRINK SPACE CASCADE
47. View the Exhibit and examine the properties of the USERS tablespace.You execute the following statement to shrink the TRANS table existing on the USERS tablespace:SQL> ALTER TABLE trans SHRINK原创 2012-09-06 09:52:27 · 1100 阅读 · 0 评论 -
OCP-047 SET CONSTRAINTS DEFERRABLE OR IMMEDIATE
242. View the Exhibit and examine the structure of the CUST table.Evaluate the following SQL statements executed in the given order:ALTER TABLE cust ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id)原创 2012-08-28 10:35:17 · 589 阅读 · 0 评论 -
OCP-047 group by rollup and where clause
225. View the Exhibit and examine the descriptions of ORDER_ITEMS and ORDERStables.You want to display the CUSTOMER_ID, PRODUCT_ID, and total(UNIT_PRICE multiplied by QUANTITY) for the order place原创 2012-08-28 09:31:42 · 766 阅读 · 0 评论 -
OCP-043 listener to be password protected(change_password)
108. You want your listener to be password protected to prevent it from being shut down. You want toaccomplish this task while the listener is functional. Which method could you use to achieve this原创 2012-09-10 16:52:28 · 672 阅读 · 0 评论 -
OCP-043 Pending Area
92. You want to create a consumer group, GROUP1, and you execute the following command in thecommandlineinterface:SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP =>'group1原创 2012-09-10 14:48:43 · 914 阅读 · 0 评论 -
OCP-DBMS_RESOURCE_MANAGER_PRIVS
93. You want to create a consumer group, GROUP1, and you execute the following command in thecommandlineinterface:SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP =>'group1原创 2012-09-10 15:08:23 · 1069 阅读 · 0 评论 -
ocp-043 DB_CREATE_FILE_DEST
A50You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change trackin原创 2013-01-10 10:19:24 · 552 阅读 · 0 评论 -
042 - dbms_rls.add_policy
245.You want to enforce a company's business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_原创 2013-01-08 08:42:58 · 1266 阅读 · 0 评论 -
dbms_rls
dbms_rlsOverviewThe functionality to support fine-grained access control is based on dynamic predicates, where security rules are not embedded in views, but are acquired at the statement p原创 2012-12-20 15:37:46 · 625 阅读 · 0 评论 -
utl_file_dir
181. QUESTION 15In your www.data-lab.org production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine原创 2012-12-20 08:56:29 · 758 阅读 · 0 评论 -
参数 PLSQL_OPTIMIZE_LEVEL
196. QUESTION 32In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2.What would this setting achieve?A> It degrades the run time and compiler performance.B> It p原创 2012-12-19 11:05:09 · 2048 阅读 · 0 评论 -
OCP-047 insert into values(defualt)
67. View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE andORDER_TOTAL have the default values 'direct' and 0 respectively.Which two INSERT statements are valid?原创 2012-11-24 20:38:38 · 1282 阅读 · 0 评论 -
o43 /etc/oratab
179. QUESTION 13 The operating system file /etc/oratab in the Linuxplatform gets updated whenever you create a newdatabase on the same host machine. What kind of information is stored in this原创 2012-12-01 13:45:12 · 630 阅读 · 0 评论 -
047 the steps for a correlated subquery
68. The following are the steps for a correlated subquery, listed in random order:1) The WHERE clause of the outer query is evaluated.2) The candidate row is fetched from the table specified in th原创 2012-11-24 20:56:52 · 1382 阅读 · 0 评论 -
OCP-047 grant all to public
104. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the followingGRANT command:GRANT ALLON orders, order_itemsTO PUBLIC;What correction needs to be done to the above原创 2012-10-17 17:02:36 · 2412 阅读 · 0 评论 -
OCP-047 REGEXP_INSTR()
91. View the Exhibit and examine the data in the LOCATIONS table.Evaluate the following SQL statement:SELECT street_addressFROM locations WHERE REGEXP_INSTR(street_address,'[^[:alpha:]]') = 1;--原创 2012-08-20 16:17:33 · 1054 阅读 · 0 评论 -
OCP-043 DBMS_SCHEDULER.LOGGING_RUNS
102. While creating a job class using the DBMS_SCHEDULERpackage, you set the logging leveltoLOGGING_RUNS. What would be the impact of this setting? A.Oracle Scheduler would write detailed informat原创 2012-09-13 16:02:41 · 538 阅读 · 0 评论 -
OCP-043 V$FLASHBACK_DATABSE_LOG & V$FLASHBACK_DATABASE_STAT
186. You executed the following query in your database:FROM V$FLASHBACK_DATABASE_LOG;What would you determine from the output?A.the time when the last flashback operation in your database was pe原创 2012-09-12 15:15:16 · 2173 阅读 · 0 评论 -
OCP-043 report need backup days 3
130. You executed the following command in Recovery Manager (RMAN) against your Oracle 10gdatabase:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?A.a list of files th原创 2012-09-11 14:56:19 · 3695 阅读 · 0 评论 -
OCP-043 SESSION_TRACE_DISABLE
134. In your test database, you find that a user's session is executing a lot of SQL statements, resulting inthe generation of a large number of trace files. While investigating the reason, you find原创 2012-09-11 16:42:59 · 683 阅读 · 0 评论 -
OCP-043 LIST in RMAN repository
131. Using the LIST command in Recovery Manager (RMAN), which two pieces of information from theRMAN repository can be listed? (Choose two.)A.backups that can be deletedB.stored scripts in the原创 2012-09-11 16:31:59 · 1376 阅读 · 0 评论 -
OCP-043 resources by using Resource Manager
86. In your production database, you observe that users' transactions are consuming a lot of resourcesand you plan to impose resource restrictions by using Resource Manager.For which three resourc原创 2012-09-10 09:42:01 · 409 阅读 · 0 评论 -
MERGE
79. View the Exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERStables.Evaluate the following MERGE statement:MERGE INTO orders_master oUSING monthly_orders mON (o.order_id = m.or原创 2012-08-17 14:20:51 · 794 阅读 · 0 评论 -
OCP-047约束延迟 SET CONSTRAINTS DEFERRABLE OR IMMEDIATE
23. View the Exhibit and examine the structure of the CUST table.Evaluate the following SQL statements executed in the given order:ALTER TABLE cust ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) D原创 2012-08-10 16:02:57 · 823 阅读 · 0 评论 -
OCP-047external table
16. EMPDET is an external table containing the columns EMPNO and ENAME. Whichcommand would work in relation to the EMPDET table?A.UPDATE empdet SET ename = 'Amit' WHERE empno = 1234.B.DELETE FRO原创 2012-08-09 14:38:24 · 1258 阅读 · 0 评论 -
DB_BLOCK_CHECKING
DB_BLOCK_CHECKINGPropertyDescriptionParameter typeStringDefault valueOFFModifiableALTER SESSION, ALTER SYSTEMRange of valuesOFF | LOW | MEDIUM | FULL原创 2012-08-31 09:53:09 · 1342 阅读 · 0 评论 -
OCP-042 fine-grained Auditing
13. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank.As part of the yearendtax and interest calculation process, all the rows in the table need to be a原创 2012-08-29 14:52:39 · 694 阅读 · 0 评论