Free Oracle 1z0-883 Exam Dumps Questions & Answers

Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?

• A.  It shows how many columns in the index are examined.
• B.  It shows the number of characters indexed in the key.
• C.  It shows how many bytes will be used from each index row.
• D.  It shows the total size of the index row.

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.
Which method would use mysqlbinlog for greater consistency?

• A.  shell> mysqlbinlog - include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql
• B.  shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql
• C.  shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
• D.  shell> mysqlbinlog - restore bin.00010 bin.00011 bin.00012

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?

• A.  ALTER TABLE games
  COALESCE PARTITION (gMORES)
  INTO
  g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
  gMORES VALUES LESS THAN (MAXVALUE) );
• B.  ALTER TABLE games
  SPLIT PARTITION (gMORES)
  INTO
  g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
  gMORES VALUES LESS THAN (MAXVALUE) );
• C.  ALTER TABLE games
  ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') );
• D.  ALTER TABLE games
  REORGANIZE PARTITION (gMORES)
  INTO
  g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
  gMORES VALUES LESS THAN (MAXVALUE) );
• E.  ALTHER TABLE games
  DROP PATITION gMORES,
  ADD PARTITION
  g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
  gMORES VALUES LESS THAN (MAXVALUE) );

Which three statements are true about memory buffer allocation by a MySQL Server?

• A.  All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
• B.  User buffers are allocated at server startup and freed when the user is dropped.
• C.  Thread buffers are allocated when a client connects, and are freed when the client disconnects.
• D.  Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
• E.  Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

• A.  A clustered index is a grouping of indexes from different tables into a global index for faster searching.
• B.  A clustered index allows fulltext searching within InnoDB,
• C.  The first unique index is always used as a clustered index and not a primary key.
• D.  A clustered index provides direct access to a page containing row data.
• E.  A primary key must exist for creation of a clustered index.
• F.  If no indexes exist, a hidden clustered index is generated based on row IDs.
• G.  A primary key is used as a clustered index.