單項(xiàng)選擇題

Which syntax turns an existing constraint on?（）

A. ALTER TABLE table_name   ENABLE constraint_name;
B. ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
C. ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
D. ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
E. ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;

你可能感興趣的試題

單項(xiàng)選擇題

Which syntax turns an existing constraint on?（）

A. ALTER TABLE table_name ENABLE constraint_name;
B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

單項(xiàng)選擇題

Management has asked you to calculate the value 12salary commission_pct for all the employees in the EMP table. The EMP table contains these columns:

Which statement ensures that a value is displayed in the calculated columns for all employees?（）

A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

Which syntax turns an existing constraint on?（）

你可能感興趣的試題

Which syntax turns an existing constraint on?（）

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（）

Management has asked you to calculate the value 12salary commission_pct for all the employees in the EMP table. The EMP table contains these columns:

Which statement ensures that a value is displayed in the calculated columns for all employees?（）