Reliable 1Z0-908 Dumps Questions Available as Web-Based Practice Test Engine
Correct and Up-to-date Oracle 1Z0-908 BrainDumps
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
- Understand and use the Data Dictionary
- Understand how InnoDB stores data and logs
- Configure buffers and caches
- Understand how MySQL stores data
- Configure client connections to the server
Server Installation and Configuration
- Launch multiple MySQL servers on the same host
- Start and stop MySQL
- Install and use the MySQL server and client programs
- Configure MySQL variables
- Identify the files and folders created during the installation
- Configure MySQL by using options and option files
Security
- Prevent SQL injection attacks
- Configure MySQL Enterprise Firewall
- Create user accounts and roles
- Use authentication plug-ins
- Provide the password and login security
- Secure the MySQL host environment
Monitoring and Maintenance
- Use MySQL Enterprise Monitor to view activity in MySQL
- Troubleshoot problems with locked resources
- Configure and view MySQL log files
Query Optimization
- Monitor and understand index statistics
- Examine how MySQL optimizes queries
- Analyze queries with MySQL Enterprise Monitor
- Create indexes to improve server performance
Backups and Recovery
- Implement a backup strategy
- Distinguish between the different types of backup
- Back up the binary log
- Use mysqldump and mysqlpump to perform logical backups
High Availability Techniques
- Describe MySQL InnoDB Cluster and Group Replication
- Explain the role of replication threads
- Configure a MySQL InnoDB cluster
- Perform an InnoDB cluster recovery
- Explain the role of the binary log in replication
- Explain how replication provides high availability and scalability
- Monitor and troubleshoot replication
NEW QUESTION # 75
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
- A. This file is for storing MySQL server_uuid values only.
- B. It is always updated with changes to system variables.
- C. It is read and processed at the end of startup configuration.
- D. It is read and processed at the beginning of startup configuration.
- E. This file is for storing MySQL Server configuration options in ISON format.
- F. This file is for logging purposes only and is never processed.
Answer: B,C
NEW QUESTION # 76
Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?
- A. It prevents the audit log from being removed or rotated.
- B. It prevents the audit plugin from being removed from the running server.
- C. It will force the load of the audit plugin even in case of errors at server start.
- D. It causes the audit log to be created if it does not exist.
Answer: B
NEW QUESTION # 77
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?
- A. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- B. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
- C. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
- D. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
Answer: B
NEW QUESTION # 78
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
- A. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
- B. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection. - C. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
- D. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
- E. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
- F. Configuring SSL group communication also configures SSL distributed recovery.
Answer: A,E
NEW QUESTION # 79
MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?
- A. shell> mysql --print-defaults
- B. shell> mysqladmin --debug
- C. mysql> SHOW GLOBAL VARIABLES;
- D. shell> mysqld --help --verbose
Answer: B
NEW QUESTION # 80
You want to dump all databases with names that start with "db".
Which command will achieve this?
- A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
- B. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
- C. mysqlpump > all_db_backup.sql
- D. mysqlpump --include-databases=db --result-file=all_db_backup.sql
Answer: D
NEW QUESTION # 81
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - B. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - C. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - F. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
Answer: E,F
NEW QUESTION # 82
Which two are characteristics of snapshot-based backups? (Choose two.)
- A. The frozen file system can be cloned to another virtual machine immediately into active service.
- B. A separate physical copy must be made before releasing the snapshot backup.
- C. Snapshot backups can be used only in virtual machines.
- D. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
- E. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
Answer: B,C
NEW QUESTION # 83
Which statement is true about InnoDB persistent index statistics?
- A. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
- B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
- C. Updating index statistics is an I/O expensive operation.
- D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
- E. Tables are scanned and index statistics recalculated when an instance is restarted.
- F. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
Answer: D
NEW QUESTION # 84
You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:
Which option will allow this client to connect to MySQL Server?
- A. [mysqld]
default_authentication_plugin=caching_sha2_password - B. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password'; - C. [mysqld]
default_authentication_plugin=mysql_native_password - D. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password'; - E. [mysqld]
default_authentication_plugin=sha256_password - F. ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';
Answer: D
NEW QUESTION # 85
Examine this snippet from the binary log file named binlog.000036:
The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?
- A. mysqlbinlog --stop-position=500324 binlog.000036 | mysql
- B. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
- C. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql
- D. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql
Answer: C
NEW QUESTION # 86
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
- A. Take a physical backup of the MySQL system.
- B. Use the Clone Plugin to copy the data to another MySQL system.
- C. Take your backup from a slave of the MySQL system.
- D. Take a logical backup of the MySQL system.
Answer: D
NEW QUESTION # 87
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL log_error = '<new error log file>'.
- B. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- C. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- D. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
Answer: B
NEW QUESTION # 88
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 FULLTEXT INDEX (Population);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- D. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- E. ALTER TABLE world.city ADD INDEX (Population);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
Answer: D
NEW QUESTION # 89
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
- A. Take a physical backup of the MySQL system.
- B. Use the Clone Plugin to copy the data to another MySQL system.
- C. Take your backup from a slave of the MySQL system.
- D. Take a logical backup of the MySQL system.
Answer: D
NEW QUESTION # 90
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. *.CSM files
- B. ibbackup files
- C. *.sdi files
- D. ib_logfile* files
- E. *.ibd files
Answer: D,E
NEW QUESTION # 91
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
- A. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
- B. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
- C. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.
- D. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
- E. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
Answer: A,E
NEW QUESTION # 92
You plan to take daily full backups, which include the ndbinfoand sys (internal) databases.
Which command will back up the databases in parallel?
- A. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- B. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
Answer: B
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION # 93
......
100% Reliable Microsoft 1Z0-908 Exam Dumps Test Pdf Exam Material: https://www.torrentvce.com/1Z0-908-valid-vce-collection.html