Interested to Buy Any Domain ? << Click Here >> for more details...
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?????
- 2 Answers
- 6543 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What authentication modes does sql server support? : sql server DBA
What is dbcc? : sql server DBA
what is the use of ocr?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the commands used in dcl? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How would you go about verifying the network name that the local_listener is currently using?
how can you initialize log miner?
What the different topologies in which replication can be configured? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
what is grd?
What is dcl? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what do you understand by fine-grained auditing?
