« Technical Interview & Viva Questions : KyaPoocha.com home page
« What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?
What is the usage of SAVEPOINTS? »



How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?


Only one LONG column is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.



Explore posts in the same categories: Oracle Interview Questions


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

Related Questions :

  • How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?
    • Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause....
  • After a table is defined, can columns be removed ?
    • The only way to remove columns from an existing table involves a migration program that extracts only the desired columns...
  • After a table is defined, can columns be removed ?
    • The only way to remove columns from an existing table involves a migration program that extracts only the desired columns...
  • What are some characteristics of columns that benefit from indexes ?
    • Primary key and foreign key columns;  columns that have unique values; columns that have aggregates computed frequently and columns used...
  • How many number of columns a record group can have?
    • A record group can have an ultimate number of columns of type CHAR,LONG,NUMBER, and DATE provided that the total number...
  • What is a clustered index ?
    • For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long...
  • How many types of columns are there and what are they?
    • Formula columns : For doing mathematical calculations and returning one value Summary Columns : For doing summary calculations such as summations...
  • What is a view ?
    • If we have several tables in a db and we want to view only specific columns from specific tables we...
  • Why doesn’t the following code give the desired result?
    • int x = 3000, y = 2000 ; long int z = x * y ; Ans: Here the multiplication is carried...
  • can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
    • yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be...

    Comments are closed.