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

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

when does an alert gets signaled?

0 Answers   Oracle,

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,




If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

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  

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

what do you understand by fine-grained auditing?

0 Answers   Oracle,

what is the use of home directory???

1 Answers   HP,

What is replication? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories