READ Free Dumps For Oracle- 1z0-007
Question ID 1722 | You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view? |
Option A | A, Use the DEFINE VIEW command on the EMP_DEPT_VU view. |
Option B | B. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view. |
Option C | C. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view. |
Option D | D. Use the DESCRIBE command on the EMP_DEPT_VU view. |
Option E | E. Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view. |
Option F | F. Use the DESCRIBE VIEW command on the EMP_DEPT_VU view. |
Correct Answer | B |
Question ID 1723 | What is true about joining tables through an equijoin? |
Option A | A. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement. |
Option B | B. You can join a maximum of two tables through an equijoin. |
Option C | C. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns. |
Option D | D. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions. |
Option E | E. You can join a maximum of two columns through an equijoin. |
Correct Answer | D |