Ace Your Exams with Our Notes and Mock Tests!

EC-Council: Computer Hacking Forensic Investigator(CHFI-V10)
Module 11 : Database Forensics
Questions available : 15		You are not logged in. Please Login for track your learning progress

Q. No: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
		Go to Question No.

Question No 0

---

If you want to share the link of this question, please click here to "Copy Question Link" and share that generated link. Link from URL may change in future.

 

---

Bookmark this Question		QID: 653
Which of the following is considered as the starting point of a database and stores user data and database objects in an MS SQL server?
A:    Ibdata1
B:    Application data files (ADF)
C:    Transaction log data files (LDF)
D:    Primary data files (MDF)
Explanation: Ref: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver16 Primary: Contains startup information for the database and points to the other files in the database. Every database has one primary data file. The recommended file name extension for primary data files is .mdf. Secondary: Optional user-defined data files. Data can be spread across multiple disks by putting each file on a different disk drive. The recommended file name extension for secondary data files is .ndf. Transaction Log: The log holds information used to recover the database. There must be at least one log file for each database. The recommended file name extension for transaction logs is .ldf.