READ Free Dumps For Oracle- 1z0-001
| Question ID 8083 | In SQL Plus You issued this command: Delete from dept where dept_id=901 You received an integrated constraint error because the child record was found. What could you do to make the statement execute?
|
| Option A | Delete the child record first.
|
| Option B | You cannot make the command execute.
|
| Option C | Add a fourth keyword to the command.
|
| Option D | Add the constraints cascade option to the command.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because you need first delete the child record in dependable table for avoid foreign constraint violation. Incorrect Answers: B: You can execute the command if you don't have child records in other tables for record you need to delete in the parent table DEPT. C: Adding an additional keyword will not help because foreign constraint will be violated. D: CASCADE CONSTRAINTS option works only for DROP TABLE command, not for DELETE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 398-399 Chapter 8: Managing Database Objects I
| Question ID 8084 | The view EMP-VIEW is created based on the EMP table as follows. CREATE OR REPLACE VIEW emp-view AS SELECT deptno, SUM(sal) TOT_SAL, COUNT TOT-EMP FROM empGROUP BY deptno; What happens when the command is used? UPDATE emp-viewSET tot-sal=20000 WHERE deptno=10;
|
| Option A | The base table cannot be updated through this view.
|
| Option B | The TOT_SAL column in the EMP table is updated to 20,000 for department 10.
|
| Option C | . The TOT_SAL column in the EMP table is updated to 20,000 for department10.
|
| Option D | The SAL column in the EMP table is updated to 20,000 for employees in department 10.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because the user may not INSERT, DELETE, or UPDATE data on the table underlying the sample view if the SELECT statement creating the view contains GROUP BY, or a single-row operation. Incorrect Answers: B: TOT_SAL column in the EMP table will not be updated. C: TOT_SAL column in the EMP table will not be updated for any rows. D: UPDATE command does not contain SAL column for update. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 164 Chapter 4: Creating Other Database Objects in Oracle