Question 1

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.Examine the output: Other-Image-30e9b1e03-8bbc-4275-a4c0-1ac8f11994b9 What statement is true about the start attempt?

Options :

A : MySQL server was not started due to a problem while executing process 2732.

B : MySQL server continued to start up even though another process existed.

C : systemd found the mysqld service disabled and failed to start it.

D : systemd waited for 30 seconds before timing out and start up failed.

E : systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: A

Question 2

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true? (Choose two.)

Options :

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C : The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 3

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.You then TRUNCATE this table to empty it.mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;mysql> TRUNCATE t1;Which two methods will restore data to the t1 table? (Choose two.)

Options :

A : mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B : $ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 4

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?

Options :

A : shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Question 5

You execute mysqladmin shutdown on a MySQL server that is decribed as follows:- It is running with both active and idle client connections.- It has open transactions against InnoDB.- It has active multi-row inserts into MyISAM engine tables.- Innodb_fast_shitdown is set to 1.What are three effects of shutting down the server by using a mysqladmin shutdown command?

Options :

A : Connections that have an open transaction are rolled back.

B : Connections with statements running against MyISAM tables wait for completion.

C : New client connections are not accepted after shutdown is initiated.

D : Connections are accepted during the shutdown process because a graceful shutdown can take large amounts of time.

E : Partial updates may occur for non-transactional tables.

Answer: A,C

Smartly Prepare Exam with Free Online 1Z0-908 Practice Test

Buying Options: