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
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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different types of replication and why are they used? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
internal architecture
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is a system database and what is a user database? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.