« Technical Interview & Viva Questions : KyaPoocha.com home page
« How will you activate/deactivate integrity constraints?
How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY? »



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


- 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.



Explore posts in the same categories: Oracle Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • How you will set the datarelation between two columns?
    • ADO.NET provides DataRelation object to set relation between two columns.It helps to enforce the following constraints,a unique constraint, which...
  • What are column-name qualifiers used ?
    • Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one...
  • What are the column name qualifiers ?
    • A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in...
  • What is a pseudo column. Give some examples
    • It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND...
  • What is an Integrity Constraint ?
    • Integrity constraint is a rule that restricts values to a column in a table....
  • In what RDMS object does one first list column names ?
    • One first uses the column name in the CREATE TABLE statement....
  • In which column of which DB2 catalog would you find the length of the rows for all tables?
    • In the RECLENGTH column of SYSIBM.SYSTABLES...
  • What is correlation names ?
    • IT is a special type of column designator that connects specific column in the various levels of a multilevel SQL...
  • What is meant by null ?
    • This is a special value that indicates the absence of data in a column. This value is indicated by a...
  • How do you retrieve the data from a nullable column ?
    • Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND...

    Comments are closed.