Answer Posted / kittu_chintu2005
logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
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.
How would you go about verifying the network name that the local_listener is currently using?
how can you implement fine-grained auditing?
How would you extract DDL of a table without using a GUI tool?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the steps you will take to improve performance of a poor performing query?
Query processing is slow(eg select query)how will u solve that
what is grd?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Where do you find the default index fill factor and how to change it? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What happens on checkpoint? : sql server DBA
What purpose does the model database server? : sql server DBA
what is the use of recording information about current session?
