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

What purpose does the model database server? : sql server DBA

0 Answers

what is meant by gateway

1 Answers IBM,

What view would you use to determine free space in a tablespace?

3 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

what r the types of backup?

5 Answers CSC,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

What is RAID and what are different types of RAID configurations?

1 Answers

If we issue alter database begin backup. What happens to database?

2 Answers

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

For more DB Administration Interview Questions Click Here