How would you determine who has added a row to a table?
Answer Posted / guest
we have to audit that particular table
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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
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
internal architecture
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how can you process messages in order asynchronously?
what is grd?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Where do you find the default index fill factor and how to change it? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how can you schedule a job in database?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is dbcc? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?