Latest May-2025 1Z1-921 Dumps PDF And Certification Training [Q28-Q48]

Latest May-2025 1Z1-921 Dumps PDF And Certification Training

Check your preparation for Oracle 1Z1-921 On-Demand Exam

NEW QUESTION # 28
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. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
D. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

Answer: A,B

NEW QUESTION # 29
Which query will find rows in a table that have no counterpart in another table?

A. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
B. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
C. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
D. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

Answer: B

NEW QUESTION # 30
Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. You can connect directly to the VCN without a define subnet.
B. You can connect directly to an instance over the internet, without a public IP address.
C. Your instance does not have a public IP address, so you cannot connect with a public subnet.
D. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
E. You must have an IPSec VPN to connect to an Oracle Linux instance.

Answer: A,B

NEW QUESTION # 31
Which statement would you use to remove the population column from the city table?

A. ALTER TABLE city LESS population;
B. ALTER TABLE city DELETE population;
C. ALTER TABLE city DROP population;
D. DROP population FROM city;
E. DELETE population FROM city;

Answer: C

NEW QUESTION # 32
Which two deployment architectures could you use for scaling-out database reads?

A. Edit the configuration file and increase the value for parallel_read_workers and reboot the server
B. Implementing a three-node, single-primary InnoDB Cluster.
C. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
D. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
E. Altering the storage engine for all tables to memory to increase performance.

Answer: B,E

NEW QUESTION # 33
Which three options are valid reasons for using a primary key in a table?

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

Answer: A,B,D

NEW QUESTION # 34
You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

A. The MASTER and SLAVE are grouped as one instance for monitoring.
B. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
C. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
E. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

Answer: A,E

NEW QUESTION # 35
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 BY (,SecretPass123!,,,256,, Expired)
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,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
E. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

Answer: A

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

A. MySQL Audit and MySQL Workbench
B. SQL Enterprise Monitor and MySQL Enterprise Authentication
C. MySQL Workbench and MySQL Enterprise Firewall
D. MySQL Enterprise Monitor and MySQL Audit

Answer: B

NEW QUESTION # 37
You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

Answer: A

NEW QUESTION # 38
Which two statements are true about MySQL Enterprise Authentication?

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

Answer: A,E

NEW QUESTION # 39
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
B. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
C. A browser-based wizard to remotely deploy the MySQL Monitor Agent
D. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
E. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

Answer: A,B,D

NEW QUESTION # 40
How does MySQL HeatWave improve query performance?
Response:

A. By automatically creating indexes on frequently used columns.
B. By replicating data across multiple servers.
C. By offloading analytics queries to an in-memory, highly parallel processing engine.
D. By caching the entire database in memory.

Answer: C

NEW QUESTION # 41
What is Kubernetes in the context of MySQL?
Response:

A. A database engine for MySQL.
B. A database management tool for MySQL.
C. An open-source container orchestration platform.
D. A cloud service provided by Oracle for MySQL databases.

Answer: C

NEW QUESTION # 42
The slave connects to the master and asks for updated records. What command was issued for this to happen?

A. SLAVE START
B. SLAVE RUN
C. START SLAVE
D. RUN SLAVE
E. START RUN SLAVE

Answer: A

NEW QUESTION # 43
Which two methods help prevent MySQL security risks?

A. Allow unauthorized clients to connect to the server.
B. Grant only permissions that a user requires.
C. Use the secure installation script "mysql_alays_secure_installation".
D. Transmit plain (unencrypted) data over networks.
E. Ensure that MySQL accounts have short and easy passwords.
F. Use a firewall to control access to MySQL ports.

Answer: A,D

NEW QUESTION # 44
Which three are characteristics of the JSON data type?

A. It is based on the TEXT data type.
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. Key or array references enable quick read-access to look up document elements directly.
E. It supports indexing directly against the JSON-defined column.
F. Comparisons of JSON values are not case-sensitive.

Answer: B,D,E

NEW QUESTION # 45
Which statement will display the status of the partitioning plug-in?

A. SHOW PLUGINS WHERE Name= 'partition';
B. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
C. USE SYS SCHEMA; SHOW PLUGINS STATUS;
D. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';

Answer: D

NEW QUESTION # 46
What are Security Lists in Oracle Cloud Infrastructure?

A. Security lists are data encryption levels that control who can see the data.
B. They are essentially firewall rules that help control traffic between OCI instances.
C. They are user-role designations that assign rights to certain internal users and external users.
D. They contain rules established by HIPAA for securing end-user data.
E. They allow administrators access to applications in the cloud and external servers.

Answer: B

NEW QUESTION # 47
The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?