READ Free Dumps For Oracle- 1z1-051
| Question ID 4944 | Examine these statements: |
| Option A | A. The set of statements contains an error and does not work. |
| Option B | B. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. |
| Option C | C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users. |
| Option D | D. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role. |
| Option E | E. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object. |
| Option F | F. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar. |
| Correct Answer | C |
| Question ID 4945 | Which two statements about sub queries are true? (Choose two.) |
| Option A | A. A sub query should retrieve only one row. |
| Option B | B. A sub query can retrieve zero or more rows. |
| Option C | C. A sub query can be used only in SQL query statements. |
| Option D | D. Sub queries CANNOT be nested by more than two levels. |
| Option E | E. A sub query CANNOT be used in an SQL query statement that uses group functions. |
| Option F | F. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column. |
| Correct Answer | B,F |