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

Answers were Sorted based on User's Feedback



1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how ..

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

Is This Answer Correct ?    4 Yes 0 No

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how ..

Answer / anil kumar prajapati

1. DELETE FROM
table_name A
WHERE
a.rowid >
ANY (
SELECT
B.rowid
FROM
table_name B
WHERE
A.col1 = B.col1
AND
A.col2 = B.col2
);
2.CREATE TABLE table_name
(
column1 datatype null/not null,
column2 datatype null/not null,
...

CONSTRAINT constraint_name PRIMARY KEY (column1, column2,
... column_n)
);
3.ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE
<destination TABLESPACE NAME>

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

how can you process messages in order asynchronously?

0 Answers   Oracle,


How would you go about increasing the buffer cache hit ratio?

2 Answers  


what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


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

0 Answers  






Oracle 11g new features?

2 Answers  


what are the differences of where and if in SAS?

0 Answers  


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


How to make a replica of existing oracle server to another server?

3 Answers  


Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  


What view would you use to look at the size of a data file?

3 Answers  


How do you resize a data file?

2 Answers  


Categories