View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables.
Which is the best method to load data from the MARKS_DETAILStable to the MARKStable?
A.
Pivoting INSERT
B.
Unconditional INSERT
C.
Conditional ALL INSERT
D.
Conditional FIRST INSERT
what is the Marks_details, cann anybody tell me? It is definitivly not a table, because the subject_id as column-name can’t be identical. I mean,
create table markts_detail(Student_id number(4),
subject_id number(2),
marks_eng number(3),
subject_id number(2),
marks_math number(3),
subject_id number(2),
marks_phys number(3));
ORA-00957: duplicate column name
why is answer A. Pivoting INSERT??? please help.
in all oracle certifications 10% of the questions are in illegible indian and another 10% are totally senseless. this is a striking example.
the number of rows in table 1 is larger than the number of rows in table 2 so Pivoting will change the rows to colums, that is my point of view.
I find the table 1 insane 🙂 many colums have the same name !!