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
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 |
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 |
how can you record information about current session?
one datafile is lost in standy side how can you recover that??
What are the different types of indexes available in sql server? : sql server DBA
why we use cursors
Name three advisory statistics you can collect.
what is the diffrence between core dba and apps dba?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
What are statistics, under what circumstances they go out of date, how do you update them?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
How to start SQL Server in minimal configuration mode?