Give two methods you could use to determine what DDL changes have been made.

Give two methods you could use to determine what DDL changes
have been made.

Question Posted / guest

Answers were Sorted based on User's Feedback

Give two methods you could use to determine what DDL changes have been made...

Answer / santo

DDL statements will be recorded in Alert log files?

Is This Answer Correct ?

17 Yes

3 No

Give two methods you could use to determine what DDL changes have been made...

Answer / monal

IN SQL 2005:

YOU CAN CREATE DDL TRIGGER TO TRACK CHANGES MADE WITH DDL
STATEMENTS.

Is This Answer Correct ?

5 Yes

4 No

More DB Administration Interview Questions

What is a system database and what is a user database? : sql server DBA

what is grd?

What column differentiates the V$ views to the GV$ views and how?

what is meant by gateway

what do you understand by flashback feature of oracle?

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

How will u copy the objects of one schema to another schema in datapump & export/import?

Why would you use sql agent? : sql server DBA

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

What are the recovery models for a database? : sql server DBA

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

For more DB Administration Interview Questions Click Here