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
Answer Posted / 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 |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the default fill factor value? : sql server DBA
how to restore files with rman?
how can you process messages in order asynchronously?
What are the recovery models for a database? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what are the differences of where and if in SAS?
internal architecture
How do you trace the traffic hitting a sql server? : sql server DBA
Where would you look for errors from the database engine?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you create a user-defined lock?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what are the performance views in an oracle rac environment?