(i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this without affecting the children tables?(II)you want to group the following set of selected returns ,what can you grioup on?max(sum_of_cost),min(sum_of_cost),count(item_no),item_no(iii)"to delete duplicate records from table leaving on set of records"

Interview Candidate
Jan 23rd, 2007
3
2004

Showing Answers 1 - 3 of 3 Answers

geetha24
Profile Answers by geetha24 Questions by geetha24

Feb 13th, 2007

1. Drop the constraints first and then drop the table. Recreate table and the constraints.

sunil saini

Feb 27th, 2007

(1) use cascade option in query

shravanam
Profile Answers by shravanam Questions by shravanam

Oct 24th, 2007

i. YOU CAN NOT DELETE A PARENT TABLE WITHOUT DELETING CHILDREN TABLES. BUT VICE VERSA CAN TAKE PLACE.

II. IF YOU HAVE ITEM CATEGORY THEN U CAN HAVE GROUP BY EXPRESSION ON ITEM_CATEGORY.

III. DELETE FROM testduplicate
a WHERE rowid NOT IN (select max(rowid) FROM testduplicate b
WHERE a.tname=b.tname AND a.tid=b.tid);