单项选择题

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

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;

单项选择题

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

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

多项选择题

In which two cases would you use an outer join? （）

A. The tables being joined have NOT NULL columns.
B. The tables being joined have only matched data.
C. The columns being joined have NULL values.
D. The tables being joined have only unmatched data.
E. The tables being joined have both matched and unmatched data.
F. Only when the tables have a primary key/foreign key relationship.