Does Oracle allow a composite key? If so, how is it defined?
What will be an ideal response?
Yes, composite key is allowed in Oracle tables. The composite primary key is defined at the table
level, and the column names are entered with a comma as a separator. For example,
CONSTRAINT dependent_empid_depid_pk
PRIMARY KEY (EmployeeId, DependentId)
Computer Science & Information Technology
You might also like to view...
A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary. What is the first step to subtotal departmental salaries?
A) Sort by Salary B) Sort by Department C) Sort by Last Name D) Sort by Rank
Computer Science & Information Technology
Compare and contrast the VFS and ext2 representation of an inode.
What will be an ideal response?
Computer Science & Information Technology