READ Free Dumps For Oracle- 1z0-061
Question ID 2327 | You issue the following command to alter the country column in the departments table: |
Option A | A. It produces an error because column definitions cannot be altered to add default values. |
Option B | B. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'. |
Option C | C. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table. |
Option D | D. It produces an error because the data type for the column is not specified. |
Correct Answer | B |
Question ID 2328 | Which two statements are true regarding constraints? |
Option A | A. A foreign key cannot contain null values. |
Option B | B. A column with the unique constraint can contain null values. |
Option C | C. A constraint is enforced only for the insert operation on a table. |
Option D | D. A constraint can be disabled even if the constraint column contains data. |
Option E | E. All constraints can be defined at the column level as well as the table level. |
Correct Answer | B,D |