READ Free Dumps For Oracle- 1z1-051
| Question ID 4793 | Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.) |
| Option A | A. The ON clause can be used to join tables on columns that have different names but compatible data types |
| Option B | B. A maximum of one pair of columns can be joined between two tables using the ON clause |
| Option C | C. Both USING and ON clause can be used for equijoins and nonequijoins |
| Option D | D. The WHERE clause can be used to apply additional conditions in SELECT statement containing the ON or the USING clause |
| Correct Answer | A,D |
| Question ID 4795 | Which three statements/commands would cause a transaction to end? (Choose three.) |
| Option A | A. COMMIT |
| Option B | B. CREATE |
| Option C | C. SELECT |
| Option D | D. ROLLBACK |
| Option E | E. SAVEPOINT |
| Correct Answer | A,B,D |