- 【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...[详细]