OCP 11g
文章平均质量分 69
oracle
IMezZ
这个作者很懒,什么都没留下…
展开
-
OCP-1Z0-051-V9.02-121题
121. Which two statements are true regarding theUSING clause in table joins? (Choose two .)A. It can be used to join a maximum of three tables.B. It can be used to restrict the number of columns used...原创 2018-03-22 13:31:42 · 299 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-127题
127. Examine the data in the CUSTOMERS table:CUSTNO CUSTNAME CITY1 KING SEATTLE2 GREEN BOSTON3 KOCHAR SEATTLE4 SMITH NEWYORKYou want to li...原创 2018-03-22 16:38:49 · 906 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-128题
128. View the Exhibits and examine thestructures of the CUSTOMERS, SALES, andCOUNTRIEStables.You need to generate a report that shows all country names, with correspondingcustomers (if any) and s...原创 2018-03-22 17:05:14 · 308 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-130题
130. View the Exhibit and examine the data in theEMPLOYEES table:You want to display all the employee names and their corresponding manager names.Evaluate the following query:SQL> SELECT e.employee...原创 2018-03-23 09:41:46 · 265 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-137题
137. View the Exhibits and examine PRODUCTS and SALEStables.You issue the following query to display product name andthe number of times the product has beensold: SQL>SELECT p.prod_name,i.item_cnt ...原创 2018-03-23 14:59:08 · 338 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-57/64/67题
57. The CUSTOMERS table has the followingstructure:name Null TypeCUST_ID NOT NULL NUMBERCUST_FIRST_NAME NOT NULL VARCHAR2(20)CUST_LAST_NAME NOT NULL VARCHAR2(30)CUST_...原创 2018-03-26 15:54:22 · 301 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-171题
171. Which three statements/commands would cause atransaction to end? (Choose three.)A. COMMITB. SELECTC. CREATED. ROLLBACKE. SAVEPOINTAnswer:ACD答案解析:事务处理在遇到第一条DML 语句时开始,在发生以下事件之一时结束:• 发出COMMIT或ROLLBA...原创 2018-03-27 11:58:01 · 266 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-10-14题
10. Examine the following statement that is used tomodify the constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLEVALIDATE;Which three statements are true regarding the...原创 2018-04-04 09:40:20 · 478 阅读 · 0 评论