Oracle
1Z0-883 · Question #99
1Z0-883 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
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
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.