Answer / guest

While this variable does not directly store a value that
you can identify your database with, it does dictate how
you might connect to a remote database. This variable is
either TRUE or FALSE and if it is set to TRUE it enforces
database links to have the same name as the remote database
to which they are linking.

Regards
Abhinav Phadnis

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

---

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

3 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

Explain materialized views and how they are used.

0 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---