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

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

what is ora 24313?what is the procedure to exclude that error?

0 Answers  




what is the use of ocr?

0 Answers   Oracle,

What are the commands used in dcl? : sql server DBA

0 Answers  

why we use cursors

1 Answers  

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

What is the difference between online backup & offline backup?

3 Answers   CSC,

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories