Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Sql server 2
« Previous
Next »
SQL Server 2008 supports two types of compression. Which are they?
Options
- Row level and column level
- Row level and page level
CORRECT ANSWER : Row level and page level
Discussion Board
Types of Compression
There are two types of compression:
1. Row Level Compression
2. Page Level Compression
1. Row Level Compression: Row level compression is one of the type where there is no compression algorithm is used. The main aim of row level compression is to make fixed data types to a variable data type thereby reducing the size. This type of compression will remove any extra bytes in the fixed data type. One main consideration in this type of compression is that, data schema and data distribution directly plays an important role with respect to compression ratio.
2. Page Level Compression: Page level compression type can give more compression ratio compared to Row level. Page compression uses dictionary based compression algorithm to attain more compression ratio. The main aim of page level compression is to reduce column redundancy in one or more rows in a data page.
Prajakta Pandit 03-7-2017 11:19 PM
plz give me runtime souliation this question
i do real time pratice .but i have not recvied output plz send me souliation
adi jangle 01-31-2015 08:10 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲