Online Access Free 1Z1-921 Exam Questions

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• B.Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
• C.Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
• D.Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

You execute this statement:
SELECT NULL=NULL;
What is the result?

• A.0
• B.1
• C.FALSE
• D.TRUE
• E.NULL

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

• A.CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
• B.CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
• C.CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
• D.CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
• E.CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

• A.monitoring the availability of the MySQL Instance
• B.analyzing executed MySQL queries
• C.tracing import and export with mysqldump
• D.creating e-mail alerts and SNMP traps for MySQL warnings
• E.starting and stopping the MySQL instance
• F.deploying MySQL agent on supported target operating system

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

• A.You can connect directly to the VCN without a define subnet.
• B.You must have an IPSec VPN to connect to an Oracle Linux instance.
• C.Your instance does not have a public IP address, so you cannot connect with a public subnet.
• D.You can connect directly to an instance over the internet, without a public IP address.
• E.You must have an Internet gateway to connect to a public address on an Oracle Linux instance.