READ Free Dumps For Oracle- 1z0-050
| Question ID 5993 | Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE |
| Option A | It enables all system triggers. |
| Option B | It allows only SYSDBA connections. |
| Option C | It ensures that all job queues remain active during the upgrade process. |
| Option D | It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run. |
| Correct Answer | B,D |
| Question ID 5994 | Which statements are true regarding system-partitioned tables? (Choose all that apply.) |
| Option A | Only a single partitioning key column can be specified. |
| Option B | All DML statements must use partition-extended syntax. |
| Option C | The same physical attributes must be specified for each partition. |
| Option D | Unique local indexes cannot be created on a system-partitioned table. |
| Option E | Traditional partition pruning and partitionwise joins are not supported on these tables. |
| Correct Answer | D,E |