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

Question Posted / guest

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

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

0 Answers

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

Explain what partitioning is and what its benefit is.

2 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

How would you determine the time zone under which a database was operating?

2 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

For more DB Administration Interview Questions Click Here