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
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are statistics, under what circumstances they go out of date, how do you update them?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What happens on checkpoint? : sql server DBA
What is the default fill factor value? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you implement fine-grained auditing?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What the different components in replication and what is their use? : sql server DBA
what is asm?
What is transparent data encryption? : sql server DBA
what do you understand by flashback feature of oracle?