Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-908

Free Oracle 1z0-908 Exam Questions (page: 16)

Page 7 of 36
PDF with 228 Questions

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

  1. performance metrics
  2. table definitions
  3. access control lists
  4. view definitions
  5. server runtime configuration
  6. server configuration rollback
  7. stored procedure definitions
  8. InnoDB buffer pool LRU management data

Answer(s): B,D,F,G



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.)

  1. Stop all instances except the primary read/write master instance and run the restore.
  2. Remove the @@GLOBAL.gtid_purged statement from the dump file.
  3. Create the backup by using the --set-gtid-purged=OFF option.
  4. Remove the group replication plugin from each instance before restoring.
  5. Remove the @@GLOBAL.gtid_executed statement from the dump file.
  6. Restore using the --set-gtid-purged=OFF option.

Answer(s): B,C


Reference:

https://scriptingmysql.wordpress.com/2013/07/18/mysql-creating-and-restoring- database-backups- with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/



Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

  1. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
  2. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
  3. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
  4. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Answer(s): C


Reference:

https://www.mysql.com/products/enterprise/tde.html



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?

  1. It defines all innodb tablespace options relative to a starting parent directory.
  2. It is not necessary because innodb_data_home_dir is already defined.
  3. It allows scanning of other locations to discover more innodb tablespaces.
  4. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
  5. It adds more temporary workspace in addition to the innodb_tmpdir location.

Answer(s): C

Explanation:

https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html



Viewing page 16 of 36



Post your Comments and Discuss Oracle 1z0-908 exam prep with other Community members:

1z0-908 Exam Discussions & Posts