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
Explain materialized views and how they are used.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is a correlated sub-query? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what do you understand by flashback feature of oracle?
how can you find out if a table can be redefined?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what are the benefits of flashback feature?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?