You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
Explain the difference between sql and oracle?
How to start instance with a minimal initialization parameter file?
How to define a cusotmer as a supplier in ORACLE R12
Explain what are the characteristics of data files?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is difference between sid and service name in oracle?
can you explain performance tunning in oracle(sql,PL/SQL)
How to convert a string to a date in oracle database?
How view is different from a table?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Explain the use of owner option in exp command.
can a view be updated?