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.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

Describe what redo logs are.

1 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

0 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---