Interested to Buy Any Domain ? << Click Here >> for more details...
Give two methods you could use to determine what DDL changes
have been made.
- 2 Answers
- 11384 Views
- I also Faced
- E-Mail Answers
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
who owns the operating system files created by the utl_file package?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Why would you use sql agent? : 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 is the importance of a recovery model? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
what is ora 24313?what is the procedure to exclude that error?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where do you find the default index fill factor and how to change it? : sql server DBA
what are the performance views in an oracle rac environment?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is grd?
