Answer Posted / suman
three types of backups that is
1.physical backup:cold backup and hot backup
2.logical backup: export/import utility provided by oracle
3.Rman backup
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Can you redefine a table online?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
internal architecture
what is the role of dip user in our database?
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.
What is dcl? : sql server DBA