Answer Posted / sree

1. physical and Logical backup
2.cold backup
3.No.. we can't take partial backup in no archivelog mode
4.No... we can't take online backups if the database running in noarchivelog mode.

how can you get actual data change values from previous transactions in oracle?

1138

---

what is grd?

1152

---

How do you trace the traffic hitting a sql server? : sql server DBA

1628

---

What is the default port no on which sql server listens? : sql server DBA

1213

---

How would you go about verifying the network name that the local_listener is currently using?

3271

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1251

---

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.

2043

---

What is a system database and what is a user database? : sql server DBA

1312

---

what are the benefits of flashback feature?

1089

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2574

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2520

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1160

---

what functionality does oracle provide to secure sensitive information?

1049

---

Where would you look for errors from the database engine?

2897

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2025

---