hi, suppose i created one table after few days i did some insert,update how c

hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table

Question Posted / venubabu polineni

3 Answers
7130 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / prashe

select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.

Is This Answer Correct ?

2 Yes

0 No

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / naga bandaru

we should go with log minor or streams to find when DML
operation have been performed.

Is This Answer Correct ?

2 Yes

0 No

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / gogune suresh kumar

For DDL operations query user_objects table.
For DML you need to create a trigger for that.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More DB Administration Interview Questions

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

Why would you use sql agent? : sql server DBA

0 Answers

What is transparent data encryption? : sql server DBA

0 Answers

what do you understand by flashback feature of oracle?

0 Answers Oracle,

what is the use of home directory???

1 Answers HP,

what are the differences of where and if in SAS?

0 Answers

What happens on checkpoint? : sql server DBA

0 Answers

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers TCS,

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

what is ora 24313?what is the procedure to exclude that error?

0 Answers

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

2 Answers

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers

For more DB Administration Interview Questions Click Here