Free Oracle 1Z0-921 Exam Dumps Questions & Answers

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

• A.  MySQL Enterprise Data Masking and De-identification
• B.  MySQL Enterprise Transparent Data Encryption (TDE)
• C.  MySQL Enterprise No-Login Authentication
• D.  MySQL Enterprise Audit
• E.  MySQL Enterprise Scalability

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

• A.  Use MySQL Enterprise High Availability to access one of the available data tables
• B.  Execute the sakila-data. sqi script to populate the database
• C.  Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
• D.  Use mysqldump to import data from the sakila_dummy database sample data set.

MySQL is installed on a Linux server with the configuration:
Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

• A.  Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• B.  Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• C.  Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
• D.  Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

Which query will find rows in a table that have no counterpart in another table?

• A.  SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
• B.  SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
• C.  SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
• D.  SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A.  Networks must be in separate regions.
• B.  use SSD,s for data and replication logs
• C.  isolated machine resources
• D.  smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM
• E.  Use Network-attached storage (NAS) for the data files.
• F.  The number of machines per group must be 3, 5, 7 or 9.
• G.  Groups must be in even numbers; 2, 4, 6, 8.