You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?
A. installing and configuring the Connection Control plugin
B. avoiding concatenation of SQL statements and user-supplied values in an application
C. using stored procedures for any database access
D. using PREPARED STATEMENTS
Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)
A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
C. Logical upgrades are much faster because they do not require restarting the mysqld process.
D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
E. Physical upgrades are much faster because they do not require restarting the mysqld process.
F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.
You plan to install MySQL Server by using the RPM download. Which two statements are true? (Choose two.)
A. You can provide the root password interactively.
B. You must manually initialize the data directory.
C. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
D. MySQL uses the RPM relocatable installation target feature.
E. The functionality is split among several RPM package files.
F. You can find the root password in the error log after the first start.
You issue this command:
SHOW SLAVE STATUS In the output, there is a value for Seconds_behind_master.
How is this time calculated?
A. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.
B. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.
C. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.
D. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.
Which statement is true about InnoDB persistent index statistics?
A. Updating index statistics is an I/O expensive operation.
B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
F. Tables are scanned and index statistics recalculated when an instance is restarted.
Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)
A. It fails if any of the roles is specified in the mandatory_roles variable.
B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
C. Existing connections can continue to use the roles' privileges until they reconnect.
D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
F. It fails if at least one of the roles does not exist.
You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)
A. They take roughly twice as long as logical backups.
B. They allow direct copying of table rows with operating system copy commands.
C. They work best for transaction storage engines that can perform their own recovery when restored.
D. The backup window is almost zero from the perspective of the application.
E. They do not back up views, stored procedures, or configuration files.
F. There is a slight performance cost while the snapshot is active.
G. They do not use additional disk space.
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. REQUIRED
B. VERIFY_CA
C. VERIFY_IDENTITY
D. PREFERRED
E. DISABLED
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
A. This file is for storing MySQL Server configuration options in ISON format.
B. This file is for logging purposes only and is never processed.
C. It is read and processed at the beginning of startup configuration.
D. It is read and processed at the end of startup configuration.
E. It is always updated with changes to system variables.
F. This file is for storing MySQL server_uuid values only.
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
A. /usr/mysql
B. /usr/bin
C. /etc/my.cnf
D. /var/lib/mysql
E. /usr
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-908 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.