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

Name a tablespace automatically created when you create a database.

What is the difference between dropping a database and taking a database offline? : sql server DBA

What is the difference between Datapump & export/import?

Which environment variables are absolutely critical in order to run the OUI?

what is the difference between db2start command and start database manager command?

How do you switch from an init.ora file to a spfile?

How would you determine who has added a row to a table?

what is meant by gateway

any body know about orawaves do they really provide placements in their unique placement program

now one user in online.now i want drop him..how do u drop him?

Explain how you would restore a database using RMAN to Point in Time?

How to make a replica of existing oracle server to another server?

For more DB Administration Interview Questions Click Here