Author Topic: Oracle DBA Question 62  (Read 56 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 62
« on: April 21, 2009, 12:15:45 PM »
Question:
Examine the command:
CREATE TABLE employee

( employee_id NUMBER CONSTRAINT employee_empid_pk

PRIMARY KEY,

employee_name VARCNAR2(30),

manager_id NUMBER CONSTRAINT employee_mgrid_fk

REFERENCES employee(employee_id));

The EMP table contains self referential integrity requiring all NOT NULL values inserted in the
MANAGER_ID column to exist in the EMPLOYEE_ID column.

Which view or combination of views is required to return the of the foreign key constraint
and the referenced primary key?

A. DBA_TABLES only
B. DBA_CONSTRAINTS only
C. DBA_TABS_COLUMNS only
D. DBA_CONS_COLUMNS only
E. DBA_TABLES and DBA_CONSTRAINTS
F. DBA_TABLES and DBA_CONS_COLUMNS
 
Answer: B

Techronnati | where technology never sleeps

Oracle DBA Question 62
« on: April 21, 2009, 12:15:45 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
54 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.