Answer-first summary for fast verification
Answer: CTAS statements allow for manual schema declaration.
Let's break down each option to understand why 'A' is the correct answer: - **Option A**: This is **not true**. CTAS statements are designed to infer schema from the query results, not to support manual schema declaration. - **Option B**: This is **true**. CTAS indeed stands for CREATE TABLE AS SELECT, defining its purpose. - **Option C**: This is **true**. The SELECT part of CTAS retrieves data, which is then used to populate the newly created table immediately. - **Option D**: This is **true**. A key feature of CTAS is its ability to automatically determine the schema based on the query results. - **Option E**: This is **not true** because options B, C, and D are accurate statements about CTAS. Therefore, the statement that is **not true** about CTAS is that it supports manual schema declaration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which statement about CTAS (CREATE TABLE AS SELECT) statements is not accurate?
A
CTAS statements allow for manual schema declaration.
B
CTAS stands for CREATE TABLE AS SELECT statement.
C
Data is inserted into the table during its creation with CTAS.
D
CTAS statements infer schema information automatically from query results.
E
All the above statements are incorrect about CTAS.