Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)

The lecture covers Oracle table compression, focusing on basic and advanced types. Basic compression reduces storage by deduplicating repeated values, effective in bulk-loaded, read-only tables. Direct path loading enhances performance by bypassing buffer cache. Implementation involves setting table attributes, with options for existing tables. The lecture emphasizes scenarios for optimal use and potential CPU overhead.

What are the three types of table compression mentioned in the lecture?

• Basic, Advanced, and Columnar

• Row, Column, and Hybrid

• Basic, Intermediate, and Advanced

• Simple, Complex, and Hybrid

How does basic compression reduce storage space?

• By removing unused columns

• By encrypting data

• By de-duplicating repeated values

• By compressing all data equally

In which scenario is basic compression most effective?

• With tables that have a lot of unique values

• With tables that use regular DML statements

• With tables that are read-only and loaded in bulk

• With tables that are frequently updated

What is a key benefit of using direct path loading?

• It supports transactional databases

• It compresses data more effectively

• It bypasses the buffer cache for efficiency

• It allows for real-time data updates

Which keyword is optional when enabling basic compression in a CREATE TABLE statement?

• COMPRESS

• ROW STORE

• BASIC

• APPEND

How can you disable compression for future inserts in a table?

• Change the table's primary key

• Use the statement ALTER TABLE COMPRESS OFF

• Use the statement ALTER TABLE NO COMPRESS

• Delete all existing rows

What happens to existing rows when the compression attribute of a table is changed?

• They are automatically compressed

• They remain uncompressed

• They are deleted

• They are moved to a new table