31. Point out the correct statement. A. -helpusage display a usage message B. The JDBC connection URL format has the prefix jdbc:hive: C. Starting with Hive 0.14, there are improved SV output formats D. None of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
32. Types that may be null must be defined as a . . . . . . . . of that type and Null within Avro. A. Union B. Intersection C. Set D. All of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
33. Which of the following is a command line option? A. -d,–define <key=value> B. -e,–define <key=value> C. -f,–define <key=value> D. None of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
34. Which of the following operator executes a shell command from the Hive shell? A. | B. ! C. ^ D. + Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
35. Which is the additional command line option is available in Hive 0.10.0? A. -database <dbname> B. -db <dbname> C. -dbase <<dbname> D. All of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
36. Integral literals are assumed to be . . . . . . . . by default. A. SMALL INT B. INT C. BIG INT D. TINY INT Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
37. Point out the wrong statement. A. TIMESTAMP is Only available starting with Hive 0.10.0 B. DECIMAL introduced in Hive 0.11.0 with a precision of 38 digits C. Hive 0.13.0 introduced user definable precision and scale D. All of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
38. Hive uses . . . . . . . . style escaping within the strings. A. C B. Java C. Python D. Scala Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
39. Which of the following data type is converted to Array prior to Hive 0.12.0? A. map B. long C. float D. bytes Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board
40. Point out the correct statement. A. Hive Commands are non-SQL statement such as setting a property or adding a resource B. Set -v prints a list of configuration variables that are overridden by the user or Hive C. Set sets a list of variables that are overridden by the user or Hive D. None of the mentioned Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
