READ Free Dumps For Oracle- 1z0-020
Question ID 8269 | Which two statements are true regarding partitioned tables/ (Choose two) |
Option A | Partitions must reside in the same tablespace. |
Option B | Partitions must be the same size. |
Option C | Partitions may only reside in read/write tablespaces. |
Option D | Partitions may only reside in read only tablespaces. |
Option E | Row movement between partitions is allowed only if row movement is enabled. |
Option F | Row movement between partitions is allowed default. |
Correct Answer | B,E |
Question ID 8271 | In the DBA_TRIGGERS data dictionary view, the value in the TABLE_NAME column will be NULL in which two situations? (Choose two) |
Option A | The trigger is a schema trigger. |
Option B | The trigger is a database trigger. |
Option C | The trigger was created with the CREATE ANY TRIGGER privilege. |
Option D | The trigger was created by a user who connected with the CONNECT INTERNAL command. |
Correct Answer | A,B |