1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

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 is the difference between db2start command and start database manager command?

1 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

what is the use of home directory???

1 Answers   HP,




Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

How to make a replica of existing oracle server to another server?

3 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

How to determine the service pack currently installed on SQL Server?

1 Answers  

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

1 Answers   CSC,

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories