READ Free Dumps For Oracle- 1z0-007
| Question ID 8039 | Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? |
| Option A | INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01); |
| Option B | INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01'); |
| Option C | INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01)); |
| Option D | INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01'); |
| Correct Answer | A |
| Question ID 8040 | Which two statements about subqueries are true? (Choose two.) |
| Option A | A single row subquery can retrieve data from only one table. |
| Option B | A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause. |
| Option C | A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause. |
| Option D | A single row subquery can retrieve data from more than one table. |
| Option E | A single row subquery cannot be used in a condition where the LIKE operator is used for comparison. |
| Option F | A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time. |
| Correct Answer | DF |