[2021] Valid 1Z0-908 test answers & Oracle 1Z0-908 exam pdf

Verified 1Z0-908 dumps Q&As - Pass Guarantee or Full Refund

For more info read reference:

Oracle 1Z0-908: MySQL 8.0 Database Administration

 

NEW QUESTION 51
Which two statements are true about the mysql_config_editor program? (Choose two.)

• A. It can be used to create and edit SSL certificates and log locations.
• B. It manages the configuration of client programs.
• C. It will use [client] options by default unless you provide --login-path.
• D. It manages the configuration of the MySQL Firewall feature.
• E. It can move datadir to a new location.
• F. It manages the configuration of user privileges for accessing the server.
• G. It provides an interface to change my.cnf files.

Answer: B,C

 

NEW QUESTION 52
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

• A. Use resource groups to lock different instances on separate CPUs.
• B. Run mysqldwith --datadirdefined for each instance.
• C. Use systemdwith different settings for each instance.
• D. Use system tools to lock each instance to its own CPU.
• E. Start mysqldor mysqld_safeusing different option files for each instance.
• F. Run MySQL Server docker containers.

Answer: B,C,E

Explanation:
Explanation/Reference:

 

NEW QUESTION 53
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

• A. TCP/IP
• B. named pipes
• C. X Protocol
• D. SOCKET
• E. shared memory
• F. UDP

Answer: A,B,E

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html

 

NEW QUESTION 54
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. sync_binlog=0
• C. buffer_pool_size=24G
• D. max_connections=10000
• E. innodb_flush_log_at_trx_commit=1
• F. innodb_log_file_size=1G
• G. innodb_doublewrite=0

Answer: D,E,F

 

NEW QUESTION 55
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

• A. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
• B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
• C. MySQL Router is restarted.
• D. MySQL Router is configured based on the information in files in directory_path.

Answer: B

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

 

NEW QUESTION 56
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. employee
• B. world
• C. sys
• D. mysql
• E. information_schema

Answer: C,E

 

NEW QUESTION 57
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

• A. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
  (‘[email protected]’, ‘secret’);--‘;
  SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
• B. SELECT email,passwd FROM members
• C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
  (‘[email protected]’,‘secret’);--‘;
• D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
• F. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

Answer: B,E

 

NEW QUESTION 58
Examine this statement and output:

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

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

Answer: B,D

 

NEW QUESTION 59
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

• A. The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
• B. The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).
• C. The cluster is running and there is at least one ONLINEinstance.
• D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
• E. The instance deployed on host3must be rebuilt with a backup from the primary instance.

Answer: B

 

NEW QUESTION 60
Which two statements are true about MySQL server multi-source replication? (Choose two.)

• A. It relies on relay_log_recovery for resilient operations.
• B. It needs to be re-instanced after a crash to maintain consistency.
• C. It does not attempt to detect or resolve replication conflicts.
• D. It is not compatible with auto-positioning.
• E. It uses only time-based replication conflict resolution.
• F. It must use GTID replication.

Answer: E,F

 

NEW QUESTION 61
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 moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be 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 is not necessary because innodb_data_home_dir is already defined.
• E. It allows scanning of other locations to discover more innodb tablespaces.

Answer: D

 

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

• A. ADMIN OPTION allows Mark to drop the role.
• B. Mark must connect from localhost to activate the r_read@localhost role.
• C. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• D. Mark can revoke the r_read@localhost role from another role.
• E. ADMIN OPTION causes the role to be activated by default.
• F. Mark can grant the r_read@localhost role to another user.

Answer: A,C

 

NEW QUESTION 63
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A. table data
• B. primary indexes
• C. user privileges
• D. change buffer
• E. doublewrite buffer
• F. InnoDB Data Dictionary

Answer: E,F

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html

 

NEW QUESTION 64
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. Close the connection, reconnect, and start the transaction again.
• B. Re-execute the failed statement in your transaction.
• C. Roll back the transaction and start the transaction again in the same session.
• D. Change the default database and re-execute the failed statement in your transaction.

Answer: B

 

NEW QUESTION 65
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A. NDB
• B. ARCHIVE
• C. InnoDB
• D. MEMORY
• E. MyISAM

Answer: D,E

Explanation:
Explanation/Reference: https://zetcode.com/mysql/storageengines/

 

NEW QUESTION 66
Which statement is true about InnoDB persistent index statistics?

• A. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
• B. Updating index statistics is an I/O expensive operation.
• C. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
• D. Tables are scanned and index statistics recalculated when an instance is restarted.
• E. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
• F. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Answer: C

 

NEW QUESTION 67
Which two statements are true about using backups of the binary log? (Choose two.)

• A. Multiple binary logs can be used to restore data.
• B. They allow for point-in-time recovery of the data.
• C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• D. Multiple binary logs can be applied in parallel for faster data restoration.
• E. Binary logs can always be used to unapply unwanted schema changes.

Answer: B,E

 

NEW QUESTION 68
Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

• A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
• B. The master is producing a large volume of events in parallel but the slave is processing them serially.
• C. One or more large tables do not have primary keys.
• D. The parallel slave threads are experiencing lock contention.
• E. The master is most probably too busy to transmit data and the slave needs to wait for more data.

Answer: A,B

Explanation:
Explanation

 

NEW QUESTION 69
Which two MySQL Server accounts are locked by default? (Choose two.)

• A. any user created without a password
• B. any new ROLE accounts
• C. any internal system accounts
• D. any user created with a username, but missing the host name
• E. any user set as DEFINER for stored programs

Answer: C,E

 

NEW QUESTION 70
Which three are characteristics of a newly created role? (Choose three.)

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

Answer: A,B,C

Explanation:
Explanation/Reference:

 

NEW QUESTION 71
Which step or set of steps can be used to rotate the error log?

• A. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
• B. Execute SET GLOBAL log_error = '<new error log file>'.
• C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
• D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Answer: D

 

NEW QUESTION 72
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

• A. REQUIRED
• B. VERIFY_IDENTITY
• C. PREFERRED
• D. VERIFY_CA

Answer: A

 

NEW QUESTION 73
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?

• A. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
• B. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
• C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
• D. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

Answer: B

 

NEW QUESTION 74
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

• A. NDB
• B. ARCHIVE
• C. InnoDB
• D. MEMORY
• E. MyISAM

Answer: D,E

 

NEW QUESTION 75
......

1Z0-908 Exam Questions – Valid 1Z0-908 Dumps Pdf: https://www.testsimulate.com/1Z0-908-study-materials.html