|
INTERVIEW QUESTIONS
ORACLE
DETAILS
Question: What is pseudo columns ? Name them?
Answer: 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. This section describes these pseudocolumns: * CURRVAL * NEXTVAL * LEVEL * ROWID * ROWNUM
|
|
|
Category |
Oracle Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7758 users |
Added on |
9/18/2014 |
Views |
70575 |
Rate it! |
|
|
Question:
What is pseudo columns ? Name them?
Answer:
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. This section describes these pseudocolumns: * CURRVAL * NEXTVAL * LEVEL * ROWID * ROWNUM Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is Normalisation?
|
View Answer
|
|
What are Codd Rules?
|
View Answer
|
|
What is concurrency?
|
View Answer
|
|
What is the difference between candidate key, unique key and primary key?
|
View Answer
|
|
What are the OOPS concepts in Oracle?
|
View Answer
|
|
What are the Various Block Coordination Properties
|
View Answer
|
|
What are the Various Master and Detail Relation ships?
|
View Answer
|
|
How many Integrity Rules are there and what are they?
|
View Answer
|
|
What are Procedure, functions and Packages ?
|
View Answer
|
|
What are the Key Words Used in Oracle?
|
View Answer
|
|
What is a Transaction in Oracle
|
View Answer
|
|
How many types of Sql Statements are there in Oracle?
|
View Answer
|
|
What are the Back ground processes in Oracle and what are they?
|
View Answer
|
|
If a View on a single base table is manipulated will the changes be reflected on the base table ?
|
View Answer
|
|
What is a join ? Explain the different types of joins ?
|
View Answer
|
|
What is Referential Integrity ?
|
View Answer
|
|
How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?
|
View Answer
|
|
What is the Subquery ?
|
View Answer
|
|
What is difference between TRUNCATE & DELETE ?
|
View Answer
|
|
How do you find the numbert of rows in a Table ?
|
View Answer
|