Define the SGA and: How you would configure SGA for a
mid-sized OLTP environment? What is involved in tuning the SGA?
No Answer is Posted For this Question
Be the First to Post Answer
When do we use group by clause in a sql query?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is a trigger and what are its types?
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.
can any one help me with import/export options in oracle............
What is ceil and floor in oracle?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to find no of saturdays in a month using single sql ?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is the difference between Outer join and Full outer join?
Explain the use of grant option in imp command.