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
7119 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

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

How would you extract DDL of a table without using a GUI tool?

0 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

Explain the difference between a data block, an extent and a segment.

2 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

what is the use of ocr?

0 Answers Oracle,

which background process will run @ the time of creation of catalog database

1 Answers CSC,

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers

For more DB Administration Interview Questions Click Here