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

Question Posted / guest

4 Answers
11487 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

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

1 Answers STC,

what do you understand by fine-grained auditing?

0 Answers Oracle,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

How do you resize a data file?

2 Answers

What the different topologies in which replication can be configured? : sql server DBA

0 Answers

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

Name two files used for network connection to a database.

5 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

When a user process fails, what background process cleans up after it?

1 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here