Answer Posted / mohapatra.gouranga@gmail.com

1. DELETE FROM table_name A WHERE ROWID > (SELECT min
(rowid) FROM table_name B WHERE A.key_values =
B.key_values);

2. can you disable and enable primary key?
Yes,
e.g., alter table EHIS.HIPARTRANSACTIONDETAILS DISABLE
constraint FK_HIPAR_TRANS

3. how do you move tables/indexes from one tablespace to
another tablespace?

ALTER TABLE <schemaname.tablename> MOVE TABLESPACE
<tablespace_name>;

alter index <owner.indexname> rebuild online tablespace
<target_tablespace_name>;

Can you redefine a table online?

1119

---

What is the default port no on which sql server listens? : sql server DBA

1164

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1021

---

What are the steps you will take to improve performance of a poor performing query?

2851

---

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

1302

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1012

---

What the different components in replication and what is their use? : sql server DBA

1055

---

how can you find out if a table can be redefined?

1018

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1000

---

what is the role of dip user in our database?

2417

---

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.

1998

---

what are the performance views in an oracle rac environment?

1057

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2625

---

What is dbcc? : sql server DBA

1297

---

what is asm?

1059

---