-
编辑 删除
ocp11g lz0-047 question 111
QUESTION 111View the Exhibit and examine the data in the EMPLOYEES tables.SELECT employee_id, department_idFROM employeesWHERE department_id= 50 ORDER BY department_idUNIONSELECT employee_id, department_idFROM employeesWHERE department_id= 90UNIONSELECT employee_id, department_idFROM emp...
-
编辑 删除
ocp11g lz0-047 question 15
QUESTION 15Evaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A. Any synonym existing on the EMP table would have to be re-created.B. Any constraints defined on the MGR_ID column would be remove...
-
编辑 删除
ocp11g lz0-047 question 76
QUESTION 76View the Exhibit and examine the structure of the ORDERS table.Which UPDATE statement is valid?A. UPDATE ordersSET order_date = '12-mar-2007',order_total IS NULLWHERE order_id = 2455;B. UPDATE ordersSET order_date = '12-mar-2007',order_total = NULLWHERE order_id = 2455;C. U...
