2022 Current 1Z1-888 dumps Preparation through Our Practice Test [Q30-Q49]

Rate this post

2022 Current 1Z1-888 dumps Preparation through Our Practice Test

100% Reliable Microsoft 1Z1-888 Exam Dumps Test Pdf Exam Material

NEW QUESTION 30
You have installed the validate_passwordplug-in and set the validate_password_policyvariable.
Which validation is affected by the validate_password_policy setting?

whether a new password is rejected if it contains a word found in a dictionary file.

whether a new password is rejected if it contains the current user’s username.

the amount of delay after an incorrect password is entered

the length of time before a newly created password expires

NEW QUESTION 31
Where does MySQL Linux RPM install the mysqldbinary?

/usr/libexec/

/usr/local/mysql/bin/

/usr/sbin/

/usr/bin/

/opt/mysql/server/bin/

NEW QUESTION 32
Consider:

Which statement best describes the meaning of the values in the ref columns?

world.City.CountryCodeis used as the primary key for the Country table.

No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

world.City.CountryCode is used to sort the rows in the Citytable.

No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.

NEW QUESTION 33
Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

NEW QUESTION 34
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

The mysql service has already been started on the same port.

The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.

The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.

The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

NEW QUESTION 35
A MySQL replication slave is set up as follows:
Uses 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 these entries:

What are two possible causes for this error to occur? (Choose two.)

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

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

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

The slave was created with mysqldump -u root -p –skip-lock-tables -all-databases > /data/data.sql

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

NEW QUESTION 36
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

the mysql_upgrade script

the mysql client with the –ignore-password-hashing option

the mysql_secure_installation script to update server security settings

the mysql client with the –enable-cleartext-plugin option

the install plugin command for the mysql_cleartext_password plugin

NEW QUESTION 37
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

It caches index blocks for MyISAM tables only.

It caches index blocks for all storage engine tables.

It is a global buffer.

It is set on a per-connection basis.

It caches index blocks for InnoDB tables only.

NEW QUESTION 38
Which two statements describe how InnoDB recovery works?

InnoDB handles most crash recoveries automatically.

InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.

There will in general be lost committed transactions after a crash using the default settings.

It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.

It is recommended to set innodb_force_recovery = 1 as part of normal operations.

It is always required to enable innodb_force_recovery to perform a crash recovery.

NEW QUESTION 39
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

The value should be increased if the client performs several SELECToperations.

The join buffer is set per connection.

The join buffer is used to process sorts when complex joins are being performed.

The value should be increased from the default if the query joins large rows without using an index.

The join buffer is global and can be changed only by restarting the server.

NEW QUESTION 40
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

The host on the command line is not defined in the login path.

The mysqld instance has not been restarted after creating the login path.

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

NEW QUESTION 41
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

All these tables have the same number of rows.

The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

The session_status table is equivalent to status_by_thread for the current thread.

NEW QUESTION 42
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

–skip-opt

–lock-all-tables

–create-apply-log

–single-transaction

–master-data

NEW QUESTION 43
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

executing REVOKE LOAD FROM *.*

setting the –local-service=0 option when starting mysqld

executing REVOKE FILE FROM *.*

executing REVOKE FILE ON *.* FROM ‘ ‘ @’%’

setting the –local-infile=0 option when starting mysqld

setting the –open-files-limit=0 option when starting mysqld

NEW QUESTION 44
You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

The time the query took is the sum of all timer_wait values.

The query did not find its table in the table definition cache.

The query read data from the data file rather than directly from the buffer pool.

The event with event_id = 8945 is a child of the event with event_id=8944.

NEW QUESTION 45
old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

All data in p1 and p3 partitions is removed and the table definition is changed.

All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

It results in a syntax error because you cannot specify more than one partition in the same statement.

NEW QUESTION 46
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

–old-passwords, to start MySQL to use the old password format while running without the grant tables.

–reset-grant-tables, to start the server with only the mysql database accessible.

–read-only, to set all data to read-only except for super users

–skip-networking, to prohibit access from remote locations

NEW QUESTION 47
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.

All these tables have the same number of rows.

The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.

The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.

The session_statustable is equivalent to status_by_threadfor the current thread.

NEW QUESTION 48
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

it contains the binary log.

it contains a general tablespace.

it is the default location for all new tables that you create.

it contains the system tablespace.

it contains the redo log.

it contains the undo log.

NEW QUESTION 49
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

mysql –protocol=PLAIN -uroot -p -h dbhost.example.com

INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

SET GLOBAL mysql_cleartext_passwords=1;

mysql –enable-cleartext-plugin -uroot -p -h dbhost.example.com