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

Question Posted / guest

4 Answers
11497 Views
I also Faced
E-Mail Answers

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

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

How can you gather statistics on a table?

3 Answers

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers TCS,

what do you understand by fine-grained auditing?

0 Answers Oracle,

how can you get actual data change values from previous transactions in oracle?

0 Answers Oracle,

Give two examples of how you might determine the structure of the table DEPT.

2 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

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

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

Where would you look for errors from the database engine?

0 Answers IBM,

What types of replication are supported in sql server? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here