Latest 1z1-908 Pass Guaranteed Exam Dumps with Accurate & Updated Questions
1z1-908 Exam Brain Dumps - Study Notes and Theory
NEW QUESTION 12
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
- B. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- C. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- D. Execute SET GLOBAL log_error = ‘<new error log file>’.
Answer: C
Explanation:
Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/
NEW QUESTION 13
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They are pulled from the master to the slave.
- C. They contain events that describe database changes on the master.
- D. They contain events that describe all queries run on the master.
- E. They are pushed from the master to the slave.
Answer: C,E
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION 14
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
- A. BLACKHOLE
- B. MEMORY
- C. ARCHIVE
- D. InnopB
- E. NDB
- F. MyISAM
Answer: A,E,F
NEW QUESTION 15
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. VERIFY_CA
- B. PREFERRED
- C. VERIFY_IDENTITY
- D. DISABLED
- E. REQUIRED
Answer: E
NEW QUESTION 16
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
- A. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
- B. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
- C. It reconfigures InnoDB Cluster if the cluster was stopped.
- D. It only starts all InnoDB Cluster instances.
- E. It is not mandatory that all instances are running and reachable before running the command.
- F. It performs InnoDB Cluster instances rolling restart.
- G. It only stops and restarts all InnoDB Cluster instances.
Answer: E,F
NEW QUESTION 17
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_log_file_size=1G
- B. innodb_flush_log_at_trx_commit=1
- C. sync_binlog=0
- D. innodb_undo_directory=/dev/shm
- E. max_connections=10000
- F. buffer_pool_size=24G
- G. innodb_doublewrite=0
Answer: A,B,E
Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION 18
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. IPv6
- B. SOCKET
- C. TCP
- D. MEMORY
- E. DIRECT
- F. PIPE
- G. IPv4
- H. FILE
Answer: B,C,D,F
NEW QUESTION 19
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. information_schema
- B. mysql
- C. employee
- D. world
- E. sys
Answer: A,E
NEW QUESTION 20
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. variables_by_thread
- B. global_variables
- C. session_variables
- D. user_variables_by_thread
Answer: C
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 21
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. ibbackup files
- B. *.sdi files
- C. *.ibd files
- D. ib_logfile* files
- E. *.CSM files
Answer: C,D
NEW QUESTION 22
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- B. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- C. One or more large tables do not have primary keys.
- D. The parallel slave threads are experiencing lock contention.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: B,E
NEW QUESTION 23
Examine this query:
What information does this query provide?
- A. total memory used by thread number 10
- B. total memory used across all connections associated with the user on connection number 10
- C. total memory used by connection number 10
- D. total memory used across all connections associated with the user on thread number 10
- E. total memory used by the first 10 connections
- F. total memory used by the first 10 threads
Answer: C
NEW QUESTION 24
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?
- A. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
- B. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
- C. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
- D. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
Answer: A
NEW QUESTION 25
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
- A. Connection 25 experiences a lock wait timeout.
- B. A deadlock occurs after innodb_lock_wait_timeout seconds.
- C. Connection 24 experiences a lock wait timeout.
- D. All statements execute without error.
- E. A deadlock occurs immediately.
Answer: B
NEW QUESTION 26
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Start mysqld or mysqld_safe using different option files for each instance.
- B. Run MySQL Server docker containers.
- C. Use systemd with different settings for each instance.
- D. Use resource groups to lock different instances on separate CPUs.
- E. Run mysqld with --datadir defined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: A,C,E
NEW QUESTION 27
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:
What statement is true about the start attempt?
- A. MySQL server continued to start up even though another process existed.
- B. systemd waited for 30 seconds before timing out and start up failed.
- C. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
- D. systemd found the mysqld service disabled and failed to start it.
- E. MySQL server was not started due to a problem while executing process 2732.
Answer: C
NEW QUESTION 28
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- D. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- F. ALTER TABLE world.city ADD INDEX (Population);
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
NEW QUESTION 29
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
- A. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
- B. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
- C. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
- D. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
Answer: D
NEW QUESTION 30
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user created without a password
- B. any internal system accounts
- C. any new ROLE accounts
- D. any user created with a username, but missing the host name
- E. any user set as DEFINER for stored programs
Answer: B,E
NEW QUESTION 31
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
Answer: D
NEW QUESTION 32
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. UDP
- B. X Protocol
- C. shared memory
- D. SOCKET
- E. named pipes
- F. TCP/IP
Answer: C,E,F
NEW QUESTION 33
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?
- A. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - B. 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;
- C. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300; - D. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - E. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
Answer: A
NEW QUESTION 34
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?
- A. It is not necessary because innodb_data_home_dir is already defined.
- B. It defines all innodb tablespace options relative to a starting parent directory.
- C. It adds more temporary workspace in addition to the innodb_tmpdir location.
- D. It allows scanning of other locations to discover more innodb tablespaces.
- E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
Answer: A
NEW QUESTION 35
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)
- A. Create the backup by using the --set-gtid-purged=OFF option.
- B. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- C. Stop all instances except the primary read/write master instance and run the restore.
- D. Remove the group replication plugin from each instance before restoring.
- E. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- F. Restore using the --set-gtid-purged=OFF option.
Answer: A,B
NEW QUESTION 36
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?
- A. It is not necessary because innodb_data_home_diris already defined.
- B. It defines all innodb tablespace options relative to a starting parent directory.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It allows scanning of other locations to discover more innodb tablespaces.
- E. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
Answer: A
NEW QUESTION 37
......
How to book the Oracle 1Z0-908: MySQL 8.0 Database Exam
If you are looking to appear in the Oracle 1Z0-908: MySQL 8.0 Database Exam, you can do so by either redeeming a voucher that you must buy from Oracle or paying directly with a credit card. After payment, you can schedule the test via Oracle’s external testing provider, PearsonVue.
Pass Oracle 1z1-908 Test Practice Test Questions Exam Dumps: https://www.dumpstorrent.com/1z1-908-exam-dumps-torrent.html
The Best MySQL Database Administration Study Guide for the 1z1-908 Exam: https://drive.google.com/open?id=1oNvnBb-F_PCiAacwtDoEEXk5mhiOlrZ6