Ch. 11 Flashcards
1
Q
Which of the three different files storing data and logs in SQL servers holds the entire log information associated with the database?
A
Transaction log data file (LDF)
2
Q
Which file storing data and logs in SQL servers is optional?
A
Secondary data file (NDF)
3
Q
What file format is used by Windows Vista and later version to store event logs as simple text files in XML format?
A
EVTX
4
Q
For Forensic Analysis, what MySQL Utility Programs is used to export metadata, data, or both from one or more databases?
A
mysqldbexport
5
Q
What command line utility is used to take a backup of the database?
A
mysqldump
