Give two methods you could use to determine what DDL changes
have been made.
Answer Posted / monal
IN SQL 2005:
YOU CAN CREATE DDL TRIGGER TO TRACK CHANGES MADE WITH DDL
STATEMENTS.
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
what is the use of ocr?
What is the default fill factor value? : sql server DBA
how can you connect from 10g user to 11g user??
Explain about your sql server dba experience? : sql server DBA
how does an oracle clusterware manage crs resources?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is the role of dip user in our database?
What the different components in replication and what is their use? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what do you understand by fine-grained auditing?
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?
What is dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
Where would you look for errors from the database engine?
what are the differences of where and if in SAS?