ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam

Access More Questions

What is the relationship between the ORDER BY clause and the PRIMARY KEY in a MergeTree table when PRIMARY KEY is not explicitly specified?

The primary key defaults to the first column regardless of ORDER BY The primary key is automatically set equal to the ORDER BY expression A table without an explicit PRIMARY KEY has no sparse index PRIMARY KEY must always be specified separately from ORDER BY

Correct Answer:

The primary key is automatically set equal to the ORDER BY expression

Access more questions from this quiz

Continue to ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam for more practice questions and the full quiz experience.

Access More Questions