Show the columns for the Primary Key constraints in tables owned by STUDENT (Note: Constraint Type is 'P' for Primary Key constraint).

What will be an ideal response?


```SELECT column_name, a.table_name
FROM all_constraints a, all_cons_columns b
WHERE a.owner = b.owner
AND a.table_name = b.table_name
AND a.constraint_name = b.constraint_name
AND a.owner = 'STUDENT'
AND constraint_type = 'P'```

Computer Science & Information Technology

You might also like to view...

To move one frame at a time in the Timeline, press ____.

A. [Tab] B. [Alt][Tab] C. [Shift][Tab] D. [.]

Computer Science & Information Technology

When creating a new keyboard macro, the new keyboard command should be entered in the ________ field within the Customize Keyboard dialog box

A) Press new shortcut key B) Categories C) Current keys D) Commands

Computer Science & Information Technology

A sans serif font contains thin lines on its characters

Indicate whether the statement is true or false

Computer Science & Information Technology

You want to configure a printer with two print devices so that the print server sends print jobs to the print device that is least busy. What should you configure?

A. printer priority B. job management C. printer pooling D. availability control

Computer Science & Information Technology