Question No 1

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

Choose the Choices:

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);

Question No 2

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

Choose the Choices:

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

Question No 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?

Choose the Choices:

misspelling

strict or relaxed masking

random data substitution

whitelisting and substitution

dictionary substitution

Question No 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?

Choose the Choices:

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.

Question No 5

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

Choose the Choices:

ALTER TABLE city DROP population;

DELETE population FROM city;

ALTER TABLE city DELETE population;

ALTER TABLE city LESS population;

DROP population FROM city; Answer: A

Practice Oracle 1Z0-920 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-920 Exam Features

1Z0-920 PDF Dumps