Answer / Praveen Kumar Dubey

To access a database remotely, you need to ensure that the database server is configured to accept remote connections. This typically involves allowing the appropriate network protocol and port in your firewall settings, and setting up user authentication. For PostgreSQL, you can add 'listen_addresses = '*'' to the postgresql.conf file.

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

2 Answers   Wipro,

---

What is database management system(dbms) and why it is used?

1 Answers  

---

What is Database testing and What are ways of writing test cases for database testing?

1 Answers   Ittiam Systems,

---

What is an image database?

1 Answers  

---

Is driver a software?

1 Answers  

---

What are the key constraints in dbms?

1 Answers  

---

Is it good to save image in database?

1 Answers  

---

What is Two-Phase Commit ?

3 Answers  

---

Define data, entity, domain and referential integrity?

1 Answers  

---

Define identity and uniqueidentifier property of column?

1 Answers  

---

What is the difference between multiload and fastload interms of performance?

1 Answers  

---

What is progress open edge?

1 Answers  

---