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 the use of ocr?

1025

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2025

---

how can you enable flashback feature?

941

---

how can you implement fine-grained auditing?

1118

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1063

---

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

2624

---

Query processing is slow(eg select query)how will u solve that

7891

---

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

1189

---

Explain materialized views and how they are used.

2432

---

What is fill factor? : sql server DBA

1234

---

what is grd?

1084

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2429

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2710

---

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

998

---

Which autogrowth database setting is good? : sql server DBA

1143

---