1
Database and Application Forensics
easy
Refer to the exhibit. An investigator runs the queries on an Oracle database during a live forensic acquisition. What does the output indicate about the database transaction state?
Exhibit
Refer to the exhibit.
```
SQL> SELECT * FROM v$transaction;
ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAOFF STATUS START_SCNBAS START_SCNWRP
-------------- ------ ------- ------ ------ ------ ------ ------ -------- ------------ ------------
00000000C0F8 10 12 123456 4 5678 890 0 ACTIVE 1234567890 1
SQL> SELECT COUNT(*) FROM v$transaction WHERE status='ACTIVE';
COUNT(*)
----------
1
```