A.WHERE B.HAVING C.RESTRICT D.GROUP BY E.ORDER BY
A.The UNIQUE constraint does not permit a null value for the column. B.A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C.The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D.The NOT NULL constraint ensures that null values are not permitted for the column.
A.Column definitions cannot be altered to add DEFAULT values. B.A change to the DEFAULT value affects only subsequent insertions to the table. C.Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type. D.All the rows that have a NULL value for the SALARY column will be updated with the value 5000.