OCP11g+12c考试资料群:1015267481 验证码:ocp
摘要: 15、(6-24)choose the best answerExamine the structure of the MEMBERS table:You want to display details of all members who reside in states starting wit 阅读全文
posted @ 2019-02-18 15:53 cnblogs_5359 阅读(422) 评论(0) 推荐(0)
摘要: 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 ordersSET o 阅读全文
posted @ 2019-02-18 14:50 cnblogs_5359 阅读(363) 评论(0) 推荐(0)
摘要: 13、(6-7) choose twoWhich two statements are true regarding operators used with subqueries? (Choose two.)A) =ANY and =ALL operators have the same funct 阅读全文
posted @ 2019-02-18 14:13 cnblogs_5359 阅读(321) 评论(0) 推荐(0)
摘要: 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 detai 阅读全文
posted @ 2019-02-15 15:30 cnblogs_5359 阅读(351) 评论(0) 推荐(0)
摘要: 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 to 'INV 阅读全文
posted @ 2019-02-15 13:22 cnblogs_5359 阅读(329) 评论(0) 推荐(0)
摘要: 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_ID.Y 阅读全文
posted @ 2019-02-15 11:40 cnblogs_5359 阅读(327) 评论(0) 推荐(0)
摘要: 9、(5-5) choose the best answerView the Exhibit and examine the structure of the SALES and STORES tables.You want to display the store name and the tot 阅读全文
posted @ 2019-02-15 11:17 cnblogs_5359 阅读(317) 评论(0) 推荐(0)
摘要: 8、(5-4) choose the best answer:You need to produce a report where each customer's credit limit has been incremented by $1000.In the output, the custom 阅读全文
posted @ 2019-02-14 11:04 cnblogs_5359 阅读(371) 评论(0) 推荐(0)
摘要: 7、(5-1) choose two:View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks would require subqueries? A) Display the minimum l 阅读全文
posted @ 2019-02-14 10:44 cnblogs_5359 阅读(376) 评论(0) 推荐(0)
摘要: 6、(4-21) choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: SQL> SELECT 阅读全文
posted @ 2019-02-13 17:02 cnblogs_5359 阅读(347) 评论(0) 推荐(0)