How would you determine who has added a row to a table?
Answer Posted / 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 |
Post New Answer View All Answers
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what are the types of connection load-balancing?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
which background process invoke at the time of upgradation tell me???
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what do you understand by flashback feature of oracle?
How would you go about verifying the network name that the local_listener is currently using?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the default fill factor value? : sql server DBA
how can you create a user-defined lock?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the steps you will take to improve performance of a poor performing query?
internal architecture