Leads4pass > Oracle > Oracle Database > 1Z0-920 > 1Z0-920 Online Practice Questions and Answers

1Z0-920 Online Practice Questions and Answers

Questions 4

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

Buy Now
Questions 5

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

Buy Now
Questions 6

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

Buy Now
Questions 7

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.

Buy Now
Questions 8

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Data is encrypted automatically, in real time, after it is written to storage.

B. Enables data-at-rest encryption by encrypting the physical files of the database.

C. Encryption key is stored in a centralized key memory location

D. Tablespace keys are managed manually behind the scenes.

Buy Now
Questions 9

Which is true about inserting an additional line in a single document stored in MySQL document store?

A. You specify the new element's position in the JSON_ARRAY_INSERT statement.

B. Any new lines can only be inserted at the end of the document.

C. You cannot insert a single line, you have to replace the entire document with a new document.

D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.

Buy Now
Questions 10

You have created your Compute instance using an Oracle-provided Oracle Linux image. You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

A. Public IP address

B. User Password

C. SSH private key

D. The opc user

E. SSH public key

F. The root user

Buy Now
Questions 11

Which Oracle product is certified to work with MySQL Enterprise Edition?

A. Oracle Enterprise Backup

B. Oracle Data Pump

C. Oracle Enterprise Manager

D. Oracle Application Express

Buy Now
Questions 12

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore. What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

A. MySQL Enterprise Backup does not back up system data so that it is much faster.

B. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

C. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

Buy Now
Questions 13

Which three statements are true about MySQL Enterprise Backup?

A. It performs hot or warm backups.

B. It provides the ability to create incremental backups.

C. It cannot back up encrypted tablespaces.

D. It enables you to take non-locking backups.

E. It performs logical backups.

Buy Now
Exam Code: 1Z0-920
Exam Name: MySQL 2019 Implementation Essentials
Last Update: Nov 14, 2024
Questions: 70
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99