Discussion
By default, SQL Server will create one data file and one log file for each newly created database.
Answer: A
Correct answer: True
A new database gets one data file, with the .mdf extension, and one log file with .ldf. Further data files can be added and placed on other disks for capacity or performance, but the arrangement created by default is the simplest one that works, and it keeps the data and the log separate from the start.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development