Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-908

Oracle 1z0-908 Exam Practice Questions (P. 5)

  • Full Access (152 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
  1. A
    performance metrics
  2. B
    table definitions
  3. C
    access control lists
  4. D
    view definitions
  5. E
    server runtime configuration
  6. F
    server configuration rollback
  7. G
    stored procedure definitions
  8. H
    InnoDB buffer pool LRU management data

Correct Answer:
BDFG

Question #22
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. A
    Stop all instances except the primary read/write master instance and run the restore.
  2. B
    Remove the @@GLOBAL.gtid_purged statement from the dump file.
  3. C
    Create the backup by using the --set-gtid-purged=OFF option.
  4. D
    Remove the group replication plugin from each instance before restoring.
  5. E
    Remove the @@GLOBAL.gtid_executed statement from the dump file.
  6. F
    Restore using the --set-gtid-purged=OFF option.

Correct Answer:
BC

Question #23
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
  1. A
    MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
  2. B
    Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
  3. C
    Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
  4. D
    TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Correct Answer:
C

Question #24
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. A
    It defines all innodb tablespace options relative to a starting parent directory.
  2. B
    It is not necessary because innodb_data_home_dir is already defined.
  3. C
    It allows scanning of other locations to discover more innodb tablespaces.
  4. D
    It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
  5. E
    It adds more temporary workspace in addition to the innodb_tmpdir location.

Correct Answer:
B

Question #25
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
  1. A
    Use the AES_ENCRYPT() MySQL function on the option file.
  2. B
    Use mysql_secure_installation to encrypt stored login credentials.
  3. C
    Use a text editor to create a new defaults file and encrypt it from Linux prompt.
  4. D
    Use mysql_config_editor to create an encrypted file.

Correct Answer:
D

Previous Questions Next Questions

All Pages