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

Question Posted / guest

4 Answers
11157 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 is the difference between the SQL Loader and IMPORT utilities?

3 Answers

How would you extract DDL of a table without using a GUI tool?

0 Answers

what is meant by gateway

1 Answers IBM,

How would you go about generating an EXPLAIN plan?

2 Answers

how can you enable flashback feature?

0 Answers Oracle,

Where would you look for errors from the database engine?

0 Answers IBM,

how will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

what is a user-defined lock?

0 Answers Oracle,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

what is asm?

0 Answers Oracle,

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

For more DB Administration Interview Questions Click Here