Oracle 1Z1-921 Actual Tests : MySQL 2021 Implementation Essentials

Oracle 1Z1-921 Exam Syllabus Topics:

Oracle MySQL 2021 Implementation Essentials Sample Questions:

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

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

2. 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) Execute the sakila-data. sqi script to populate the database
B) Use MySQL Enterprise High Availability to access one of the available data tables
C) Use mysqldump to import data from the sakila_dummy database sample data set.
D) Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

3. Which two statements are correct about MySQL Enterprise Edition?

A) Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).
B) MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.
C) MySQL configuration can be changed in /etc/lib/myi.cnf.
D) Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.
E) MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

4. What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A) Data is encrypted automatically, in real time, after it is written to storage.
B) Enables data-at-rest encryption by encrypting the physical files of the database.
C) Tablespace keys are managed manually behind the scenes.
D) Encryption key is stored in a centralized key memory location

5. What are Security Lists in Oracle Cloud Infrastructure?

A) They are user-role designations that assign rights to certain internal users and external users.
B) They allow administrators access to applications in the cloud and external servers.
C) They contain rules established by HIPAA for securing end-user data.
D) Security lists are data encryption levels that control who can see the data.
E) They are essentially firewall rules that help control traffic between OCI instances.

Solutions: