單項(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

你可能感興趣的試題

單項(xiàng)選擇題

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）

A. GRANT select ON dept TO ALL_ USER;
B. GRANT select ON dept TO ALL;
C. GRANT QUERY ON dept TO ALL_USERS
D. GRANT select ON dept TO PUBLIC;

單項(xiàng)選擇題

Which constraint can be defined only at the column level? （）

A. UNIQUE
B. NOT NULL
C. CHECK
D. PRIMARY KEY
E. FOREIGN KEY