How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2051

What is the usage of analyze command in oracle?

1031

How to create a new table by selecting rows from another table?

1016

What is user managed backup in Oracle?

1075

What is program global area (pga) in oracle?

956

How to enter a new row into a table interactively?

960

What is a relational database management system?

1061

What is the purpose of tables, private synonyms and public synonyms in Oracle?

977

what is Single Byte Overhead...?

2498

How to open a cursor variable?

973

What is a nested table and how is it different from a normal table?

985

How to manage transaction isolation level?

948

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1322

What happens if you set the sga too low in oracle?

1051

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2093