ocp - 随笔分类 - 回家的流浪者

ocp 1Z0-042 121-178题解析

摘要：121. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating t... 阅读全文

posted @ 2015-02-27 15:08 回家的流浪者阅读(1386) 评论(0) 推荐(0)

ocp 1Z0-042 61-120题解析

摘要：61. View the Exhibit.Which statement regarding the dept and emp tables is true?A) When you delete a row from the emp table, you would receive a constr... 阅读全文

posted @ 2015-02-27 15:07 回家的流浪者阅读(2026) 评论(0) 推荐(0)

ocp 1Z0-042 1-60题解析

摘要：1. Because of a power outage,instance failure has occurred. From what point in the redo log does recovery begin and where does it end?A. Current redo ... 阅读全文

posted @ 2015-02-27 15:06 回家的流浪者阅读(1649) 评论(0) 推荐(0)

ocp 1Z0-043 131-205题解析

摘要：131. Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choosethree.)A. Ent... 阅读全文

posted @ 2015-02-27 15:05 回家的流浪者阅读(1832) 评论(0) 推荐(0)

ocp 1Z0-043 61-130题解析

摘要：61. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally m... 阅读全文

posted @ 2015-02-27 15:03 回家的流浪者阅读(2283) 评论(0) 推荐(0)

ocp 1Z0-043 1-60题解析

摘要：1.You observe that a database performance has degraded overa period of time. While investigating the reason, you find the size ofthe database buffer c... 阅读全文

posted @ 2015-02-27 15:01 回家的流浪者阅读(1891) 评论(0) 推荐(0)

ocp 1Z0-047 131-276题解析

摘要：131. Which view would you use to display the column names and DEFAULT valuesfor a table?A. DBA_TABLESB. DBA_COLUMNSC. USER_COLUMNSD. USER_TAB_COLUMNSA... 阅读全文

posted @ 2015-02-27 14:55 回家的流浪者阅读(12154) 评论(0) 推荐(0)

ocp 1Z0-047 61-130题解析

摘要：61. Evaluate the following SQL statements that are issued in the given order:CREATE TABLE emp(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,en... 阅读全文

posted @ 2015-02-27 14:54 回家的流浪者阅读(14214) 评论(0) 推荐(0)

ocp 1Z0-047 1-60题解析

摘要：1. You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limi... 阅读全文

posted @ 2015-02-26 16:06 回家的流浪者阅读(11258) 评论(0) 推荐(0)

ocp 1Z0-051 141-175题解析

摘要：141. View the Exhibitand examine the structure of CUSTOMERS and GRADES tables.You need to displaynames and grades of customers who have the highest cr... 阅读全文

posted @ 2014-12-15 22:17 回家的流浪者阅读(2098) 评论(0) 推荐(0)

ocp 1Z0-051 106-140题解析

摘要：106. Examine the data inthe LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:LIST_PRICE MIN_PRICE10000 80002000030000 30000Which two expressions... 阅读全文

posted @ 2014-12-15 22:16 回家的流浪者阅读(2562) 评论(0) 推荐(0)

ocp 1Z0-051 71-105题解析

摘要：71. Which arithmeticoperations can be performed on a column by using a SQL function that is builtintoOracle database ?(Choose three .)A. a dditionB. s... 阅读全文

posted @ 2014-12-15 22:15 回家的流浪者阅读(1158) 评论(0) 推荐(0)

ocp 1Z0-051 23-70题解析

摘要：23. Examine thestructure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULLNUMBER(6)CUST_NAME NOT NULLVARCHAR2(20)CUST_STATUS NOT NUL... 阅读全文

posted @ 2014-12-15 22:14 回家的流浪者阅读(749) 评论(0) 推荐(0)

ocp 1Z0-051 1-22题解析

摘要：1. View the Exhibit andexamine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables.The PROD_ID column isthe foreign key in the SALES tabl... 阅读全文

posted @ 2014-12-15 22:08 回家的流浪者阅读(706) 评论(0) 推荐(0)

随笔分类 - ocp