PrepAway - Latest Free Exam Questions & Answers

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

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