[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-883 Dumps with VCE and PDF 41-50

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-883
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-883.html

MySQL 5.6 Database Administrator

Question No: 41

Which two are correct steps in taking a binary backup of MyISAM tables?

  1. Always stop the server prior to the backup.

  2. Stop the server or lock the tables prior to the backup.

  3. Stop the server or lock the databases prior to the backup.

  4. Make a copy of the .frm, .myd, and the .myi files.

  5. Make a copy of the binary log and tablespace files.

Answer: B,D

Reference: http://dev.mysql.com/doc/refman/5.6/en/backup-methods.html

Question No: 42

Which two statements describe the behavior of the server’s SQL mode?

  1. The server’s SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.

  2. The server’s SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

  3. The server’s SQL mode can be changed at the session level with a SET SESSION sql_mode=”new_value” command.

  4. The server’s SQL mode, when globally set on a slave server, applies to events sent from the master.

Answer: A,C

Explanation: A: Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers.

C: To change the SQL mode at runtime, set the global or session sql_mode system variable using a SET statement:

SET GLOBAL sql_mode = #39;modes#39;; SET SESSION sql_mode = #39;modes#39;;

Note: The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable.

DBAs can set the global SQL mode to match site server operating requirements, and each application can set its session SQL mode to its own requirements.

Reference: 5.1.7 Server SQL Modes

Question No: 43

Consider the MySQL Enterprise Audit plugin,

You add the following lines to the my.cnf configuration tile: [mysqld]

Plugin-load=audit_log.so

Audit-log=FORCE_PLUS_PERMANENT

You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?

  1. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

  2. The audit_log.so library does not exist.

  3. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

  4. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

  5. The audit log file does not exist in which to write audit events.

  6. The audit_log.so library is not an executable file.

Answer: B,C

Explanation: * B C(not F): -plugin-load=plugin_list

This option tells the server to load the named plugins at startup. The option value is a semicolon-separated list of name=plugin_library pairs. Each name is the name of the plugin, and plugin_library is the name of the shared library that contains the plugin code. Each library file must be located in the directory named by the plugin_dir system variable. For example, if plugins named myplug1 and myplug2 have library files myplug1.so and myplug2.so, use this option to load them at startup:

shellgt; mysqld -plugin-load=quot;myplug1=myplug1.so;myplug2=myplug2.soquot;

  • not A, not D: To control the activation of the audit_log plugin, use this option:

    -audit-log[=value]

    Valid Values: ON, OFF, FORCE, FORCE_PLUS_PERMANENT

    This option controls how the server loads the audit_log plugin at startup. It is available only if the audit log plugin has been previously registered with INSTALL PLUGIN or is loaded with -plugin-load.

    -audit-log=FORCE_PLUS_PERMANENT tells the server to load the plugin and prevent it from being removed while the server is running.

    Reference: 6.3.12.6 Audit Log Plugin Options and System Variables; 5.1.3 Server Command Options

    Question No: 44

    A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:

    Last_SQL_Error: Error #39;Duplicate entry #39;8#39; for key #39;PRIMARY#39; #39; on query. Default database: #39;mydb#39;. Query: #39;insert into mytable VALUES (#39;8#39; , #39;George#39;) #39;

    Skip_Counter: 0

    Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1

    You execute a “SHOW CREATE TABLE mytable” on the slave:

    CREATE TABLE ‘mytable’ (

    ‘ID’ int(11) NOT NULL DEFAULT ‘0’,

    ‘name’ char(10) DEFAULT NULL, PRIMARY KEY (‘ID’)

    )

    The table mytable on the slave contains the following:

    Ensurepass 2018 PDF and VCE

    You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.

    Which statement should be used?

    1. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

    2. SET GTID_NEXT=”CONSISTENCY”; BEGIN; COMMIT;

      SET GTID_NEXT=” AUTOMATIC’;

    3. SET GLOBAL enforce_gtid_consistency=ON

    D. SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9″; E. SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9″; BEGIN; COMMIT;

    SET GTID_NEXT=”AUTOMATIC”;

    Answer: A

    Question No: 45

    Which two options describe how MySQL Server allocates memory?

    1. Each thread allocates memory from a global pool.

    2. Global memory resources are allocated at server startup.

    3. Thread memory is pre-allocated up to thread_cache_size for performance.

    4. Each connection may have its own per-thread memory allocations.

    Answer: B,D

    Question No: 46

    Which statement is true about the log-output variable?

    1. It is a static variable and can be set only at MySQL server startup.

    2. It enables and starts the General Query Log.

    3. It sets the target location for the binary logs generated by the MySQL sever.

    4. It specifies output destinations for the slow and General Query logs.

    Answer: D

    Question No: 47

    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?

    1. ALTER TABLE games REORGANIZE PARTITION (gMORES) INTO

      g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ), gMORES VALUES LESS THAN (MAXVALUE) );

    2. ALTER TABLE games

      ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) );

    3. ALTER TABLE games COALESCE PARTITION (gMORES) INTO

      g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ), gMORES VALUES LESS THAN (MAXVALUE) );

    4. ALTER TABLE games SPLIT PARTITION (gMORES) INTO

      g201305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ), gMORES VALUES LESS THAN (MAXVALUE) );

    5. 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) );

    Answer: B

    Question No: 48

    What are four capabilities of the mysql client program?

    1. Creating and dropping databases

    2. Creating, dropping, and modifying tables and indexes

    3. Shutting down the server by using the SHUTDOWN command

    4. Creating and administering users

    5. Displaying replication status information

    6. Initiating a binary backup of the database by using the START BACKUP command

    Answer: A,B,C,D,E

    Question No: 49

    A MySQL replication slave is set up as follows:

    ->User all InnoDB tables

    ->Receives ROW-based binary logs

    ->Has the read-only option

    The replication slave has been found in an error state.

    You check the MySQL error log file and find the following entries:

    2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653,

    Error_code: 1062

    2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’

    Error_code: 1062

    2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ’56_master-bin.000003′ position 496

    What are two possible causes for this error to occur?

    1. The slave was created with mysqldump -u root -p – skip-lock-table-all-databases gt;

      /data/data.sql

    2. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.

    3. For tables with UNIQUE keys, statement-based replication must be used maintain integrity.

    4. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

    5. The applications have the SUPER privilege, which allows them to update rows.

    Answer: A,E

    Question No: 50

    You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error:

    130123 10:38:02 [ERROR] mysqld: unknown option ‘-ssl’ What is the cause of the error?

    1. The — ssl level was not specified.

    2. The server was not started with the – enable-ssl-plugin option.

    3. – ssl is not a valid server option.

    4. The mysqld binary was not compiled with SSL support.

    5. The server’s SSL certificate was invalid.

    Answer: D

    100% Ensurepass Free Download!
    Download Free Demo:1z0-883 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-883 Dumps

    EnsurePass ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.