Category «1z0-007»

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 200

Which SQL statement displays the date March 19, 2001 in a format that appears as “Nineteenth ofMarch 2001 12:00:00 AM”? A.SELECT TO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘fmDdspth “of” Month YYYY HH:MI:SS AM’) NEW_DATE FROM dual; B.SELECT TO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘Ddspth “of” Month YYYY fmHH:MI:SS AM’) NEW_DATE FROM dual; C.SELECT TO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘fmtDdspth “of” Month YYYY fmtHH:MI:SS AM’) NEW_DATE FROM …

Which UPDATE statement is valid?

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich UPDATE statement is valid? A.UPDATE employees SET first_name = ‘John’, SET last_name =’Smith’ WHERE employee_id = 180; B.UPDATE employees SET first_name = ‘John’, last_name =’Smith’ WHERE employee_id = 180; C.UPDATE employees SET first_name = ‘John’ SET last_name =’Smith’ WHERE employee_id = …

Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that areplaced on the same day that Martin placed his orders? A.SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name=’Martin’ AND ord_date IN (’18-JUL-2000′,’21-JUL-2000′); B.SELECT ord_id, …

Which UPDATE statement meets the requirements?

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT ‘SA_REP’SAL NUMBERCOMM_PCT NUMBERMGR_ID NUMBERDEPARTMENT_ID NUMBERYou need to update the records of employees 103 and 115. The UPDATE statement you specifyshould update the rows with the values specified below:JOB_ID: Default value specified for this column definition.SAL: Maximum salary earned for the job ID …

Which UPDATE statement is valid?

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:EMPLOYEES___________EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATENEW_EMPLOYEES________________EMPLOYEE_ID NUMBER Primary KeyNAME VARCHAR2(60)Which UPDATE statement is valid? A.UPDATE new_employees SET name = (SELECT last_name|| first_name FROM employees WHERE employee_id =180) WHERE employee_id =180; B.UPDATE new_employees SET name = (SELECT last_name || first_name FROM employees WHERE employee_id =180) WHERE employee_id …

Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows?

Examine the structure of the EMPLOYEES table:Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID columnof the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the users to insert rows through the view.Which SQL statement, when …