Oracle Oracle Certifications 1Z0-920 Questions & Answers

• Question 61:

  What three are ways to export and import data in MySQL Workbench?

  A. Result Data Export and Import

  B. Binary Data Export and Import Wizard

  C. SQL Data Export and Import Wizard

  D. Backup Data Export and Import Wizard

  E. Table Data Export and Import Wizard

  F. Data Modeling Import Export Wizard

  Correct Answer: ACE

  6.5.1 Table Data Export and Import Wizard

  6.5.2 SQL Data Export and Import Wizard

  6.5.3 Result Data Export and Import There are three ways to export and import data in MySQL Workbench, each serving a different purpose. https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html

• Question 62:

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

  A. ALTER TABLE city DROP population;

  B. DELETE population FROM city;

  C. ALTER TABLE city DELETE population;

  D. ALTER TABLE city LESS population;

  E. DROP population FROM city;

  Correct Answer: A

• Question 63:

  You just installed MySQL by Using a Package Manager on Linux. Where are the default InnoDB redo log files stored?

  A. /usr/mysql

  B. /var/lib/mysql

  C. /var/lib/mysql/innodb

  D. /usr/bin/logs

  E. /usr/redo

  F. /etc/my.cnf

  Correct Answer: E

  https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html

• Question 64:

  You want to create an encrypted table. So, you enter this command:

  CREATE TABLE 'test_encryption2% (

  'id' int(10) unsigned NOT NULL AUTO_INCREMENT,

  'server_name' varchar(15) NOT NULL,

  PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1

  ENCRYPTION = 'Y1;

  You receive the following error:

  ERROR 1031 (HY000): Table storage engine for `test_encryption2' doesn't have this option Which

  statement correctly explains the reason for this error?

  A. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

  B. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

  C. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

  D. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

  Correct Answer: C

• Question 65:

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

  A. Native Windows services

  B. authentication via Pluggable Authentication Modules (PAMs)

  C. Simple Authentication and Security Layer

  D. SECURID authentication and authorization identity

  E. authentication using SHA-256 password hashing

  F. connections through the local host via the UNIX socket file

  Correct Answer: ABEF

  https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html

• Question 66:

  Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

  A. MySQL Servers with Group Replication to replicate data to all members of the cluster.

  B. MySQL Online Hot Backup to keep data consistent and always ready to be used.

  C. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

  D. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

  E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

  Correct Answer: ACE

  https://www.sqlshack.com/deploy-mysql-innodb-clusters-for-high-availability/

• Question 67:

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

  A. creating e-mail alerts and SNMP traps for MySQL warnings

  B. starting and stopping the MySQL instance

  C. analyzing executed MySQL queries

  D. deploying MySQL agent on supported target operating system

  E. monitoring the availability of the MySQL Instance

  F. tracing import and export with mysqldump

  Correct Answer: ADF

• Question 68:

  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?

  A. misspelling

  B. strict or relaxed masking

  C. random data substitution

  D. whitelisting and substitution

  E. dictionary substitution

  Correct Answer: BCE

  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:

  1.

  Selective Masking - Obscures a particular portion of numbers or strings such as phone numbers, and payment card numbers.

  2.

  Strict or Relaxed Masking - Implement strict or relaxed masking to obfuscate data.

  3.

  Random Data Substitution - Replace real values with random values while maintaining format consistency.

  4.

  Blurring - Add a random variance to existing values such as randomized numeric ranges for salaries.

  5.

  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%2

  0Functions,controlling%20how%20the%20data%20appears.andtext=Random%20Data%20Substitution % 20%2D%20Replace%20real,values% 20while%20maintaining%20format%20consistency.

• Question 69:

  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?

  A. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

  B. Use mysqldump with the - -changesonly option.

  C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

  D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

  E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - compress-level to select the level of compression.

  Correct Answer: BE

• Question 70:

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

  A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

  B. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

  C. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

  D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

  Correct Answer: A