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

when does an alert gets signaled?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

What is fill factor? : sql server DBA

by issuing "alter tablespace begin backup;" what happens to tablespace?

what is rebuild index??

what is a crs resource?

Where in the Oracle directory tree structure are audit traces placed?

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

why we use cursors

i had backup last manday.now i need back monday to now ..how do get backup?

What view would you use to look at the size of a data file?

Name three advisory statistics you can collect.

For more DB Administration Interview Questions Click Here