ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-03-08 09:37:48
Evaluate the following query:INTERVAL '54-2' YEAR TO MONTH,FROM dual;A) +25-00 , +00-650, +00 11:12:10.123457C) +00-300, +00-650, +00 11:12:10.123457Answer：BINTERVAL '300' MONTH：300 个月为+25-00(25 年，即 25*12+0)INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:1.........【阅读全文】
发布时间：2019-03-07 11:54:56
Which two statements are true? (Choose two.)B) The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.D) The USER_OBJECTS view can provide information about the tables and views created by the user who queries the view.Answer：DEB. system 用户是操.........【阅读全文】
发布时间：2019-03-07 11:24:15
View the Exhibit and examine the structure of CUSTOMERS table.Evaluate the following query:FROM customerscust_credit_limit BETWEEN 5000 AND 15000 ANDcust_city NOT BETWEEN 'A' AND 'B';A) It executes successfully.C) It produces an error because conditions on the GUST_CREDIT_L.........【阅读全文】
发布时间：2019-03-07 10:53:49
Examine the structure proposed for the TRANSACTIONS table:Which two statements are true regarding the creation and storage of data in the above table structure?and fractions of seconds.C) The TRANS_VALIDITY column would have a maximum size of one character.E) The CUST_STATUS column.........【阅读全文】
发布时间：2019-03-07 10:11:49
The CUSTOMERS table has the following structure:You need to write a query that does the following tasks:2. Only those customers whose income level has a value should be considered.Which statement accomplishes all the required tasks?FROM customersB) SELECT cust_first_name, cust_.........【阅读全文】
