SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?

SQL Interview Question
SQL Interview Question

Answer:

- To modify the datatype of a column the column must be empty.
- To add a column with NOT NULL constrain, the table must be empty.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?