- 博客(48)
- 收藏
- 关注
转载 【ocp-12c】最新CUUG OCP-071考试题库(48题)
48、(10-12)choose the best answer View the Exhibit and examine the description for the PRODUCTS and SALES table. PROD_ID is a primary key in the...
2019-02-28 11:53:00 161
转载 【ocp-12c】最新Oracle OCP-071考试题库(47题)
47、(10-6)choose two You need to calculate the number of days from 1st January 2007 till date. Dates are stored in the default format of dd-mon-rr...
2019-02-28 11:36:00 193
转载 【ocp-12c】最新Oracle OCP-071考试题库(46题)
46、(10-4) choose two: Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ---------------------- Lex De Haan Renske Lad...
2019-02-28 10:16:00 123
转载 【ocp-12c】最新Oracle OCP-071考试题库(45题)
45、(9-16)choose the best answer: View the Exhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total ...
2019-02-28 09:34:00 120
转载 【ocp-12c】最新Oracle OCP-071考试题库(44题)
44、(9-12)choose all that apply View the Exhibit and examine the details of the ORDER_ITEMS table. Evaluate the following SQL statements: State...
2019-02-27 11:43:00 129
转载 【ocp-12c】最新Oracle OCP-071考试题库(43题)
43、(9-2)choose three Which three tasks can be performed by DDL statements? A) preventing data retrieval from a table outside of office hours B) ...
2019-02-27 11:10:00 207
转载 【ocp-12c】最新Oracle OCP-071考试题库(42题)
42、(9-1)choose the best answer: Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements? A) DELETE but not TRUNCATE statemen...
2019-02-27 10:34:00 858
转载 【ocp-12c】最新Oracle OCP-071考试题库(41题)
41、(8-14) choose two View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default va...
2019-02-27 09:49:00 172
转载 【ocp-12c】最新Oracle OCP-071考试题库(40题)
40、(8-7) choose two Which two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot b...
2019-02-26 17:06:00 116
转载 【ocp-12c】最新Oracle OCP-071考试题库(39题)
39.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for e...
2019-02-26 16:35:00 215
转载 【ocp-12c】最新Oracle OCP-071考试题库(38题)
38.choose the best answer View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format,...
2019-02-26 16:08:00 100
转载 【ocp-12c】最新Oracle OCP-071考试题库(37题)
19.choose the best answer View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: SQL>SEL...
2019-02-26 15:18:00 143
转载 【12c OCP】CUUG OCP认证071考试原题解析(36)
36.choose the best answer View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables. You issue the following quer...
2019-02-25 13:25:00 104
转载 【Oracle 12c】CUUG OCP认证071考试原题解析(35)
35.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT firs...
2019-02-25 11:22:00 150
转载 【12c OCP】CUUG OCP认证071考试原题解析(34)
34.choose two View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the suppl...
2019-02-25 10:18:00 256
转载 【12c OCP】CUUG OCP认证071考试原题解析(33)
33.choose the best answer View the Exhibit and examine the structure of the ORDER_ITEMS table. Examine the following SQL statement: SELECT order...
2019-02-25 09:46:00 109
转载 【Oracle 12c】CUUG OCP认证071考试原题解析(32)
32.choose the best answer View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the E...
2019-02-22 13:25:00 85
转载 【Oracle 12c】CUUG OCP认证071考试原题解析(31)
31.choose the best answer Which statement is true regarding the USING clause in table joins? A) It can be used to access data from tables through...
2019-02-22 10:57:00 154
转载 【Oracle 12c】CUUG OCP认证071考试原题解析(30)
30.choose the best answer Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL> CREATE TABLE DEPARTMENT_DETAILS (DE...
2019-02-22 10:27:00 111
转载 【Oracle 12c】CUUG OCP认证071考试原题解析(29)
29.choose the best answer Evaluate the following query: SQL> SELECT promo_name || q'{'s start date was \}' || promo_begin_date AS "Promotion ...
2019-02-22 09:56:00 130
转载 【OCP认证12c题库】CUUG 071题库考试原题及答案(28)
28.choose the best answer Evaluate the following SQL statement: SQL> SELECT promo_id, promo_category FROM promotions WHERE promo_category = ...
2019-02-21 11:41:00 122
转载 【OCP认证12c题库】CUUG 071题库考试原题及答案(27)
27.choose two The SQL statements executed in a user session are as follows: SQL> CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(10));...
2019-02-21 11:05:00 122
转载 【OCP认证12c题库】CUUG 071题库考试原题及答案(26)
26.choose two Examine the structure of the PRODUCTS table. Which two statements are true? A) EXPIRY_DATE always stores date and time in characte...
2019-02-21 10:25:00 212
转载 【OCP认证12c题库】CUUG 071题库考试原题及答案(25)
25. choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the ...
2019-02-21 09:47:00 71
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(24)
24. choose the best answer In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years. Evaluate t...
2019-02-20 17:29:00 145
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(23)
23.choose the best answer View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the ...
2019-02-20 16:16:00 103
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(22)
5.choose the best answer Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 C...
2019-02-20 15:32:00 83
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(21)
3.choose three View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where t...
2019-02-20 13:54:00 155
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(20)
20.choose two Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be ex...
2019-02-19 11:52:00 184
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(19)
1.choose the best answer What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models? A) RDB al...
2019-02-19 10:55:00 155
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(18)
18、(8-7) choose two Which two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be...
2019-02-19 10:05:00 100
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(17)
17、(7-11) choose two View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table tho...
2019-02-19 09:25:00 76
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(16)
16、(7-5) choose the best answer The PRODUCTS table has the following structure: Evaluate the following two SQL statements: SQL>SELECT prod_id, N...
2019-02-18 16:46:00 100
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(15)
15、(6-24)choose the best answer Examine the structure of the MEMBERS table: You want to display details of all members who reside in states startin...
2019-02-18 15:53:00 67
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(14)
14、(6-13) choose the best answer: View the Exhibit and examine the structure of the ORDERS table. Which UPDATE statement is valid? A) UPDATE order...
2019-02-18 14:50:00 55
转载 【OCP-12c】CUUG 071题库考试原题及答案解析(13)
13、(6-7) choose two Which two statements are true regarding operators used with subqueries? (Choose two.) A) =ANY and =ALL operators have the same ...
2019-02-18 14:13:00 90
转载 【OCP-12c】CUUG最新考试原题整理及答案(071-12)
12、(5-12)choose two: Examine the data in the CUSTOMERS table: You want to list all cities that have more than one customer along with the customer ...
2019-02-15 15:29:00 118
转载 【OCP-12c】CUUG最新考试原题整理及答案(071-11)
11、(5-8) choose the best answer: Examine the structure of the BOOKS_TRANSACTIONS table. You want to update this table such that BOOK_ID is set t...
2019-02-15 13:21:00 116
转载 【OCP-12c】CUUG最新考试原题整理及答案(071-10)
10、(5-6) choose the best answer: Examine the structure of the EMPLOYEES table: There is a parent/child relationship between EMPLOYEE_ID and MANAGER...
2019-02-15 11:40:00 129
转载 【OCP-12c】CUUG最新考试原题整理及答案(071-9)
9、(5-5) choose the best answer View the Exhibit and examine the structure of the SALES and STORES tables. You want to display the store name and th...
2019-02-15 11:17:00 67
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人