Answer / raman

select DBTIMEZONE from dual;

Answer / daid kumar

select * from V$NLS_Parameters
it show the Time Zone Format

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---