READ Free Dumps For Oracle- 1z0-047
| Question ID 6443 | Which statement is true regarding the ROLLUP operator specified in the GROUP BY clause of a SQL statement? |
| Option A | . It produces only the subtotals for the groups specified in the GROUP BY clause |
| Option B | It produces only the grand totals for the groups specified in the GROUP BY clause |
| Option C | . It produces higher-level subtotals, moving from right to left through the list of grouping columns specified in the GROUP BY clause |
| Option D | It produces higher-level subtotals, moving in all the directions through the list of grouping columns specified in the GROUP BY clause |
| Correct Answer | C |
| Question ID 6445 | Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(15), salary NUMBER(8,2), mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp); ALTER TABLE emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ALTER TABLE emp ENABLE CONSTRAINT emp_emp_no_pk; What would be the status of the foreign key EMP_MGR_FK? |
| Option A | It would be automatically enabled and deferred. |
| Option B | . It would be automatically enabled and immediate |
| Option C | . It would remain disabled and has to be enabled manually using the ALTER TABLE command. |
| Option D | . It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it |
| Correct Answer | C |