First Semester Exam Q11

11
a
ALTER TABLE EMPDATA
ADD CONSTRAINT PK_ID PRIMARY KEY (ID)

b
SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_NAME IN ('EMPDATA','EMPLOYEES'

c
DROP TABLE EMPDATA PURGE

Any Comments?

Hi, thanks so much for putting up all your solutions.. I just came to look at this one for Q11b...

Do you think all they want is just the table objects from the user_objects data - it seems from the question that they want every object that belongs to the table - that is found in the user_objects data - I imagine it can be found through joining the table with the object_id to some other table that lists the object_ids with the table they belong to... ???

What do you say?

Good luck for the exam...

Hi Leron

Question 8 c from Assignment 2 asked the same question and it was also for 4 point so I figure that's all they are requesting.

Good luck for you too..

You're right.

Thanks so much for replying.