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