IBM Db2 11.5 DBA for LUW — Question 2

A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical data. Which one of the following statements is true for using HiveQL?

Answer options

• A. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS
• B. It does not support nested sub-queries
• C. Hive supports all ANSI SQL 2011 syntax
• D. All of the above

Correct answer: A

Explanation

The correct answer is A because HiveQL indeed supports the specified logical operators in query predicates. Option B is incorrect as Hive does not allow nested sub-queries, and Option C is also false since Hive does not support the entire ANSI SQL 2011 syntax. Therefore, D, which claims that all previous statements are true, is also incorrect.