KyaPoocha.com

Related Interview Questions

• What is the difference between CHAR and VARCHAR data types?  06.11.08

  CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" w...

• In what RDMS object does one first list column names ?  25.07.08

  One first uses the column name in the CREATE TABLE statement....

• What are the column name qualifiers ?  14.07.08

  A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...

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

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

• What is a pseudo column. Give some examples  11.05.08

  It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Suppose customer table is there having di...

• What is correlation names ?  09.04.08

  IT is a special type of column designator that connects specific column in the various levels of a multilevel SQL query....

• What DB2 Catalog column tell you when an index needs table reorganized ?  09.04.08

  The FAROFFPOS column of the SYSIBM.SYSINDEXPART table....

• In which column of which DB2 catalog would you find the length of the rows for all tables?  12.03.08

  In the RECLENGTH column of SYSIBM.SYSTABLES...

• How do you display an editable drop-down list?  24.12.06

  Displaying a drop-down list requires a template column in the grid. Typically, the ItemTemplate contains a control such as a data-bound Label control to show th...

• What column differentiates the V$ views to the GV$ views and how?  06.08.06

  The INST_ID column which indicates the instance in a RAC environment the information came from....