Answer / kalyana chakravarthy maddipati

You can make a remote connection in a database using DBLINK(Database link). it is a named object in the database.
To create a DBLINK this is the syntax

Create dblink XX(DBLInk Name) connect to USERNAME identified by PASSWORD using DATABASENAME.

To access data from remote place using DBLink this is the way

select * from table_name@xx(DBLink name).

What is Online Index Rebuild Operation?

1 Answers  

---

What are indexes in ms sql server?

0 Answers  

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

How can a user-defined datatype be created?

0 Answers  

---

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---

What is indexing and its types?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---