Explanation:String literals can be expressed with either single quotes (‘) or double quotes (“). 8. Which of the following statement will create column with varchar datatype ?
A. CREATE TABLE foo (bar CHAR(10))
B. CREATE TABLE foo (bar VARCHAR(10))
C. CREATE TABLE foo (bar CHARVARYING(10))
D. All of the mentioned
Answer:A
Explanation:String literals can be expressed with either single quotes (‘) or double quotes (“). 8. Which of the following statement will create column with varchar datatype ?
A. CREATE TABLE foo (bar CHAR(10)) B. CREATE TABLE foo (bar VARCHAR(10)) C. CREATE TABLE foo (bar CHARVARYING(10)) D. All of the mentioned
Explanation:Varchar datatype was introduced in Hive 0.12.0 9. _________ will overwrite any existing data in the table or partition