Answer / rajat sharma

Data integrity is provided by various constrains
(UNIQUE,CHECk etc.) provided to us by SQL. By these
constrains the user cannot even make a mistake in inserting
the data.

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

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

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

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

0 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

What purpose does the model database server? : sql server DBA

0 Answers  

---