[Aug 30, 2021] 1Z0-908 Dumps Full Questions - Exam Study Guide
MySQL Database Administration Free Certification Exam Material from PremiumVCEDump with 86 Questions
NEW QUESTION 16
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. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
- D. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
Answer: C
NEW QUESTION 17
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. PREFERRED
- B. VERIFY_CA
- C. VERIFY_IDENTITY
- D. REQUIRED
- E. DISABLED
Answer: D
NEW QUESTION 18
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of only the users database.
- B. It creates a logical backup of all MySQL user accounts.
- C. It returns an error because the mysqldump command should have been used.
- D. It creates a logical backup of all metadata, but contains no table data.
Answer: D
NEW QUESTION 19
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;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- - B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- 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-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER;
Answer: D
NEW QUESTION 20
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- B. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- D. Execute SET GLOBAL log_error = '<new error log file>'.
Answer: B
NEW QUESTION 21
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user created with a username, but missing the host name
- B. any user created without a password
- C. any internal system accounts
- D. any new ROLE accounts
- E. any user set as DEFINER for stored programs
Answer: C,E
NEW QUESTION 22
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the public_key.pemfile.
- B. Change the parent directory owner and group to mysql.
- C. Remove world read privileges from the server-cert.pemcertificate file.
- D. Remove group read/write privileges from the private_key.pemfile.
- E. Change the group ownership of the mysqldirectory to the mysqluser group.
- F. Remove the world read/execute privilege from the accountingdirectory.
Answer: B,E
NEW QUESTION 23
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
- A. You use the InnoDB storage engine and statements wait while data is inserted.
- B. You use the MyISAM storage engine for most common tables.
- C. Your table accesses wait for the operating system level flush.
- D. The Innodb Buffer pool is full.
Answer: A
NEW QUESTION 24
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 25
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
- A. Connection 24 experiences a lock wait timeout.
- B. A deadlock occurs after innodb_lock_wait_timeout seconds.
- C. A deadlock occurs immediately.
- D. All statements execute without error.
- E. Connection 25 experiences a lock wait timeout.
Answer: B
NEW QUESTION 26
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
- A. The DBA needs to execute FLUSH PRIVILEGES.
- B. The statement was blocked by MySQL Firewall.
- C. John needs to reconnect to the database.
- D. John has not activated the role.
Answer: D
NEW QUESTION 27
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. InnopB
- B. MEMORY
- C. BLACKHOLE
- D. ARCHIVE
- E. MyISAM
- F. NDB
Answer: C,E,F
NEW QUESTION 28
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 29
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 30
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - B. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';
Answer: B,F
NEW QUESTION 31
......
Dumps Brief Outline Of The 1Z0-908 Exam: https://www.premiumvcedump.com/Oracle/valid-1Z0-908-premium-vce-exam-dumps.html
Use Real 1Z0-908 - 100% Cover Real Exam Questions: https://drive.google.com/open?id=1vq2XOeDDFQXW5gvXrF6FbmHtHzE4mizu