1Z0-908問題集でリアル試験問題でテストエンジン問題集でトレーニング [Q36-Q51]

1Z0-908問題集でリアル試験問題でテストエンジン問題集でトレーニング

Oracle 1Z0-908テスト問題集とオンライン試験エンジン

質問 # 36
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

A. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
B. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
C. shell> cp /backup/customers.frm /var/lib/mysql/shop/
D. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
E. shell> cp /backup/customers.sdi /var/tmp
F. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
G. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
H. mysql> SOURCE '/var/tmp/customers.sdi'

正解：A、G

質問 # 37
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
B. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
C. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
D. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

正解：C、D

質問 # 38
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

A. $HOME/.mylogin.cnf file
B. $HOME/.mysql/auth/login file
C. $HOME/.mysqlrc file
D. /etc/my.cnf file
E. DATADIR/mysqld-auto.cnf file
F. $MYSQL_HOME/my.cnf file
G. $HOME/.my.cnf file

正解：D、E、F

質問 # 39
Which two statements are true about MySQL Installer? (Choose two.)

A. It installs most Oracle MySQL products.
B. Manual download of separate product packages is required before installing them through MySQL Installer.
C. It performs product upgrades.
D. It provides only GUI-driven, interactive installations.
E. It provides a uniform installation wizard across multiple platforms.

正解：C、D

質問 # 40
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

A. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
B. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;
C. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;
D. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
E. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
F. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

正解：D、E

質問 # 41
Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

A. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
B. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
C. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql
D. mysqlbinlog --stop-position=500324 binlog.000036 | mysql

正解：C

質問 # 42
Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is a shared lock.
B. The lock is at the table object level.
C. The lock is an intentional lock.
D. The lock is a row-level lock.
E. The lock is an exclusive lock.
F. The lock is at the metadata object level.

正解：B、E

質問 # 43
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

A. QN = 2
B. QN = 1
C. QN = 3
D. QN = 5
E. QN = 4

正解：A、B

質問 # 44
Which three are characteristics of a newly created role? (Choose three.)

A. It can be protected with a password.
B. It is created as a locked account.
C. It can be dropped using the DROP ROLEstatement.
D. It can be renamed using the RENAME ROLEstatement.
E. It is stored in the mysql.roletable.
F. It can be granted to user accounts.

正解：A、C、F

解説：
Explanation/Reference:

質問 # 45
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
The database size is static and including indexes is 19G.
Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

A. innodb_undo_directory=/dev/shm
B. innodb_log_file_size=1G
C. innodb_doublewrite=0
D. buffer_pool_size=24G
E. max_connections=10000
F. innodb_flush_log_at_trx_commit=1
G. sync_binlog=0

正解：B、E、F

質問 # 46
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?

A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
B. Replication will work.
C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
D. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
E. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

正解：A

解説：
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643

質問 # 47
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
C. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

正解：B

質問 # 48
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

A. undo_001
B. ib_logfile0
C. mysql.ibd
D. ib_buffer_pool
E. ibtmp1
F. ibdata1

正解：C、D

質問 # 49
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

A. The slave relay logs should be deleted; then execute START SLAVE;
B. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
C. The slave needs to be restored from backup.
D. The relay logs from the master should be used to replace the corrupted relay logs.

正解：D

質問 # 50
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Re-execute the failed statement in your transaction.
B. Change the default database and re-execute the failed statement in your transaction.
C. Close the connection, reconnect, and start the transaction again.
D. Roll back the transaction and start the transaction again in the same session.

正解：A

質問 # 51
......

Oracle 1Z0-908問題を提供していますMySQL Database Administration問題集と完璧な解答付き：https://jp.fast2test.com/1Z0-908-premium-file.html

信頼され続ける1Z0-908試験のコツとPDF試験材料：https://drive.google.com/open?id=1C9yUZ62Rh4L_Ow7vih1l9J-OnY3tWq1C