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
Answer Posted / gogune suresh kumar
For DDL operations query user_objects table.
For DML you need to create a trigger for that.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how can you enable flashback feature?
What is fill factor? : sql server DBA
Explain materialized views and how they are used.
What purpose does the model database server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what do you understand by flashback feature of oracle?
what is the use of ocr?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the use of recording information about current session?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Explain about your sql server dba experience? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?