Posted by: Pdfprep
Post Date: November 27, 2020
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
Leave a Reply