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.

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

2 Answers  

---

Describe what redo logs are.

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---