Certification Training for 1Z0-908 Exam Dumps Test Engine [2021]
Aug 16, 2021 Step by Step Guide to Prepare for 1Z0-908 Exam
NEW QUESTION 47
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They are pulled from the master to the slave.
- C. They are pushed from the master to the slave.
- D. They contain events that describe all queries run on the master.
- E. They contain events that describe database changes on the master.
Answer: C,E
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION 48
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It can be protected with a password.
- C. It is stored in the mysql.roletable.
- D. It can be dropped using the DROP ROLEstatement.
- E. It can be granted to user accounts.
- F. It can be renamed using the RENAME ROLEstatement.
Answer: B,D,E
Explanation:
Explanation/Reference:
NEW QUESTION 49
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. InnoDB Data Dictionary
- B. change buffer
- C. table data
- D. primary indexes
- E. doublewrite buffer
- F. user privileges
Answer: A,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
NEW QUESTION 50
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. user_variables_by_thread
- B. global_variables
- C. variables_by_thread
- D. session_variables
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 51
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 52
Examine this query and output:
Which two statements are true? (Choose two.)
- A. 35 rows from the city table are included in the result.
- B. It takes more than 8 milliseconds to sort the rows.
- C. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- D. The query returns exactly 125 rows.
- E. The countrytable is accessed as the first table, and then joined to the city table.
Answer: A,C
NEW QUESTION 53
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 master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will work.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
Answer: D
NEW QUESTION 54
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- B. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - D. SELECT email,passwd FROM members
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
Answer: A,D
NEW QUESTION 55
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. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi
- B. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi
- C. mysql> SOURCE '/var/tmp/customers.sdi'
- D. shell> cp /backup/customers.frm /var/lib/mysql/shop/
- E. shell> cp /backup/customers.sdi /var/lib/mysql/shop/
- F. shell> cp /backup/customers.sdi /var/tmp
- G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE
- H. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE
Answer: A,H
NEW QUESTION 56
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is a row-level lock.
- B. The lock is at the metadata object level.
- C. The lock is an exclusive lock.
- D. The lock is an intentional lock.
- E. The lock is at the table object level.
- F. The lock is a shared lock.
Answer: C,E
NEW QUESTION 57
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?
- A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- B. mysqlpump --include-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: A
NEW QUESTION 58
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 SPATIAL INDEX (Population);
- C. ALTER TABLE world.city ADD INDEX (Name);
- D. ALTER TABLE world.city ADD INDEX (Population);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
Answer: B
NEW QUESTION 59
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysql < audit_log_filter_linux_install.sql
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: A
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION 60
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. The parallel slave threads are experiencing lock contention.
- D. One or more large tables do not have primary keys.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: A,E
Explanation:
Explanation
NEW QUESTION 61
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. automatic locking of user accounts who break your firewall
- B. modifying SQL statement dynamically with substitutions
- C. provides stateless firewall access to TCP/3306
- D. blocking of potential threats by configuring pre-approved whitelists
- E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
Answer: B,D
NEW QUESTION 62
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It supports all indexes transparently.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It decrypts data for use in memory.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION 63
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It is not compatible with auto-positioning.
- B. It relies on relay_log_recovery for resilient operations.
- C. It does not attempt to detect or resolve replication conflicts.
- D. It must use GTID replication.
- E. It uses only time-based replication conflict resolution.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION 64
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 PASSWORD DISABLED;
- B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- E. ALTER USER baduser@hostname ACCOUNT LOCK;
Answer: D,E
NEW QUESTION 65
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. SELECT * FROM information_schema.COLUMN_STATISTICS;
- B. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - C. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- D. DESCRIBE manufacturing.parts;
- E. SHOW INDEXES FROM manufacturing.parts;
Answer: A,B
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION 66
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. dba.checkInstanceConfiguration()
- B. cluster.setPrimaryInstance()
- C. dba.configureInstance()
- D. dba.createCluster()
- E. dba.configureLocalInstance()
- F. cluster.addInstance()
- G. cluster.forceQuorumUsingPartitionOf()
Answer: B,G
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0-16.html
NEW QUESTION 67
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 fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will work.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
Answer: D
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 68
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. InnoDB tablespaces outside the datadir are able to be cloned.
- B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
- C. It is always slower than {recoveryMethod: 'incremental'}.
- D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
- E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- F. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
Answer: B,C,F
NEW QUESTION 69
On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)
- A. Users could overwrite configuration files.
- B. SQL injections could be used to insert bad data into the database.
- C. Data files could be deleted.
- D. MySQL binaries could be damaged, deleted, or altered.
- E. Extra startup time would be required for the MySQL server to reset the privileges.
Answer: C,E
NEW QUESTION 70
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. information_schema
- B. employee
- C. mysql
- D. world
- E. sys
Answer: A,E
NEW QUESTION 71
......
Ultimate Guide to Prepare 1Z0-908 Certification Exam for MySQL Database Administration: https://www.2pass4sure.com/MySQL-Database-Administration/1Z0-908-actual-exam-braindumps.html
MySQL Database Administration 1Z0-908 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1_Za45GYPSuPj5Nea7t1ao-ciDS32palO