🎴 Flashcard Mode
Oracle PL/SQL and Database Concepts
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which column is more skewed? Total no. of rows in the table are 1000
AnswerClick to flip back
A
Grade column has 2 distinct values having 1 and 999 rows
💡 Explanation:
Skewness measures data distribution unevenness. Grade column with 1 and 999 rows is extremely skewed - 99.9% of rows have one value. Deptno (200 each) and Location (300,400,300) have much more even distributions. Higher skewness means more uneven distribution, which affects query optimization and statistics collection.