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)- A16% (4)
- B72% (18)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.