Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

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

3 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

What is dcl? : sql server DBA

0 Answers  

---

how to restore files with rman?

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---