READ Free Dumps For Oracle- 1z0-007
| Question ID 7959 | You are granted the CREATE VIEW privilege. What does this allow you to do?
|
| Option A | Create a table view
|
| Option B | Create a view in any schema.
|
| Option C | Create a view in your schema.
|
| Option D | Create a sequence view in any schema.
|
| Option E | Create a view that is accessible by everyone
|
| Option F | Create a view only of it is based on tables that you created.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: You can create a view in your own schema only if you are granted the CREATE VIEW privilege. Incorrect Answers A: You can create a view in your own schema only. B: You can create a view in your own schema only, not in any schema. D: There is no sequence view in Oracle. E: You cannot create a view that is accessible by everyone. You will need specially grant SELECT privileges on this view for everyone. F: You can create a view in your own schema, but not only for tables in your schema. You can use object from other users schemas if you have privileges to retrieve data from them. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 292-301 Chapter 7: Creating Other Database Objects in Oracle
| Question ID 7960 | Which two statements about creating constraints are true? (Choose two)
|
| Option A | Constraint names must start with SYS_C.
|
| Option B | All constraints must be defines at the column level.
|
| Option C | Constraints can be created after the table is created.
|
| Option D | Constraints can be created at the same time the table is created.
|
| Option E | Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
|
| Correct Answer | CD |
Explanation Explanation/Reference: Explanation: Constraints can be created after the table is created. Use ALTER TABLE command for that. Constraints can be created at the same time the table is created (CREATE TABLE command). Incorrect Answers A: There is no requirements in Oracle that constraint names must start with SYS_C. Oracle can use prefix "SYS" to build indexes for UNIQUE and NOT NULL constraints, but it is not required for user to follow this naming rule. B: Not all constraints must be defines at the column level. Only NOT NULL constraint must be. E: There is no VIEW_CONSTRAINTS dictionary view in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 227-232 Chapter 5: Creating Oracle Database Objects