Oracle MySQL 2021 Implementation Essentials 1Z0-921 Prüfungsfragen mit Lösungen:
1. You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?
A) Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
B) There are no maintenance operations planned. You need to do them manually.
C) You can expect an outage of your MySQL OCI instance during the planned time..
D) You need to agree to the maintenance windows. If not, you are not affected by the outage.
2. You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img
You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?
A) 
B) 
C) 
D) 
E) 
3. Which is true about inserting an additional line in a single document stored in MySQL document store?
A) Any new lines can only be inserted at the end of the document.
B) The path specified must be an array position past the end of an array using the JSON_POSITION statement.
C) You specify the new element,s position in the JSON_ARRAY_INSERT statement.
D) You cannot insert a single line, you have to replace the entire document with a new document.
4. Which statement is used to create a new MySQL database?
Response:
A) CREATE SCHEMA
B) CREATE TABLE
C) CREATE DATABASE
D) NEW DATABASE
5. 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) Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
B) Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
C) Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
D) Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
Fragen und Antworten:
| 1. Frage Antwort: C | 2. Frage Antwort: B | 3. Frage Antwort: C | 4. Frage Antwort: C | 5. Frage Antwort: A,B |
833 Kundenbewertungen
