nerdexam
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

1Z0-882 question #90 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(20 responses)
  • A
    70% (14)
  • B
    5% (1)
  • C
    10% (2)
  • D
    15% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice