VCEdump

1Z0-920 MySQL 2019 Implementation Essentials

PDF question preview Back to product

Reading controls

Reader tools

Free demo

11 of 70 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice6

Multiple choice5

Oracle · 1Z0-920

Free 1Z0-920 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

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;

Reveal answer details Close answer details

Correct answerA

Question 2

Multiple choice

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.

Reveal answer details Close answer details

Correct answersB, D, E

Question 3

Single choice

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired?

Which command should you use?

A
CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY `SecretPass123!';
B
CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;
C
CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE
D
CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')
E
CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)

Reveal answer details Close answer details

Correct answerE

Question 4

Single choice

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.

Which statement is correct?

A
The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
B
MySQL Enterprise Monitor creates the required users automatically.
C
The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.
D
Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

Reveal answer details Close answer details

Correct answerC

Question 5

Multiple choice

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A
MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
B
MySQL Enterprise Backup will back up from Slave automatically.
C
It provides multi-master access where the application can write and read data across the database servers.
D
It allows backup to be done on the slave without impacting the master.
E
You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

Reveal answer details Close answer details

Correct answersB, D, E

Question 6

Multiple choice

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.

Which two options should you include in the MySQL configuration file?

A
audit_log_permanent=ON
B
audit-log=FORCE_PLUS_PERMANENT
C
plugin-load=audit_log.so
D
plugin-audit=ON, ALWAYS
E
LOAD PLUGIN=AUDIT_LOG

Reveal answer details Close answer details

Correct answersA, B

Question 7

Single choice

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

Reveal answer details Close answer details

Correct answerA

Question 8

Multiple choice

You need to change the password level for a test system.

Which two allow to change this level before you create new test user/passwords?

A
Add validate_password='new level' in the [security] section of the MySQL configuration file.
B
SET GLOBAL validate_password_policy='new level';
C
SET GLOBAL force_password_complex_policy=0;
D
Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.

Reveal answer details Close answer details

Correct answersB, D

Question 9

Multiple choice

Which two statements are true about MySQL Enterprise Authentication?

A
MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
B
MySQL Enterprise Authentication determines what operation the user can perform.
C
MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
D
MySQL Enterprise Authentication supports Windows Active Directory.
E
MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

Reveal answer details Close answer details

Correct answersC, D

Question 10

Single choice

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH)
For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you "
Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.

What are the correct steps to accomplish this?

A
Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.
B
Use the provided private key for authentication.
C
Convert the private key to ppk format first and use the new private key for authentication.
D
Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

Reveal answer details Close answer details

Correct answerA

Question 11

Single choice

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

Reveal answer details Close answer details

Correct answerC

Explanation

https://www.mysql.com/products/enterprise/

VOL	TYPE	QUESTIONS
1	Single choice	6
2	Multiple choice	5

Free 1Z0-920 Exam Dumps Preview

MySQL 2019 Implementation Essentials

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11