Oracle 1Z0-908 Real Exam Questions and Answers FREE
Exam Dumps 1Z0-908 Practice Free Latest Oracle Practice Tests
For more info read reference:
Oracle 1Z0-908: MySQL 8.0 Database Administration
NEW QUESTION 16
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)
- A. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
- B. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
- C. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
- D. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
- E. MySQL writes SDI to the binary log for distributed backups.
Answer: A,C
NEW QUESTION 17
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It manages the configuration of user privileges for accessing the server.
- B. It can be used to create and edit SSL certificates and log locations.
- C. It manages the configuration of client programs.
- D. It provides an interface to change my.cnf files.
- E. It can move datadir to a new location.
- F. It will use [client] options by default unless you provide --login-path.
- G. It manages the configuration of the MySQL Firewall feature.
Answer: C,F
NEW QUESTION 18
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 1
- B. QN = 5
- C. QN = 3
- D. QN = 4
- E. QN = 2
Answer: A,E
NEW QUESTION 19
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 20
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is restarted.
Answer: A
NEW QUESTION 21
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases are backed up to the output file.
- B. All non-active binary logs are removed from the master.
- C. All details regarding deleted logs and master metadata are captured in the output file.
- D. All binary logs are deleted from the master.
- E. All databases, excluding master metadata, are backed up to the output file.
- F. All binary logs are backed up and then deleted.
Answer: D,E
NEW QUESTION 22
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 23
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 24
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
- A. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
- B. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
- C. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
- D. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
Answer: C
NEW QUESTION 25
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/.mysql/auth/login file
- B. $HOME/.my.cnf file
- C. $HOME/.mylogin.cnf file
- D. DATADIR/mysqld-auto.cnf file
- E. $HOME/.mysqlrc file
- F. $MYSQL_HOME/my.cnf file
- G. /etc/my.cnf file
Answer: D,F,G
NEW QUESTION 26
Examine the modified output:
Seconds_Behind_ Mastervalue 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
Explanation:
Explanation
NEW QUESTION 27
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 work.
- B. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 28
Which three statements are true about MySQL replication? (Choose three.)
- A. Binary logging must be enabled on the master in order to replicate to other instances.
- B. A replication user must have the SELECT privilege for all tables that need to be replicated.
- C. Any instance can have multiple slaves, but it can have only one master.
- D. Each slave must have its own MySQL user for replication.
- E. Each instance in a replication topology must have a unique server ID.
- F. Replication can use only TCP/IP connections.
- G. Binary logs contain only transactions originating from a single MySQL instance.
Answer: A,B,E
NEW QUESTION 29
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using PREPARED STATEMENTS
- B. avoiding concatenation of SQL statements and user-supplied values in an application
- C. installing and configuring the Connection Control plugin
- D. using stored procedures for any database access
Answer: D
NEW QUESTION 30
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 --check --all-databases command takes table write locks while performing a series of checks.
- C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- D. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - E. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
Answer: D,E
NEW QUESTION 31
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 32
......
How much Oracle 1Z0-908: MySQL 8.0 Database Exam Cost
The price of the Oracle 1Z0-908 Exam is USD 245, for more information related to the Oracle 1Z0-908 Exam please visit Oracle website.
Verified 1Z0-908 Exam Dumps Q&As - Provide 1Z0-908 with Correct Answers: https://www.dumpstests.com/1Z0-908-latest-test-dumps.html
1Z0-908 Exam Questions | Real 1Z0-908 Practice Dumps: https://drive.google.com/open?id=1c77Hh3FKOsndLmYIzVWw2-hQn1Qs2JMN