nerdexam
Oracle

1Z0-883 · Question #99

Consider the following table: CREATE TABLE game' ( id' int (10) unsigned NOT NULL AUTO_INCREMENT, keyword' varchar (45) DEFAULT NULL, date' datetime NOT NULL, PRIMARY KEY (id' , date'), UNIQUE KEY…

The correct answer is B. ALTER TABLE games. See the full explanation below for the reasoning.

Question

Consider the following table:

CREATE TABLE game' ( id' int (10) unsigned NOT NULL AUTO_INCREMENT, keyword' varchar (45) DEFAULT NULL, date' datetime NOT NULL, PRIMARY KEY (id' , date'), UNIQUE KEY keyword_idx' (keyword' , date') ) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY RANGE (TO_DAYS (date) ) ( PARTITION g201301 VALUES LESS THAN (TO_DAYS (2013-01-01 00:00:00') ), PARTITION g201302 VALUES LESS THAN (TO_DAYS (2013-02-01 00:00:00') ), PARTITION g201303 VALUES LESS THAN (TO_DAYS (2013-03-01 00:00:00') ), PARTITION g201304 VALUES LESS THAN (TO_DAYS (`2013-04-01 00:00:00') ), PARTITION gMORES VALUES LESS THAN (MAXVALUE) ); Which method should used to add a new g201305 partition to the table?

Options

  • AALTER TABLE games
  • BALTER TABLE games
  • CALTER TABLE games
  • DALTER TABLE games
  • EALTHER TABLE games

How the community answered

(25 responses)
  • A
    16% (4)
  • B
    72% (18)
  • C
    8% (2)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice