Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To leverage table properties for identifying the business owner of each table, which of the following DDL syntaxes correctly populates a table property named 'business_owner'?
A
CREATE TABLE inventory (id INT, units FLOAT) SET TBLPROPERTIES business_owner = ‘supply chain‘
B
CREATE TABLE inventory (id INT, units FLOAT) SET (business_owner = ‘supply chain’)
C
CREATE TABLE inventory (id INT, units FLOAT) SET PROPERTY (business_owner = ‘supply chain’)
D
CREATE TABLE inventory (id INT, units FLOAT) TBLPROPERTIES (business_owner = ‘supply chain‘)
E
CREATE TABLE inventory (id INT, units FLOAT) SET TAG (business_owner = ‘supply chain’)
