ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
what are pseudocolumns?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are pseudocolumns?
Answer
# 1
pseudocolumns are the columns which are created by itself 
when the table is created. The examples of the 
pseudocolumns are rownum, rowid, currval, nextval and the 
level
 
Is This Answer Correct ?    1 Yes 0 No
Deva
 
  Re: what are pseudocolumns?
Answer
# 2
psedocolumns are the columns which can not be manipulated.
psedocoluns are only retrive. Examples are rowid,nextval etc
 
Is This Answer Correct ?    1 Yes 0 No
Niranjan Dhungia
 
 
 
  Re: what are pseudocolumns?
Answer
# 3
A pseudocolumn behaves like a table column, but is not 
actually stored in the table. You can select from 
pseudocolumns, but you cannot insert, update, or delete 
their values.
 
Is This Answer Correct ?    0 Yes 0 No
Soujanya
 
  Re: what are pseudocolumns?
Answer
# 4
Pseudocolumns are not actual columns in a table but they 
behave like columns. For example, you can select values 
from a pseudocolumn. However, you cannot insert into, 
update, or delete from a pseudocolumn. Also, pseudocolumns 
are allowed in SQL statements, but not in procedural 
statements. PL/SQL recognizes the following SQL 
pseudocolumns, which return specific data items: CURRVAL, 
LEVEL, NEXTVAL, ROWID, and ROWNUM.
 
Is This Answer Correct ?    1 Yes 0 No
Sohini
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is meant by recursive hints ?  1
what is primary key?  4
What is mean by Program Global Area (PGA) ? Bajaj2
Can a View based on another View ?  1
how to truncate date and get only time part 9:20:00  4
What is the difference between Outer join and Full outer join?  1
a query to select maxmun 3 salaries of employee table Polaris5
what is Table ?  1
what r tyhe major differences between oracle 9i & 10g?  2
can u call user defined functions in select statements  1
waht is referencial integrity? Semantic-Space2
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble  1
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance  1
which is the best training centre for learning oracle?  3
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables Mind-Tree6
What are the type of Synonyms?  1
what is foreign key?  4
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table  3
When does a Transaction end ?  1
when do u go for hash partitioning?  1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com