当前位置: 网站首页 >
OCP认证
- 【OCP 071】最新OCP 12c题库考试原题（071-63题）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 cannot contain NULL?[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-62题）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: Which query will provide the required ou...[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-61题）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 names and credit limits of all customers who...[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-60题）60、(16-10) 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...[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-59题）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 columns that have different names but compa...[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-58题）58、(16-1) 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 ('A10...[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-57题）57、(14-17) choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL ALTER TABLE departments SET UNUSED (country); Which two statements are true?[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-56题）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 employee 2. Employee Name (character data t...[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-55题）55、(13-3) choose the best answer: Which statement is true regarding the SESSION_PRIVS dictionary view? A) It contains the object privileges granted to other users by the current user session. ...[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-54题）54、(12-15) choose the best answer: View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PR...[详细]
- 【12c OCP】最新OCP 12c题库考试原题（071-53题）53、(12-14) choose the best answer: Examine the command to create the BOOKS table. SQLCREATE TABLE books (book_id CHAR(6) PRIMARY KEY, title VARCHAR2(100) NOT NULL, publisher_id VARCHAR2(4),...[详细]
