Exam4Training

Which statement is TRUE about Big SQL?

Which statement is TRUE about Big SQL?
A . The table definition can include other attributes such as the primary key or check constraints
B . When using Big SQL, the CREATE TABLE statement cannot be embedded in an application program
C . If a sub-table is being defined, the authorization ID can be either the same as the owner of the root table or an equivalent
D . When defining a staging table associated with a materialized query table, the privileges held by the authorization ID of the statement only works with DBADM authority

Answer: D

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/fi/SSCRJT_5.0.2/ com.ibm.swg.im.bigsql.commsql.doc/doc/r0000927.html

Exit mobile version