Free 1Z0-920 Exam Questions and Answers | by Exam-Dumps.net (Page: 1)

QUESTION: 1

Which statement adds a column with the largest integer data type?

ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;
ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);
ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

Answer(s): A

QUESTION: 2

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

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

Answer(s): A,D,F

Reveal Solution Next Question

QUESTION: 3

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears.
Which three are MySQL Enterprise Masking and De-identification functions?

misspelling
strict or relaxed masking
random data substitution
whitelisting and substitution
dictionary substitution

Answer(s): B,C,E

Explanation:

Robust Data Masking Functions
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. It features robust masking algorithms including selective masking, blurring, random data substitution and other special techniques for credit card numbers, account numbers and other personally identifiable information, enabling IT departments to maintain structural rules to de-identify values. MySQL Enterprise Masking and De-identification functions include:
· Selective Masking - Obscures a particular portion of numbers or strings such as phone numbers, and payment card numbers.
· Strict or Relaxed Masking - Implement strict or relaxed masking to obfuscate data. · Random Data Substitution - Replace real values with random values while maintaining format consistency.
· Blurring - Add a random variance to existing values such as randomized numeric ranges for salaries.
· Dictionary Substitution - Randomly replace values from task specific dictionaries.
· Blacklisting and Substitution - Replace specifically blacklisted data, but leave non-blacklisted in place.
https://www.mysql.com/products/enterprise/masking.html#:~:text=Robust%20Data%20Masking%20Functions,controlling%20how%20the%20data%20appears.&text=Random%20Data%20Substitution%20%2D%20Replace%20real,values%20while%20maintaining%20format%20consistency.

Reveal Solution Next Question

QUESTION: 4

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing.
Which two options can reduce the backup size and speed up the backup time?

Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
Use mysqldump with the - -changesonly option.
Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 5

Which statement would you use to remove the population column from the city table?

ALTER TABLE city DROP population;
DELETE population FROM city;
ALTER TABLE city DELETE population;
ALTER TABLE city LESS population;
DROP population FROM city;

Answer(s): A

Reveal Solution Next Question

Oracle 1Z0-920 Exam (page: 1)
Oracle MySQL 2019 Implementation Essentials
Updated on: 12-Aug-2025

Access free 1Z0-920 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

Explanation:

QUESTION: 4

QUESTION: 5

Oracle 1Z0-920 Exam (page: 1) Oracle MySQL 2019 Implementation Essentials Updated on: 12-Aug-2025

Access free 1Z0-920 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

Explanation:

QUESTION: 4

QUESTION: 5

Oracle 1Z0-920 Exam (page: 1)
Oracle MySQL 2019 Implementation Essentials
Updated on: 12-Aug-2025