- 【OCP 071】最新OCP 12c題庫考試原題（071-76題）76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables. The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the foll...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-75題）Which statements are correct regarding indexes? (Choose all that apply.) A. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to creates a unique index. B. I...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-74題）74、Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600?Assume there exists only one row with CUST_LAST_N...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-73題）73、Which statement correctly grants a system privilege? A. GRANT CREATE VIEW ON table1 TO user1; B. GRANT ALTER TABLE TO PUBLIC; C. GRANT CREATE TABLE TO user1, user2; D. GRANT CREATE SE...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-72題）72、View the exhibit for the structure of the STUDENTand FACULTYtables. STUDENT Name Null? Type ------------------ ------------------- ------------- STUDENT_ID NOT NULL NUMBER(2) STUDENT_N...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-71題）71、(32-18) choose three Which three statements indicate the end of a transaction? (Choose three.) A) after a CREATE statement is issued B) after a SELECT statement is issued C) after a ROLLB...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-70題）70、(31-2)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: ...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-69題）69、(31-1)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...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-68題）68、(29-13)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 SYSTE...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-67題）67、(25-8)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_...[詳細]
- 【OCP 071】最新OCP 12c題庫考試原題（071-66題）66、(22-19)choose two 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? A) The...[詳細]
