Describe the physical structure of a database.

What will be an ideal response?


Each database that is mounted on a SQL Server instance has two main physical file types.   Data files store the database objects and their underlying data. These files are given a .mdf file extension. Data files are subdivided into physical units of storage called pages, which are grouped together for space management into extents, which are collections of eight pages. Log files record the series of changes that occur to a database over time, and they enable a database to be restored to a specific point in time. These files are given an .ldf file extension.

Computer Science & Information Technology

You might also like to view...

A machine that accepts input, processes and stores data, and produces output is called a(n) ____.

A. computer B. device C. word processor D. PC

Computer Science & Information Technology

Outflows of cash are represented by positive numbers

Indicate whether the statement is true or false.

Computer Science & Information Technology

As you enter text in the Word document window, you must press the ENTER key when the insertion point reaches the right margin.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

When is the base case first > last (where first is the index of the first item in the array and last is the index of the last item in the array) reached in a recursive binary search algorithm?

What will be an ideal response?

Computer Science & Information Technology