How would you determine who has added a row to a table?
Answers were Sorted based on User's Feedback
setting up FGA(fine_grain_audit) properly and we can lookup
details who & when or what updated !
| Is This Answer Correct ? | 1 Yes | 0 No |
How does Oracle guarantee data integrity of data changes?
Explain the concept of the DUAL table.
what is the difference between off-line back up and on-line back up in ibm db2 udb?
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
How can you enable a trace for a session?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How can we know the exact updation date of a particular database?
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?
What are the different types of indexes available in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How many memory layers are in the shared pool?
how can you connect from 10g user to 11g user??
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)