How would you determine who has added a row to a table?
Answer Posted / kunal sain
use trigger.
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
What are the commands you'd issue to show the explain plan for "select * from dual"?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is dcl? : sql server DBA
what are the types of connection load-balancing?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is transparent data encryption? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
how can you initialize log miner?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is fill factor? : sql server DBA