Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / guest

we have to audit that particular table

Is This Answer Correct ?    4 Yes 0 No

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

Answer / askvenki

plz explain clearly

Is This Answer Correct ?    1 Yes 0 No

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

Answer / abul kasam topon

setting up FGA(fine_grain_audit) properly and we can lookup
details who & when or what updated !

Is This Answer Correct ?    1 Yes 0 No

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

Answer / kunal sain

use trigger.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More DB Administration Interview Questions

what is rebuild index??

2 Answers   IBM, Sapient,

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

How can you enable a trace for a session?

1 Answers  

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  




what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

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

0 Answers  

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

For more DB Administration Interview Questions Click Here
Categories