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 ACID Property of Transaction?

10 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

What will be the maximum number of indexes per table?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---