niusouti.com

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE

题目
Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.


相似考题
更多“Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?() ”相关问题
  • 第1题:

    7、Statement对象提供了执行基本SQL语句的功能。


    正确

  • 第2题:

    ()接口继承了Statement接口,用来执行预编译的SQL语句。


    错误

  • 第3题:

    3.下列选项中,关于Statement描述错误的是() A: Statement是用来执行SQL语句的 B: Statement是PreparedStatement的子接口 C: 获取Statement实现需要使用Connection的createStatement()方法 D: PreparedStatement能使用参数占位符,而Statement不行

    A.A B C D

    B.A B C D

    C.A B C D

    D.A B C D


    Statement 是 PreparedStatement 的子接口

  • 第4题:

    下列选项中,关于Statement描述错误的是()

    A.Statement是用来执行SQL语句的

    B.Statement是PreparedStatement的子接口

    C.获取Statement实现需要使用Connection的createStatement()方法

    D.PreparedStatement能使用参数占位符,而Statement不行


    Statement是PreparedStatement的子接口

  • 第5题:

    Statement对象本身包含SQL语句。


    错误

  • 第6题:

    1、写出Java程序中用Statement来执行sql查询与更新语句。


    正确