1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

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

0 Answers  

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

Datapump backup steps?

1 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

Give two examples of referential integrity constraints.

2 Answers  




How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

How do you resize a data file?

2 Answers  

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

what are the differences of where and if in SAS?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories