[Jun-2023] Pass 1z1-908 Exam in First Attempt Updated 1z1-908 Exam Questions
MySQL Database Administration Dumps 1z1-908 Exam for Full Questions - Exam Study Guide
To prepare for the Oracle 1Z0-908 exam, candidates can take advantage of a variety of resources, including study guides, online courses, and practice exams. Oracle offers a wide range of training and certification resources for MySQL database administrators, including instructor-led training, online courses, and self-study materials.
The Oracle 1Z0-908: MySQL 8.0 Database Administrator exam is designed to test the knowledge and skills of professionals who work with MySQL databases. This exam is part of the Oracle Certified Professional, MySQL 8.0 Database Administrator certification program, which is recognized globally as a reputable and rigorous certification for database administrators.
NEW QUESTION # 55
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 SPATIAL INDEX (Population);
- B. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Name);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- F. ALTER TABLE world.city ADD INDEX (Population);
Answer: A
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
NEW QUESTION # 56
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. doublewrite buffer
- B. table data
- C. InnoDB Data Dictionary
- D. primary indexes
- E. user privileges
- F. change buffer
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION # 57
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. It enforces consistent backups for all storage engines.
- B. The backup created is a consistent data dump.
- C. It is a cold backup.
- D. This option uses the READ COMMITTED transaction isolation mode.
- E. It executes flush tables with read lock.
Answer: D,E
NEW QUESTION # 58
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 --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
- C. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
- D. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
Answer: B
NEW QUESTION # 59
Which statement is true about cold backups?
- A. They are good to use if only data structures must be backed up but not log files.
- B. They are backups taken from snapshots of a running database.
- C. They are backups taken from OS copy commands.
- D. They are good to use when many users are online accessing the database.
Answer: B
NEW QUESTION # 60
Which two are characteristics of snapshot-based backups? (Choose two.)
- A. A separate physical copy must be made before releasing the snapshot backup.
- B. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
- C. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
- D. The frozen file system can be cloned to another virtual machine immediately into active service.
- E. Snapshot backups can be used only in virtual machines.
Answer: A,E
NEW QUESTION # 61
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
- A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- B. Use SET PERSIST binlog_expire_logs_seconds=<value>.
- C. Use PURGE BINARY LOGS to <binlog_name>.
- D. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- E. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- F. Set binlog_expire_logs_seconds in my.cnf.
Answer: A,B
NEW QUESTION # 62
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 # 63
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. innodb_log_file_size=1G
- D. innodb_doublewrite=0
- E. max_connections=10000
- F. innodb_flush_log_at_trx_commit=1
- G. buffer_pool_size=24G
Answer: C,E,F
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 # 64
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. You can scale writes by creating a replicated mesh.
- B. You can scale reads by adding multiple slaves.
- C. It allows backup to be done on the slave without impacting the master.
- D. MySQL Enterprise Backup will automatically back up from an available slave.
- E. It guarantees near real-time replication between a master and a slave.
Answer: B,C
NEW QUESTION # 65
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 allows scanning of other locations to discover more innodb tablespaces.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: A
NEW QUESTION # 66
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 privileges assigned to the r_read@localhost role to another user.
- B. Mark can grant the r_read@localhost role to another user.
- C. Mark must connect from localhost to activate the r_read@localhost role.
- D. ADMIN OPTION causes the role to be activated by default.
- E. ADMIN OPTION allows Mark to drop the role.
- F. Mark can revoke the r_read@localhost role from another role.
Answer: B,F
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/grant.html
NEW QUESTION # 67
Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)
- A. SHOW ENGINE INNODB STATUS;
- B. INFORMATION_SCHEMA.STATISTICS
- C. SHOW TABLE STATUS;
- D. INFORMATION_SCHEMA.INNODB_METRICS
- E. INFORMATION_SCHEMA.INNODB_TABLESTATS
- F. SHOW STATUS;
Answer: B,E
NEW QUESTION # 68
Examine this command and output:
Which statement is true?
- A. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
- B. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
- C. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
- D. Firewall_access_granted is the number of connections granted from whitelisted hosts.
Answer: A
NEW QUESTION # 69
Which step or set of steps can be used to rotate the error log?
- A. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- B. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- C. Execute SET GLOBAL log_error = '<new error log file>'.
- D. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
Answer: A
NEW QUESTION # 70
Which three sets of item information are visible in the mysql system database? (Choose three.)
- A. plugins
- B. performance monitoring information
- C. information about table structures
- D. time zone information and definitions
- E. rollback segments
- F. help topics
- G. audit log events
Answer: A,E,F
NEW QUESTION # 71
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. Take your backup from a slave of the MySQL system.
- C. Take a logical backup of the MySQL system.
- D. Use the Clone Plugin to copy the data to another MySQL system.
Answer: C
NEW QUESTION # 72
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
- A. MEMORY
- B. BLACKHOLE
- C. ARCHIVE
- D. MyISAM
- E. InnopB
- F. NDB
Answer: B,D,F
NEW QUESTION # 73
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. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
- B. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
- C. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
Answer: B
NEW QUESTION # 74
Which two methods allow a DBA to reset a user's password? (Choose two.)
- A. ALTER USER statement
- B. mysql_secure_installation utility
- C. mysqladmin client program
- D. GRANT statement
- E. SET PASSWORD statement
Answer: A,E
NEW QUESTION # 75
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 # 76
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
- A. ibtmp1
- B. undo_001
- C. ibdata1
- D. ib_buffer_pool
- E. ib_logfile0
- F. mysql.ibd
Answer: D,F
NEW QUESTION # 77
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. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- C. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- D. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
- E. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- F. shell> cp /backup/customers.sdi /var/tmp
- G. mysql> SOURCE '/var/tmp/customers.sdi'
- H. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
Answer: D,E
NEW QUESTION # 78
Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?
- A. It causes the audit log to be created if it does not exist.
- B. It prevents the audit log from being removed or rotated.
- C. It prevents the audit plugin from being removed from the running server.
- D. It will force the load of the audit plugin even in case of errors at server start.
Answer: C
NEW QUESTION # 79
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 has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- 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-bbbbbbbbbbbbGTIDs in its binary logs.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION # 80
......
Authentic Best resources for 1z1-908 Online Practice Exam: https://www.examcollectionpass.com/Oracle/1z1-908-practice-exam-dumps.html