READ Free Dumps For Oracle- 1z0-001
| Question ID 8174 | Examine the table instance chart for the sales table. Column DCAR_ID SALES_ID name PURCHASE_N OCUSTOMER_I Key type PK FK FK FK Nulls/Unique NN, U NN NN NN FK table CUSTOMER CAR EMPLOYEE FK column ID ID ID Data type NUM NUM NUM NUM Length 9 9 9 9 You attempt to change the data base with this command: INSERT INTO sales(purchase_no, customer_id,car_id) VALUES(1234,345,6); If this statement fails which condition would explain the failure? |
| Option A | The sales table has too many foreign keys. |
| Option B | A mandatory column value is missing. |
| Option C | The statement has invalid data types. |
| Option D | The statement does not fail at all. |
| Correct Answer | B |
| Question ID 8175 | You attempt to query the data base with this command: SELECT name,salary FROM employee WHERE salary= (SELECT salary FROM employee WHERE last_name= 'Wagner' OR dept_no=233) Why could this statement cause an error? |
| Option A | Sub queries are not allowed in the where clause. |
| Option B | Logical apparatus are not allowed in where clause. |
| Option C | A multiple row sub query used with a single row comparison operator. |
| Option D | A single row query is used with a multiple row comparison operator. |
| Correct Answer | C |