Oracle
1Z0-882 · Question #90
You have two test tables: Code_innodb as InnoDB engine Code_ myisam as MYISAM engine The tables have the same structure: The tables have one row of data: You execute an INSERT statement on both…
The correct answer is A. Option A. See the full explanation below for the reasoning.
Question
You have two test tables:
Code_innodb as InnoDB engine Code_ myisam as MYISAM engine The tables have the same structure:
The tables have one row of data:
You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:
mysql> INSERT INTO code_innodb VALUES (1, Alpha'), (2, Beta'), (3, charlie,),(4, Delta'); ERROR 1062 (23000): Duplicate entry 3' for key PRIMARY' Mysql> INSERT INTO code_myisam VALUES (1, Alpha'), (2, Beta'), (3, charlie'), (4, Delta'); ERROR 1062 (23000); Duplicate entry 3' for key PRIMARY' What is the expected output of the SELECT statements?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(20 responses)- A70% (14)
- B5% (1)
- C10% (2)
- D15% (3)
Community Discussion
No community discussion yet for this question.
