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
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What authentication modes does sql server support? : sql server DBA
What happens on checkpoint? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
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.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is ora 24313?what is the procedure to exclude that error?
What is the difference between clustered and non-clustered index? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA