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>;

What is dbcc? : sql server DBA

1217

---

what is the use of ocr?

964

---

what are the differences of where and if in SAS?

2134

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

933

---

What would you do with an "in-doubt" distributed transaction?

1831

---

What authentication modes does sql server support? : sql server DBA

1137

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1136

---

Explain materialized views and how they are used.

2381

---

what is grd?

1047

---

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

938

---

What are the different types of indexes available in sql server? : sql server DBA

1109

---

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

1022

---

What the different topologies in which replication can be configured? : sql server DBA

1179

---

how can you process messages in order asynchronously?

930

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2744

---