You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
deference between & and &&
What is cardinality?
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Give the two types of tables involved in producing a star schema and the type of data they hold.
How would you go about increasing the buffer cache hit ratio?
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
what are the advantages of Oracle over other databases..? please give me reply...
Explain the difference between a data block, an extent and a segment.
what is shared memory?