READ Free Dumps For Oracle- 1z0-007
| Question ID 7947 | Which statement creates a new user?
|
| Option A | CREATIVE USER susan;
|
| Option B | CREATIVE OR REPLACE USER susan;
|
| Option C | CREATE NEW USER susan DEFAULT
|
| Option D | CREATE USER susan IDENTIFIED BY blue;
|
| Option E | CREATE NEW USER susan IDENTIFIED BY blue;
|
| Option F | CREATE OR REPLACE USER susan IDENTIFIED BY blue;
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: The correct statement to create user is: CREATE USER user_name IDENTIFIED BY password. Incorrect Answers A: This syntax is incorrect to create user: you need to provide also password for the user. B: There is no CREATE OR REPLACE USER command in Oracle. C: There is no CREATE NEW USER user_name DEFAULT command in Oracle. E: There is no CREATE NEW USER user_name IDENTIFIED BY command in Oracle. F: There is no CREATE OR REPLACE USER user_name IDENTIFIED BY command in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 348-351 Chapter 8: User Access in Oracle
| Question ID 7948 | Which three are true regarding the use of outer joins? (Choose three.)
|
| Option A | You cannot use IN operator in a condition that involves an outerjoin.
|
| Option B | You use (+) on both sides of the WHERE condition to perform an outerjoin.
|
| Option C | You use (*) on both sides of the WHERE condition to perform an outerjoin.
|
| Option D | You use an outerjoin to see only the rows that do not meet the join condition.
|
| Option E | In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
|
| Option F | You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
|
| Correct Answer | DEF |
Explanation Explanation/Reference: Explanation: You can use an outerjoin to see only the rows that do not meet the join condition. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator. Incorrect Answers A: You can use IN operator in a condition that involves an outerjoin. B: You use (+) following the name of the column in the table without matching rows, but not on both sides of the WHERE condition to perform an outerjoin. C: You don't use (*) to define outerjoin operation. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 109-118 Chapter 3: Advanced Data Selection in Oracle