![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OCP-1Z0-051
文章平均质量分 69
Riveore
这个作者很懒,什么都没留下…
展开
-
OCP-1Z0-051-V9.02-30题
30. Evaluate the following CREATE TABLE commands:CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no N原创 2013-09-29 16:33:25 · 9195 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-1题
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.原创 2013-09-30 09:27:55 · 18890 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-31题
31. Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; SQL>CREATE TABLE ord_items (ord_no NUM原创 2013-09-29 16:27:14 · 9223 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-25题
25. You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name原创 2013-09-30 10:29:47 · 11308 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-120题
120. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERStables. You issue the following query: SQL>SELECT p.prod_id,prod_name,prod_list_price, qu原创 2013-09-11 10:01:09 · 11985 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-12题
12. You need to produce a report where each customer's credit limit has been incremented by $1000. Inthe output, t he customer's last name should have the heading Name and the incremented credit原创 2013-09-02 14:29:19 · 10000 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-118题
118. View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements: Statement 1 SQL>SELECT promo_category,SUM(promo_cost) FROM promotions原创 2013-09-11 09:42:53 · 9288 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-11题
11. View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price. You issue the following command to display the total price of each product after a discount o原创 2013-09-02 14:22:27 · 10089 阅读 · 2 评论 -
OCP-1Z0-051-V9.02-14题
14. Using the CUSTOMERS table, you need to generate a report that shows 50% of each creditamount in each income level. The report should NOT show any repeated credit amounts in each incomel原创 2013-09-02 14:45:07 · 9811 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-15题
15. View the Exhibit and examine the data in the CUSTOMERS table. Evaluate the following query: SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAXLOWER LIMI原创 2013-09-02 14:50:15 · 9148 阅读 · 6 评论 -
OCP-1Z0-051-V9.02-17题
17. View the E xhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to date.You issue the following query: SQ原创 2013-09-02 14:54:33 · 11904 阅读 · 2 评论 -
OCP-1Z0-051-V9.02-18题
18. Examine the structure of the PROMOTIONS table: name Null Type PROMO_ID NOT NULL NUMBER(6) PROMO_NAME NOT NULL VARCHAR2(30) PROMO_CATEGORY NOT NULL VAR原创 2013-09-02 15:11:41 · 10113 阅读 · 2 评论 -
OCP-1Z0-051-V9.02-32题
32. Which CREATE TABLE statement is valid? A. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL); B. CREATE TABLE ord_de原创 2013-09-16 16:11:52 · 10232 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-93题
93. View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, y ou need to generate a report that shows an increase in the credit limitby 15% for all custom原创 2013-09-18 14:09:03 · 10193 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-94题
94. Examine the structure of the PROGRAMS table:name Null Type PROG_ID NOT NULL NUMBER(3) PROG_COST NUMBER(8,2) START_DATE NOT NULL原创 2013-09-18 14:33:19 · 9193 阅读 · 2 评论 -
OCP-1Z0-051-V9.02-96题
96. Examine the structure of the INVOICE table.name Null Type INV_NO NOT NULL NUMBER(3) INV_DATE DATE INV_AMT NUMBER(10,2)原创 2013-09-18 15:28:36 · 12434 阅读 · 3 评论 -
OCP-1Z0-051-V9.02-95题
95. The PRODUCTS table has the following structure:name Null Type PROD_ID NOT NULL NUMBER(4) PROD_NAME VARCHAR2(25)PROD_EX原创 2013-09-18 14:56:48 · 11256 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-60题
60. View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: SQL>SELECT cust_id, cust_city FROM customers WHERE cust_first_name NOT LIKE 'A_%g_%' AN原创 2013-09-20 00:06:10 · 7703 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-58题
58. The PART_CODE column in the SPARES table contains the following list of values: PART_CODE A%_WQ123 A%BWQ123AB_WQ123 Evaluate the following query: SQL> SELECT pa原创 2013-09-20 00:12:29 · 9240 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-55题
55. Evaluate the following two queries: SQL> SELECT cust_last_name, cust_city FROM customers WHERE cust_credit_limit IN (1000, 2000, 3000); SQL> SELECT cust_last_name, cust_city原创 2013-09-20 00:15:18 · 8536 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-54题
54. View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement: SQL> SELECT cust_last_name, cust_city, cust_credit_limit FROM customers WHERE cus原创 2013-09-20 00:19:02 · 8361 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-145题
145. View the Exhibit and examine the structure of the CUSTOMERS table.You issue the following SQL statement on the CUSTOMERS table to display the customers who are in thesame country as custo原创 2013-09-21 00:37:38 · 6358 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-146题
146. Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit原创 2013-09-21 00:50:44 · 12142 阅读 · 12 评论 -
OCP-1Z0-051-V9.02-142题
142. View the Exhibit and examine the structure of the PRODUCTS table.Evaluate the following query: SQL> SELECT prod_name FROM products WHERE prod_id IN (SELECT prod_id FROM products原创 2013-09-21 00:13:59 · 6194 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-144题
144. View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the following query: SQL>SELECT COUNT(*),pro原创 2013-09-21 00:18:52 · 8282 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-147题
147. View the Exhibit and examine the structure of the PROMOTIONS table.Evaluate the following SQL statement: SQL>SELECT promo_name,CASE WHEN promo_cost >=(SELECT AVG(promo_cost)原创 2013-09-21 01:00:32 · 8407 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-159题
159. View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY thathave the same data types and size as t原创 2013-09-21 22:46:51 · 9174 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-26题
26. Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$# (emp_no NUMBER (4));B. CREATE TABLE 9emp$# (emp_no NUMBER(4)); C. CREATE TABLE emp*123 (emp_no NUMBER(4));D.原创 2013-09-22 16:23:01 · 9120 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-150题
150. View the Exhibit and examine the data in the PROMOTIONS table.You need to display all promo categories that do not have 'discount' in their subcategory.Which two SQL statements give the r原创 2013-09-22 16:38:37 · 6237 阅读 · 3 评论 -
OCP-1Z0-051-V9.02-99题
99. View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you need to find out the average cost for all promos in the ranges$0-2000 and $2000-5000原创 2013-09-23 09:43:38 · 7130 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-98题
98. Which statement is true regarding the COALESCE function?A. It can have a maximum of five expressions in a list. 最多只能有5个表达式,错,无限个B. It returns the highest NOT NULL value in the list for all原创 2013-09-23 09:28:07 · 8909 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-106题
106. Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:LIST_PRICE MIN_PRICE 10000 8000 20000 30000 30000 Which two expressions give the s原创 2013-09-23 08:46:41 · 9455 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-109题
109. Examine the structure of the MARKS table:name Null Type STUDENT_ID NOT NULL VARCHAR2(4) STUDENT_NAME VARCHAR2(25) SUBJECT1原创 2013-09-24 14:35:44 · 12178 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-111题
111. View the Exhibit and examine the structure of the CUSTOMERS table.Which statement would display the highest credit limit available in each income level in each city in theCUSTOMERS tabl原创 2013-09-24 15:19:45 · 6319 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-113题
113. Examine the structure of the ORDERS table: Name Null Type ORDER_ID NOT NULL NUMBER(12) ORDER_DATE NOT NULL TIMESTAMP(6) CUSTOMER_ID NOT NU原创 2013-09-24 15:36:47 · 8824 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-114题
114. View the Exhibit and examine the structure of the SALES table.The following query is written to retrieve all those product ID s from the SALES table that have more than 55000 sold and ha原创 2013-09-24 16:05:50 · 7666 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-115题
115. View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the following SQL statement: SQL> SELECT cust_city, COUNT(cust_last_name)FROM customers WHERE cust_credit_原创 2013-09-24 16:10:09 · 7358 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-116题
116. Examine the data in the ORD_ITEMS table:ORD_NO ITEM_NO QTY 1 111 10 1 222 20 1 333 30 2 333 30 2 444原创 2013-09-24 16:13:26 · 11850 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-110题
110. View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, you need to generate a report that shows the average credit limit forcustomers in WASHINGTON原创 2013-09-24 14:51:41 · 7442 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-112题
112. View the Exhibit and examine the structure of the PROMOTIONS table.Evaluate the following SQL statement: SQL>SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overh原创 2013-09-24 15:29:13 · 7654 阅读 · 0 评论