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
Why would you call update statistics? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How to start SQL Server in minimal configuration mode?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you create a user-defined lock?
Where would you look for errors from the database engine?
What is a correlated sub-query? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
internal architecture
How can you control the amount of free space in your index pages? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a user-defined lock?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the importance of a recovery model? : sql server DBA