OCP11g+12c考试资料群:1015267481 验证码:ocp
上一页 1 ··· 63 64 65 66 67 68 69 70 71 ··· 77 下一页
摘要: 65、(22-16) choose the best answer: The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Displa 阅读全文
posted @ 2019-03-07 10:14 cnblogs_5359 阅读(284) 评论(0) 推荐(0)
摘要: 64、(22-7) choose the best answer: View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Evaluate the following SQL statemen 阅读全文
posted @ 2019-03-06 11:33 cnblogs_5359 阅读(211) 评论(0) 推荐(0)
摘要: 63、(22-4) choose the best answer: View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, which 阅读全文
posted @ 2019-03-06 11:08 cnblogs_5359 阅读(245) 评论(0) 推荐(0)
摘要: 62、(13-17)choose the best answer: You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE. Examine the sample output: 阅读全文
posted @ 2019-03-06 10:35 cnblogs_5359 阅读(262) 评论(0) 推荐(0)
摘要: 61、(18-6) choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last na 阅读全文
posted @ 2019-03-06 10:03 cnblogs_5359 阅读(250) 评论(0) 推荐(0)
摘要: 60、(16-10) choose the best answer: Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYC 阅读全文
posted @ 2019-03-05 14:26 cnblogs_5359 阅读(286) 评论(0) 推荐(0)
摘要: 59、(16-8)choose two: Which two statements are true regarding the USING and ON clauses in table joins? A) The ON clause can be used to join tables on c 阅读全文
posted @ 2019-03-05 13:11 cnblogs_5359 阅读(238) 评论(0) 推荐(0)
摘要: 58、(16-1) choose the best answer: Examine the structure of the BOORSTRANSACTIONS table: Examine the SQL statement: SQL> SELECT FROM books_transactions 阅读全文
posted @ 2019-03-05 11:35 cnblogs_5359 阅读(437) 评论(0) 推荐(0)
摘要: 57、(14-17) choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET UNUSED (coun 阅读全文
posted @ 2019-03-05 10:21 cnblogs_5359 阅读(508) 评论(0) 推荐(0)
摘要: 56、(14-14) choose the best answer: You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each em 阅读全文
posted @ 2019-03-04 14:39 cnblogs_5359 阅读(255) 评论(0) 推荐(0)
上一页 1 ··· 63 64 65 66 67 68 69 70 71 ··· 77 下一页