How would you determine who has added a row to a table?
- 4 Answers
- 9636 Views
- I also Faced
- E-Mail Answers
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 can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the operating modes in which database mirroring runs? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how do see how much space is used and free in a tablespace
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
What is replication? : sql server DBA
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you go about generating an EXPLAIN plan?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
what is a user-defined lock?
What command would you use to create a backup control file?
What are the steps you will take to improve performance of a poor performing query?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
