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

Answers were Sorted based on User's Feedback



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

Answer / Ram Subhash Maurya

One method is to query the DBA_LOGSTAS table, which stores information about all database transactions. You can filter for DDL operations and sort by timestamp to see the changes in chronological order. Another method is to examine the control files and datafiles using operating system commands or Oracle utilities like SQL*Plus.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / vijayender singh

you can use logminer or streams

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Oracle AllOther Interview Questions

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  


Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  


Can we modify approve purchase order?if yes what is navigation?

1 Answers   L&T,


What is the difference between conversions and interfaces? : oracle accounts receivable

1 Answers  


What background process refreshes materialized views?

1 Answers  


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1 Answers  


Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,


What is autocashrule set? : oracle accounts receivable

1 Answers  


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1 Answers   TCS,


how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1 Answers  


which one is currently in used software cmpanies.

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)