1Z1-921 by Oracle Valid Free Exam Practice Test

Question 1

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

A. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe'; B. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,; C. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES D. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,) E. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

Correct Answer: E

Question 2

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. Only root is allowed to access from non-localhost. B. You forgot to enable port 3306. C. You forgot to create the correct SSL/TLC certificate during the setup process. D. The opc user can be used to access MySQL only with the created SSH-Key. E. The OCI instance is still in the "creation" process.

Correct Answer: B

Question 3

MySQL is installed on a Linux server with the configuration:
Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

A. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file. B. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33'; C. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server. D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

Correct Answer: C,D

Question 4

Which three options are valid reasons for using a primary key in a table?

A. maintaining a history of row insertions or updates B. to make it easier to change the PRIMARY KEY value C. increasing performance when using select statements D. preventing duplicate keys E. exporting data faster with mysqldump F. automatic storage of data in a sorted order

Correct Answer: C,D,E

Question 5

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 *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,) B. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE C. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired) D. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,; E. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;

Correct Answer: C

Question 6

Which statement is used to create a new MySQL database?
Response:

A. CREATE TABLE B. CREATE SCHEMA C. NEW DATABASE D. CREATE DATABASE

Correct Answer: D

Question 7

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. On the Master server, disable binlog by removing the --log-bin option. B. Delete all binlog files manually on the file system to release storage spaces. C. To safely purge binary log files, perform these steps: D. Execute the purge binary logs statement without argument. E. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

Correct Answer: C,E

Question 8

Which three are characteristics of the JSON data type?

A. Comparisons of JSON values are not case-sensitive. B. It validates the JSON syntax on insert or merge. C. A set of SQL functions substantially support the SQL utilization of the data type. D. It is based on the TEXT data type. E. Key or array references enable quick read-access to look up document elements directly. F. It supports indexing directly against the JSON-defined column.

Correct Answer: B,E,F

Oracle MySQL 2021 Implementation Essentials - 1Z1-921 Exam Practice Test