單項(xiàng)選擇題

Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）

A.USER_CONSTRAINTS
B.USER_OBJECTS
C.ALL_CONSTRAINTS
D.USER_CONS_COLUMNS
E.USER_COLUMNS

你可能感興趣的試題

Which four are attributes of single row functions? （）

A.cannot be nested
B.manipulate data items
C.act on each row returned
D.return one result per row
E.accept only one argument and return only one value
F.accept arguments which can be a column or an expression

單項(xiàng)選擇題

Evaluate this SQL statement:
e.employee_id, (.15* e.salary) + (.5 * e.commission_pct)
+ (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id = s.emp_id;
What will happen if you remove all the parentheses from the calculation?（）

A.The value displayed in the CALC_VALUE column will be lower.
B.The value displayed in the CALC_VALUE column will be higher.
C.There will be no difference in the value displayed in the CALC_VALUE column.
D.An error will be reported.

Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）

你可能感興趣的試題

Which four are attributes of single row functions? （）

Evaluate this SQL statement: e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation?（）

Evaluate this SQL statement:
e.employee_id, (.15* e.salary) + (.5 * e.commission_pct)
+ (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id = s.emp_id;
What will happen if you remove all the parentheses from the calculation?（）