Practice Test for 1Z0-908 Certification Real 2023 Mock Exam [Q70-Q85] : Latest Exam Prep : http://certify.vceprep.com

NO.70 Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

NO.71 You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

NO.72 Examine this command, which executes successfull
mysqlbackup –defaults-file=/backups/server-my.cnf –backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

The copy-back process is used to overwrite a new backup over an existing backup.

It restores files from the data directory to their original MySQL server locations.

It restores files from the backup directory to their original MySQL server locations.

The copy-back process makes inconsistent backups.

NO.73 You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

–shared-memory-base-name=world

–protocol=UDP

–protocol=pipe

–password

–user=admin

–host=192.0.2.1

–socket=/tmp/mysql.sock

–port=3306

–database=world

NO.74 Examine these commands and output:

Which connection ID is holding the metadata lock?

NO.75 Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

Mark can grant the privileges assigned to the r_read@localhost role to another user.

ADMIN OPTION causes the role to be activated by default.

Mark can grant the r_read@localhost role to another user.

Mark can revoke the r_read@localhost role from another role.

ADMIN OPTION allows Mark to drop the role.

Mark must connect from localhost to activate the r_read@localhost role.

NO.76 Examine this query:

What information does this query provide?

total memory used across all connections associated with the user on connection number 10

total memory used by the first 10 connections

total memory used by thread number 10

total memory used across all connections associated with the user on thread number 10

total memory used by connection number 10

total memory used by the first 10 threads

NO.77 Which four are types of information stored in the MySQL data dictionary? (Choose four.)

performance metrics

table definitions

access control lists

view definitions

server runtime configuration

server configuration rollback

stored procedure definitions

InnoDB buffer pool LRU management data

NO.78 You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

installing and configuring the Connection Control plugin

avoiding concatenation of SQL statements and user-supplied values in an application

using stored procedures for any database access

using PREPARED STATEMENTS

NO.79 Examine these statements and output:

Which statement is true?

The user is logged in with –user=accounting as an option.

The user is authenticated as the anonymous proxy user ”@’%’.

The user is authorized as the accounting@localhost user.

The user is authorized as the rsmith@localhost user.

The user failed to define a username and the connecting username defaulted to ”@’%’.

NO.80 You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-

bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

NO.81 A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

You use the MyISAM storage engine for most common tables.

You use the InnoDB storage engine and statements wait while data is inserted.

The Innodb Buffer pool is full.

Your table accesses wait for the operating system level flush.

NO.82 You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

starting and stopping the MySQL instance

tracing import and export with mysqidump

deploying the MySQL agent on supported target operating system

creating e-mail alerts and SNMP traps for MySQL warnings

monitoring the availability of the MySQL instance

analyzing executed MySQL queries

monitoring of NDB Cluster API nodes

NO.83 Which command enables rule-based MySQL Auditing capabilities?

shell> mysql < audit_log_filter_linux_install.sql

shell> mysqld –initialize –log-raw=audit.log

mysql> INSTALL PLUGIN audit_log;

mysql> INSTALL COMPONENT audit_log;

NO.84 Which two MySQL Server accounts are locked by default? (Choose two.)

any user set as DEFINER for stored programs

any internal system accounts

any new ROLE accounts

any user created without a password

any user created with a username, but missing the host name

NO.85 Which three sets of item information are visible in the mysql system database? (Choose three.)

help topics

performance monitoring information

plugins

rollback segments

information about table structures

time zone information and definitions

audit log events

Practice Test for 1Z0-908 Certification Real 2023 Mock Exam [Q70-Q85]

How to book the Oracle 1Z0-908: MySQL 8.0 Database Exam