当前位置: Oracle培训中心-> 071题库
165
164

新闻中心

  • 【第62题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第62题、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: Which query will provide the required output? A) SELECT LISTAGG(last_name, '; ') "Emp_list", MIN(hire_date) "Earliest" FROM employees WHERE department_id = 30 WITHIN GROUP ORDER BY hire_date; B) SELECT LISTAGG(last_name, '; ') "EM........详情
  • 【第63题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第63题、choose the best answer: View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, which cannot contain NULL? A) ALTER TABLE products ADD price NUMBER(8,2) DEFAULT NOT NULL; B) ALTER TABLE products ADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL; C) ALTER TABLE products ADD price NUMBER(8,2) NOT NULL; D) ALTER ........详情
  • 【第64题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第64题、choose the best answer: View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Evaluate the following SQL statement: SELECT oi.order_id, product_id, order_date FROM order_items oi JOIN orders o USING(order_id); Which statement is true regarding the execution of this SQL statement? A) The statement would not execute because the table alias prefi........详情
  • 【第65题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第65题、choose the best answer: The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit. 2. Only those customers whose income level has a value should be considered. 3. Customers whose tax amount is null should not be considered. Which st........详情
  • 【第66题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 这两年来,OCP的071考试不像以前那么稳定了,总是不断的有新考题出现,增加了071考试的难度,对此,我们对071考试的原题进行了收集,并由专业人员给出了答案,分享给大家。--------------------------------------------071最新题库-第66题、choose twoExamine the structure proposed for the TRANSACTIONS table:Which two statements are true regarding the creation and storage of data in the above table structure?A) ........详情
  • 【第67题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第67题、choose the best answer: View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: SQLSELECT cust_id, cust_city FROM customers WHERE cust_first_name NOT LIKE 'A_%g_%' AND cust_credit_limit BETWEEN 5000 AND 15000 AND cust_credit_limit NOT IN (7000, 11000) AND cust_city NOT BETWEEN 'A' AND 'B'; Which statement is true regarding the ab........详情
  • 【第68题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第68题、choose two: Which two statements are true? (Choose two.) A) DICTIONARY is a view that contains the names of all the data dictionary views that the user can access. B) The user SYSTEM owns all the base tables and user-accessible views of the data dictionary. C) All the dynamic performance views prefixed with v$ are accessible to all the database users. D) The USER_OBJECTS ........详情
  • 【第69题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第69题、choose the best answer: Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the above query? A) +25-00 , +00-650, +00 11:12:10.123457 B) +25-00 , +54-02, +00 11:12:10.123457 C) +00-300, +00-650, +00 11:12:10.123457 D) +00-300, +54-02, +00 11:12:10........详情
  • 【第70题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第70题、choose the best answer: View the Exhibit and examine the structure of the Book table. The BOOKS table contains details of 100 books. Examine the commands executed and their outcome: SQLINSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer',null,null); 1 row created. SQLSAVEPOINT A; Savepoint created. SQLDELETE FROM books; 101 rows deleted. SQLROLLBACK TO SAVE........详情
  • 【第61题】2019年最新OCP认证071考试题库汇总2019-07-01
  • 071最新题库-第61题、choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10,000. Evaluate the following two queries: SQL SELECT cust_last_name, cust_credit_limit FROM customers WHERE (UPPER(cust_last_na........详情
  • 【第60题】2019年最新OCP认证071考试题库汇总2019-06-05
  • 071最新题库-第60题、choose the best answer: Evaluate the following SQL commands: SQLCREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; SQLCREATE TABLE ord_items (ord_no NUMBER(4) DEFAULT ord_seq.NEXTVAL NOT NULL, item_no NUMBER(3), qty RIUNBER(3) CHECK (qty BETWEEN 100 AND 200), expiry_date date CHECK (expiry_date SYSDATE), CONSTRAINT it_pk PRIMARY REY (ord........详情
  • 【第58题】2019年最新OCP认证071考试题库汇总2019-06-05
  • 071最新题库-第58题、choose the best answer: Examine the structure of the BOORSTRANSACTIONS table: Examine the SQL statement: SQL SELECT FROM books_transactions WHERE borrowed_date MEMBER_ID IN ('A101', 'A102'); Which statement is true about the outcome? A) It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE. B) It displays details for members w........详情
  • 【第59题】2019年最新OCP认证071考试题库汇总2019-06-05
  • 071最新题库-第59题、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 columns that have different names but compatible data types. B) A maximum of one pair of columns can be joined between two tables using the ON clause. C) Both USING and ON clauses can be used for equijoins and nonequijoins. D) The WHE........详情
  • 【第51题】2019年最新OCP认证071考试题库汇总2019-06-05
  • 071最新题库-第51题、choose the best answer: Evaluate the following SQL statement: SQL SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit FROM customers WHERE cust_city ='Singapore'); Which statement is true regarding the above query if one of the values generated by the subquery is NULL?.....详情
  • 【第52题】2019年最新OCP认证071考试题库汇总2019-06-05
  • 071最新题库-第52题、choose the best answer: Examine the structure and data in the PRICE_LIST table: You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE. Which SQL statement would give the required result? A) SELECT TO_CHAR (TO_NUMBER (prod_price)*.25, '$99,999.00') FROM PRICE_LIST;.....详情
首页  上一页  12345  下一页 尾页 共70条记录 1/5