how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

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,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---