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 3nf normalization form?

0 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

What is use of except clause?

0 Answers  

---

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---