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.

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

What is fill factor? : sql server DBA

0 Answers  

---

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

2 Answers   Cognizant,

---

wat is global index and local indes

1 Answers   Oracle,

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---