Answer Posted / nishi
Memory area of oracle which consists of Library cache (recently executed sql and pl/sql statements) and Data Dictionary cache(recently used tables and indexes).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we view last record added to a table?
Explain the features of oracle?
Give the constructs of a package, function or a procedure.
What are a collation and state the different types of collation sensitivity?
How to drop a stored procedure in oracle?
Compare and contrast between sql and sql server and explain its various functions?
How to load excel data sheet to oracle database
Does oracle charge for java?
What are the set operators union, union all, minus & intersect meant to do?
What is a schema in oracle?
What are the limitations oracle database 10g xe?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to view all columns in an existing table?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is Trigger in Oracle?