Answer Posted / nagesh yadav

1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.

what is grd?

1103

---

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.

2290

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2309

---

what are the benefits of flashback feature?

1030

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1988

---

Which autogrowth database setting is good? : sql server DBA

1164

---

when does an alert gets signaled?

1062

---

What are the different ways you can create databases in sql server? : sql server DBA

1146

---

what is the role of dip user in our database?

2419

---

What the different components in replication and what is their use? : sql server DBA

1057

---

what functionality does oracle provide to secure sensitive information?

1005

---

What is dbcc? : sql server DBA

1299

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2209

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2417

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1051

---