100% Guaranteed Results 1z1-908 Unlimited 86 Questions [2021]
1z1-908 Dumps PDF - Want To Pass 1z1-908 Fast
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.
NEW QUESTION 48
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 INDEX (Population);
- B. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- C. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- F. ALTER TABLE world.city ADD INDEX (Name);
Answer: E
NEW QUESTION 49
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. Mark can grant the r_read@localhost role to another user.
- B. ADMIN OPTION causes the role to be activated by default.
- C. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- D. Mark must connect from localhost to activate the r_read@localhost role.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark can revoke the r_read@localhost role from another role.
Answer: C,E
NEW QUESTION 50
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. MEMORY
- C. ARCHIVE
- D. MyISAM
- E. InnoDB
Answer: B,D
NEW QUESTION 51
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The countrytable is accessed as the first table, and then joined to the city table.
- B. The query returns exactly 125 rows.
- C. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- D. It takes more than 8 milliseconds to sort the rows.
- E. 35 rows from the city table are included in the result.
Answer: C,E
NEW QUESTION 52
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 does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- 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 has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 53
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. Change the default database and re-execute the failed statement in your transaction.
- B. Roll back the transaction and start the transaction again in the same session.
- C. Close the connection, reconnect, and start the transaction again.
- D. Re-execute the failed statement in your transaction.
Answer: D
NEW QUESTION 54
You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?
- A. global_variables
- B. user_variables_by_thread
- C. variables_by_thread
- D. session_variables
Answer: D
NEW QUESTION 55
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr/bin
- B. /var/lib/mysql
- C. /usr
- D. /etc/my.cnf
- E. /usr/mysql
Answer: A
NEW QUESTION 56
Which command enables rule-based MySQL Auditing capabilities?
- A. mysql> INSTALL PLUGIN audit_log;
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. shell> mysql < audit_log_filter_linux_install.sql
Answer: D
NEW QUESTION 57
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 moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- C. It defines all innodb tablespace options relative to a starting parent directory.
- D. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: A
NEW QUESTION 58
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. shell> cp /backup/customers.sdi /var/tmp
- B. mysql> SOURCE '/var/tmp/customers.sdi'
- C. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- D. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- E. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- F. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- H. shell> cp /backup/customers.frm /var/lib/mysql/shop/
Answer: D,F
NEW QUESTION 59
You plan to take daily full backups, which include the ndbinfoand sys (internal) databases.
Which command will back up the databases in parallel?
- A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- C. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
Answer: A
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 60
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
- A. operating system memory utilization
- B. network-related information and network characteristics
- C. security-related advisor warnings
- D. MySQL Replication monitoring
- E. MySQL Query Analysis data
- F. CPU utilization
- G. disk usage and disk characteristics including disk advisors warnings
Answer: C,E,G
NEW QUESTION 61
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
- A. You use the MyISAM storage engine for most common tables.
- B. The Innodb Buffer pool is full.
- C. You use the InnoDB storage engine and statements wait while data is inserted.
- D. Your table accesses wait for the operating system level flush.
Answer: C
NEW QUESTION 62
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?
- A. binary log
- B. error log
- C. slow query log
- D. audit log
- E. general query log
Answer: A
NEW QUESTION 63
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 = 2
- E. QN = 4
Answer: A,D
NEW QUESTION 64
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: B
NEW QUESTION 65
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Change the group ownership of the mysql directory to the mysql user group.
- B. Remove world read privileges from the public_key.pem file.
- C. Remove the world read/execute privilege from the accounting directory.
- D. Remove group read/write privileges from the private_key.pem file.
- E. Remove world read privileges from the server-cert.pem certificate file.
- F. Change the parent directory owner and group to mysql.
Answer: A,F
NEW QUESTION 66
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. using PREPARED STATEMENTS
- C. avoiding concatenation of SQL statements and user-supplied values in an application
- D. using stored procedures for any database access
Answer: D
NEW QUESTION 67
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. Use systemd with different settings for each instance.
- C. Start mysqld or mysqld_safe using different option files for each instance.
- D. Run MySQL Server docker containers.
- E. Run mysqld with --datadir defined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: B,C,E
NEW QUESTION 68
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnfparameters to suit your installation.
Examine the output:
What statement is true about the start attempt?
- A. MySQL server was not started due to a problem while executing process 2732.
- B. systemdwaited for 30 seconds before timing out and start up failed.
- C. systemdattempted to start mysqld, found another systemd mysqldprocess running, and shut it down.
- D. MySQL server continued to start up even though another process existed.
- E. systemd found the mysqldservice disabled and failed to start it.
Answer: C
NEW QUESTION 69
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. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
- B. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
- C. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
- D. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
Answer: B
NEW QUESTION 70
Which statement is true about InnoDB persistent index statistics?
- A. Tables are scanned and index statistics recalculated when an instance is restarted.
- B. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- C. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- D. Updating index statistics is an I/O expensive operation.
- E. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
- F. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
Answer: B
NEW QUESTION 71
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)
- A. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- B. ALTER USER baduser@hostname ACCOUNT LOCK;
- C. ALTER USER baduser@hostname PASSWORD DISABLED;
- D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- E. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
Answer: B,D
NEW QUESTION 72
......
Updated Verified 1z1-908 Q&As - Pass Guarantee: https://www.prep4sureguide.com/1z1-908-prep4sure-exam-guide.html
1z1-908 Practice Exam Dumps - 99% Marks In Oracle Exam: https://drive.google.com/open?id=1Qg0uKDouv44Gg9sPd-7Qm-OsQO32VYdy