Purchase & study exam preparing with 1Z1-921 pass-king quiz training materials

Oracle 1Z1-921 Exam Overview:

Oracle 1Z1-921 Exam Syllabus Topics:

Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A) To safely purge binary log files, perform these steps:
B) On the Master server, disable binlog by removing the --log-bin option.
C) Execute the purge binary logs statement without argument.
D) Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
E) Delete all binlog files manually on the file system to release storage spaces.

2. Which two deployment architectures could you use for scaling-out database reads?

A) Implementing a three-node, single-primary InnoDB Cluster.
B) Edit the configuration file and increase the value for parallel_read_workers and reboot the server
C) Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
D) Altering the storage engine for all tables to memory to increase performance.
E) Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

3. Which three are levels in which MySQL Enterprise Monitor provides access control?

A) Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
B) Asset visibility: the rights to access data collected from hosts or MySQL instances
C) MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
D) Specific data access: the rights to view specific types of potentially sensitive data
E) MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

4. 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,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
B) CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
C) CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
D) CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
E) CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;

5. Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

A) Simple Authentication and Security Layer
B) authentication via Pluggable Authentication Modules (PAMs)
C) SECURID authentication and authorization identity
D) connections through the local host via the UNIX socket file
E) authentication using SHA-256 password hashing
F) Native Windows services

Solutions: