1Z0-908 by Oracle Actual Free Exam Q&As

Question 1

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. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

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 work. D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs. E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. table data B. change buffer C. user privileges D. doublewrite buffer E. primary indexes F. InnoDB Data Dictionary

Discussion 0

Correct Answer: D,F Vote an answer

Question 4

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The archive tables are backed up first, then the transaction tables and redo logs. B. The redo logs are backed up first, then the transaction and archive tables. C. The redo logs are not backed up at all. D. The transaction tables are backed up first, then the archive tables and redo logs. E. The redo logs are backed up only if there are changes showing for the transactions tables.

Discussion 0

Correct Answer: E Vote an answer

Question 5

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 MAX_USER_CONNECTIONS 0; B. ALTER USER baduser@hostname PASSWORD DISABLED; C. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login; D. ALTER USER baduser@hostname ACCOUNT LOCK; E. ALTER USER baduser@hostname DEFAULT ROLE NONE;

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

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> ALTER TABLE shop.customers DISCARD TABLESPACE B. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi C. shell> cp /backup/customers.sdi /var/lib/mysql/shop/ D. shell> cp /backup/customers.sdi /var/tmp E. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE F. shell> cp /backup/customers.frm /var/lib/mysql/shop/ G. mysql> SOURCE '/var/tmp/customers.sdi' H. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

Discussion 0

Correct Answer: B,E Vote an answer

Question 7

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks. B. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table. C. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default. D. The mysqlcheck --optimize --all-databases command reclaims free space from table files. E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Discussion 0

Correct Answer: C,E Vote an answer

Question 8

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

A. session_variables B. global_variables C. user_variables_by_thread D. variables_by_thread

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

A. EXPLAIN SELECT INDEXES FROM manufacturing.parts; B. DESCRIBE manufacturing.parts; C. SHOW INDEXES FROM manufacturing.parts; D. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts'; E. SELECT * FROM information_schema.COLUMN_STATISTICS;

Discussion 0

Correct Answer: D,E Vote an answer

Oracle MySQL 8.0 Database Administrator - 1Z0-908 Exam Practice Test