2021 Realistic Verified 1Z0-908 exam dumps Q&As - 1Z0-908 Free Update
Use Real 1Z0-908 Dumps - 100% Free 1Z0-908 Exam Dumps
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.
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.
Topics of Oracle 1Z0-908: MySQL 8.0 Database Exam
The Oracle 1Z0-908 exam tests the abilities and knowledge of the candidates by checking the following objectives:
Architecture
- Configure client connections to the server
- Understand how InnoDB stores data and logs
- Understand how MySQL stores data
- Understand and use the Data Dictionary
- Configure buffers and caches
Server Installation and Configuration
- Launch multiple MySQL servers on the same host
- Identify the files and folders created during the installation
- Install and use the MySQL server and client programs
- Configure MySQL variables
- Configure MySQL by using options and option files
- Start and stop MySQL
- Upgrade MySQL
Security
- Create user accounts and roles
- Control user and role permissions
- Prevent SQL injection attacks
- Secure the MySQL host environment
- Provide the password and login security
- Secure MySQL server connections
- Use authentication plug-ins
- Recognize common security risks
- Configure MySQL Enterprise Firewall
- Encrypt MySQL data
Monitoring and Maintenance
- Monitor MySQL processes and status
- Use MySQL Enterprise Monitor to view activity in MySQL
- Configure MySQL Enterprise Audit
- Configure and view MySQL log files
- Troubleshoot problems with locked resources
- Monitor database growth and explain capacity planning
Query Optimization
- Create indexes to improve server performance
- Analyze queries with MySQL Enterprise Monitor
- Examine how MySQL optimizes queries
- Monitor and understand index statistics
Backups and Recovery
- Explain when and how to use raw file backups
- Distinguish between the different types of backup
- Backup and restore data with MySQL Enterprise Backup
- Use mysqldump and mysqlpump to perform logical backups
- Back up the binary log
- Implement a backup strategy
High Availability Techniques
- Explain the role of replication threads
- Perform an InnoDB cluster recovery
- Configure replication
- Describe MySQL InnoDB Cluster and Group Replication
- Configure multisource replication
- Explain the role of the binary log in replication
- Explain how replication provides high availability and scalability
- Configure a MySQL InnoDB cluster
- Monitor and troubleshoot replication
NEW QUESTION 49
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 50
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use systemdwith different settings for each instance.
- B. Start mysqldor mysqld_safeusing different option files for each instance.
- C. Run MySQL Server docker containers.
- D. Use resource groups to lock different instances on separate CPUs.
- E. Use system tools to lock each instance to its own CPU.
- F. Run mysqldwith --datadirdefined for each instance.
Answer: A,B,F
Explanation:
Explanation/Reference:
NEW QUESTION 51
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It returns an error because the mysqldump command should have been used.
- B. It creates a logical backup of all MySQL user accounts.
- C. It creates a logical backup of only the users database.
- D. It creates a logical backup of all metadata, but contains no table data.
Answer: D
NEW QUESTION 52
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 53
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 54
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 55
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 56
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- B. It fails if any of the roles is specified in the mandatory_roles variable.
- C. It fails if at least one of the roles does not exist.
- D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
- E. Existing connections can continue to use the roles' privileges until they reconnect.
- F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
Answer: A,E
NEW QUESTION 57
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. SHOW INDEXES FROM manufacturing.parts;
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- D. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - E. DESCRIBE manufacturing.parts;
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
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/lib/mysql/shop/
- B. shell> cp /backup/customers.sdi /var/tmp
- C. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- D. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- E. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- F. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- G. mysql> SOURCE '/var/tmp/customers.sdi'
- H. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
Answer: C,H
NEW QUESTION 59
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. You must manually initialize the data directory.
- B. The functionality is split among several RPM package files.
- C. MySQL uses the RPM relocatable installation target feature.
- D. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
- E. You can provide the root password interactively.
- F. You can find the root password in the error log after the first start.
Answer: D,F
NEW QUESTION 60
Which three actions are effective in capacity planning? (Choose three.)
- A. buying more RAM
- B. buying more CPU
- C. basing expected growth on an average of the last 3 years
- D. buying more disk
- E. adding circular replication nodes for increased DML capability
- F. monitoring OS resources for patterns
- G. consulting the application team about any future projects and use
- H. upgrading to the latest application version
Answer: C,F,G
NEW QUESTION 61
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- B. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
- C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
- D. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- E. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
Answer: B,C
NEW QUESTION 62
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
NEW QUESTION 63
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 64
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- C. The cluster will shut down to preserve data consistency.
- D. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
- E. A manual intervention to force group members to be only the working two instances is required.
Answer: A,C
NEW QUESTION 65
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 66
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 67
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - B. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - C. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - D. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - E. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - F. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;
Answer: A,D
NEW QUESTION 68
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 69
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 70
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 71
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. stored procedure definitions
- B. table definitions
- C. server runtime configuration
- D. server configuration rollback
- E. access control lists
- F. InnoDB buffer pool LRU management data
- G. performance metrics
- H. view definitions
Answer: A,B,D,H
NEW QUESTION 72
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. Mark can revoke the r_read@localhost role from another role.
- C. Mark must connect from localhost to activate the r_read@localhost role.
- D. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- E. ADMIN OPTION allows Mark to drop the role.
- F. ADMIN OPTION causes the role to be activated by default.
Answer: D,E
NEW QUESTION 73
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command 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-cccccccccccc GTIDs.
- 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-bbbbbbbbbbbb GTIDs in its binary logs.
Answer: C
NEW QUESTION 74
......
Pass 1Z0-908 exam Updated 86 Questions: https://www.braindumpsvce.com/1Z0-908_exam-dumps-torrent.html
1Z0-908 Exam Dumps, Test Engine Practice Test Questions: https://drive.google.com/open?id=1SXWMrizWH687jNyvFMPLOAHiY0ll3I-t