Updated Nov-2021 Exam Engine or PDF for the 1z1-908 Tests Free Updated Today!
Ultimate Guide to Prepare 1z1-908 with Accurate PDF Questions
NEW QUESTION 51
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be protected with a password.
- B. It can be dropped using the DROP ROLEstatement.
- C. It can be granted to user accounts.
- D. It is created as a locked account.
- E. It can be renamed using the RENAME ROLEstatement.
- F. It is stored in the mysql.roletable.
Answer: A,B,C
Explanation:
Explanation/Reference:
NEW QUESTION 52
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. *.ibd files
- C. *.sdi files
- D. *.CSM files
- E. ib_logfile* files
Answer: B,E
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 defines all innodb tablespace options relative to a starting parent directory.
- B. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It is not necessary because innodb_data_home_diris already defined.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: D
NEW QUESTION 54
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 databases, excluding master metadata, are backed up to the output file.
- C. All binary logs are deleted from the master.
- D. All details regarding deleted logs and master metadata are captured in the output file.
- E. All non-active binary logs are removed from the master.
- F. All binary logs are backed up and then deleted.
Answer: B,C
NEW QUESTION 55
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?
- A. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
- B. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
- C. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
- D. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
Answer: B
NEW QUESTION 56
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 57
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
- B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
- C. It fails if at least one of the roles does not exist.
- D. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- E. It fails if any of the roles is specified in the mandatory_roles variable.
- F. Existing connections can continue to use the roles' privileges until they reconnect.
Answer: D,F
NEW QUESTION 58
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. buffer_pool_size=24G
- D. max_connections=10000
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_log_file_size=1G
- G. innodb_doublewrite=0
Answer: D,E,F
NEW QUESTION 59
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 (Name);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Population);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
Answer: F
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
NEW QUESTION 60
Which two statements are true about using backups of the binary log? (Choose two.)
- A. Multiple binary logs can be used to restore data.
- B. They allow for point-in-time recovery of the data.
- C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
- D. Multiple binary logs can be applied in parallel for faster data restoration.
- E. Binary logs can always be used to unapply unwanted schema changes.
Answer: B,E
NEW QUESTION 61
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)
- A. Stop all instances except the primary read/write master instance and run the restore.
- B. Remove the group replication plugin from each instance before restoring.
- C. Restore using the --set-gtid-purged=OFF option.
- D. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- F. Create the backup by using the --set-gtid-purged=OFF option.
Answer: E,F
NEW QUESTION 62
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 2
- C. QN = 5
- D. QN = 1
- E. QN = 3
Answer: B,D
NEW QUESTION 63
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - C. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-
Answer: D
NEW QUESTION 64
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 fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- C. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- D. Replication will work.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
Answer: A
NEW QUESTION 65
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. Close the connection, reconnect, and start the transaction again.
- B. Re-execute the failed statement in your transaction.
- C. Roll back the transaction and start the transaction again in the same session.
- D. Change the default database and re-execute the failed statement in your transaction.
Answer: B
NEW QUESTION 66
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. DESCRIBE manufacturing.parts;
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - D. SHOW INDEXES FROM manufacturing.parts;
- E. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION 67
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 PASSWORD DISABLED;
- C. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- D. ALTER USER baduser@hostname ACCOUNT LOCK;
- E. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
Answer: D,E
NEW QUESTION 68
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. table data
- B. primary indexes
- C. user privileges
- D. change buffer
- E. doublewrite buffer
- F. InnoDB Data Dictionary
Answer: E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION 69
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be renamed using the RENAME ROLE statement.
- B. It can be dropped using the DROP ROLE statement.
- C. It can be protected with a password.
- D. It is stored in the mysql.role table.
- E. It can be granted to user accounts.
- F. It is created as a locked account.
Answer: B,C,E
NEW QUESTION 70
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
- A. Executing ALTER TABLE transactions will enable you to free up disk space.
- B. Truncating the sales and leads table will free up disk space.
- C. The transactions table was created with innodb_file_per_table=OFF.
- D. Truncating the transactions table will free up the most disk space.
- E. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
Answer: C,E
NEW QUESTION 71
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Change the parent directory owner and group to mysql.
- B. Remove world read privileges from the server-cert.pem certificate file.
- C. Change the group ownership of the mysql directory to the mysql user group.
- D. Remove world read privileges from the public_key.pem file.
- E. Remove group read/write privileges from the private_key.pem file.
- F. Remove the world read/execute privilege from the accounting directory.
Answer: A,C
NEW QUESTION 72
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It can be used to create and edit SSL certificates and log locations.
- B. It manages the configuration of client programs.
- C. It will use [client] options by default unless you provide --login-path.
- D. It manages the configuration of the MySQL Firewall feature.
- E. It can move datadir to a new location.
- F. It manages the configuration of user privileges for accessing the server.
- G. It provides an interface to change my.cnf files.
Answer: B,C
NEW QUESTION 73
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)
- A. /etc/my.cnf file
- B. $HOME/.mysql/auth/login file
- C. $HOME/.my.cnf file
- D. $HOME/.mysqlrc file
- E. DATADIR/mysqld-auto.cnf file
- F. $HOME/.mylogin.cnf file
- G. $MYSQL_HOME/my.cnf file
Answer: A,E,G
NEW QUESTION 74
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. NDB
- B. InnopB
- C. ARCHIVE
- D. MEMORY
- E. BLACKHOLE
- F. MyISAM
Answer: A,E,F
NEW QUESTION 75
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. employee
- B. world
- C. sys
- D. mysql
- E. information_schema
Answer: C,E
NEW QUESTION 76
......
Difficulty in Writing of Oracle 1Z0-908: MySQL 8.0 Database Exam
Oracle Certified Expert, Oracle 1Z0-908: MySQL 8.0 Database Administrator Certification is not the most difficult Oracle certification test but taking it without any preparation is likely to fail. Therefore, it is highly recommended that candidates should prepare well by taking 1Z0-908 practice exams. Any questions that are left unanswered will be treated as incorrect therefore you should answer all the questions after the examination of 1Z0-908 dumps.
Pass Oracle With PracticeTorrent Exam Dumps: https://www.practicetorrent.com/1z1-908-practice-exam-torrent.html
Fully Updated 1z1-908 Dumps - 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=14K6ZyeVrkF70K_m4Eq07F_rP90Cg3JYz