Skip to main content

1Z0-920 Real Exam Questions

MySQL 2019 Implementation Essentials

70 questions available · Page 1 of 7

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

The slave connects to the master and asks for updated records.

What command was issued for this to happen?

  1. A

    SLAVE RUN

  2. B

    SLAVE START

  3. C

    START RUN SLAVE

  4. D

    RUN SLAVE

  5. E

    START SLAVE

Show answer and explanation

Correct answer: B

Question 2 Single choice

Which is a correct example of creating an Enterprise Encryption function?

  1. A

    SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);

  2. B

    CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openss1_udf.so';

  3. C

    INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));

  4. D

    VALIDATE FUNCTION create_asymmetric_priv_key WITH 'openssl_udf.so';

Show answer and explanation

Correct answer: B

Question 3 Multiple choice

Which two statements are correct about MySQL Enterprise Edition?

  1. A

    MySQL configuration can be changed in /etc/lib/myi.cnf.

  2. B

    MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

  3. C

    Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/
    II).

  4. D

    MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

  5. E

    Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

Show answer and explanation

Correct answers: A, C

Question 4 Single choice

How would you restrict a user Joe from accessing all MySQL database objects?

  1. A

    CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

  2. B

    REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

  3. C

    UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

  4. D

    Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

  5. E

    CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

Show answer and explanation

Correct answer: D

Question 5 Single choice

You just installed MySQL by Using a Package Manager on Linux.

Where are the default InnoDB redo log files stored?

  1. A

    /usr/mysql

  2. B

    /var/lib/mysql

  3. C

    /var/lib/mysql/innodb

  4. D

    /usr/bin/logs

  5. E

    /usr/redo

  6. F

    /etc/my.cnf

Show answer and explanation

Correct answer: E

Explanation

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

Question 6 Multiple choice

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.

Which two options should you add to the mysqlbackup to achieve the restoration of the database?

  1. A

    --uncompress-and-apply-log

  2. B

    --apply-log-and-copy-back

  3. C

    --copy-back-and-apply-log

  4. D

    --uncompress

  5. E

    --decompress

Show answer and explanation

Correct answers: C, D

Question 7 Single choice

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

  1. A

    MySQL Enterprise Monitor and MySQL Audit

  2. B

    MySQL Workbench and MySQL Enterprise Firewall

  3. C

    MySQL Audit and MySQL Workbench

  4. D

    SQL Enterprise Monitor and MySQL Enterprise Authentication

Show answer and explanation

Correct answer: D

Question 8 Multiple choice

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

  1. A

    The number of machines per group must be 3, 5, 7 or 9.

  2. B

    use SSD's for data and replication logs

  3. C

    Groups must be in even numbers; 2, 4, 6, 8.

  4. D

    isolated machine resources

  5. E

    Use Network-attached storage (NAS) for the data files.

  6. F

    smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM

  7. G

    Networks must be in separate regions.

Show answer and explanation

Correct answers: A, C, E

Question 9 Multiple choice

Which two statements about the download of MySQL Enterprise Backup are correct?

  1. A

    MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

  2. B

    MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

  3. C

    MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

  4. D

    MySQL Enterprise Backup comes with all MySQL editions including community edition.

  5. E

    MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

Show answer and explanation

Correct answers: C, D

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

  1. A

    CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY `SecretPass123!';

  2. B

    CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;

  3. C

    CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE

  4. D

    CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')

  5. E

    CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)

Show answer and explanation

Correct answer: E