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
what are the benefits of flashback feature?
Where do you find the default index fill factor and how to change it? : sql server DBA
Where would you look for errors from the database engine?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the different ways you can create databases in sql server? : sql server DBA
how can you process messages in order asynchronously?
What is dbcc? : sql server DBA
What are the recovery models for a database? : sql server DBA
What is a system database and what is a user database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are statistics, under what circumstances they go out of date, how do you update them?
What types of replication are supported in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?