[Mar-2025] 1Z1-921 Certification with Actual Questions from TorrentExam
Updated 1Z1-921 Dumps PDF - 1Z1-921 Real Valid Brain Dumps With 78 Questions!
NEW QUESTION # 13
After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?
- A. The root password is not given and is blank. You must manually set the root password.
- B. The root_pw variable stored in the mysq1.install table.
- C. The root password displayed on the screen via a [warning] message.
- D. As root, execute the show password command by using the SHA-256 password encryption plug-in.
- E. The root password inserted in the error log set by the --log-error=[file_name] variable
Answer: B,D
NEW QUESTION # 14
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. User Password
- B. SSH private key
- C. SSH public key
- D. The opc user
- E. Public IP address
- F. The root user
Answer: D
NEW QUESTION # 15
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.
- A. 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.
- B. MySQL Enterprise Backup will back up from Slave automatically.
- C. It allows backup to be done on the slave without impacting the master.
- D. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
- E. It provides multi-master access where the application can write and read data across the database servers.
Answer: A,B,C
NEW QUESTION # 16
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?
- A. --uncompress-and-apply-log
- B. --decompress
- C. --uncompress
- D. --copy-back-and-apply-log
- E. --apply-log-and-copy-back
Answer: C,D
NEW QUESTION # 17
What are Security Lists in Oracle Cloud Infrastructure?
- A. They are essentially firewall rules that help control traffic between OCI instances.
- B. Security lists are data encryption levels that control who can see the data.
- C. They allow administrators access to applications in the cloud and external servers.
- D. They contain rules established by HIPAA for securing end-user data.
- E. They are user-role designations that assign rights to certain internal users and external users.
Answer: A
NEW QUESTION # 18
You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?
- A. The table will be optimized and replicated.
- B. The table will be checked for errors and repaired.
- C. The table storage space will be reduced.
- D. The table statistics will be stored.
Answer: A
NEW QUESTION # 19
Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?
- A. You must have an IPSec VPN to connect to an Oracle Linux instance.
- B. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
- C. You can connect directly to an instance over the internet, without a public IP address.
- D. You can connect directly to the VCN without a define subnet.
- E. Your instance does not have a public IP address, so you cannot connect with a public subnet.
Answer: C,D
NEW QUESTION # 20
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 supports indexing directly against the JSON-defined column.
- E. Key or array references enable quick read-access to look up document elements directly.
- F. It is based on the TEXT data type.
Answer: B,D,E
NEW QUESTION # 21
What three are ways to export and import data in MySQL Workbench?
- A. Result Data Export and Import
- B. Data Modeling Import Export Wizard
- C. Backup Data Export and Import Wizard
- D. Table Data Export and Import Wizard
- E. Binary Data Export and Import Wizard
- F. SQL Data Export and Import Wizard
Answer: A,D,F
NEW QUESTION # 22
Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:
- A. MySQL Query Analyzer
- B. MySQL Dashboard
- C. MySQL Advisors
- D. Query Analyzer
Answer: A
NEW QUESTION # 23
You execute this statement:
SELECT NULL=NULL;
What is the result?
- A. 0
- B. FALSE
- C. 1
- D. NULL
- E. TRUE
Answer: D
NEW QUESTION # 24
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. The opc user can be used to access MySQL only with the created SSH-Key.
- C. You forgot to create the correct SSL/TLC certificate during the setup process.
- D. You forgot to enable port 3306.
- E. The OCI instance is still in the "creation" process.
Answer: D
NEW QUESTION # 25
Which two statements are true about MySQL Enterprise Firewall?
- A. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
- B. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
- C. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
- D. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
- E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
- F. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
Answer: B,E
NEW QUESTION # 26
Which three are requirements for MySQL Group Replication (GR)?
- A. Primary keys are required on every replicated table.
- B. The minimum number of required nodes for achieving a consensus is two.
- C. The use of global transaction identifiers is required.
- D. Data to be replicated must be stored in the InnoDB transactional storage engine.
- E. GR only works with MySQL versions 8.0.12 or higher.
- F. The binary log format must be set to mixed.
Answer: A,D,F
NEW QUESTION # 27
Which three statements describe MySQL Enterprise Backup?
- A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
- B. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
- C. MySQL Enterprise Backup provides the point-in-time recovery functionality.
- D. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
- E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
Answer: B,C,E
NEW QUESTION # 28
What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?
- A. SMS-notification tab on the dashboard
- B. Browser pop-ups
- C. Application-to-application messaging
- D. Direct support call from an Oracle representative
- E. Email
Answer: A,E
NEW QUESTION # 29
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?
- A. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
- B. You can expect an outage of your MySQL OCI instance during the planned time..
- C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
- D. There are no maintenance operations planned. You need to do them manually.
Answer: B
NEW QUESTION # 30
Which three statements are true about MySQL Enterprise Backup?
- A. It cannot back up encrypted tablespaces.
- B. It provides the ability to create incremental backups.
- C. It enables you to take non-locking backups.
- D. It performs hot or warm backups.
- E. It performs logical backups.
Answer: B,C,E
NEW QUESTION # 31
The slave connects to the master and asks for updated records. What command was issued for this to happen?
- A. RUN SLAVE
- B. START SLAVE
- C. SLAVE START
- D. SLAVE RUN
- E. START RUN SLAVE
Answer: C
NEW QUESTION # 32
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. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
- B. On the Master server, disable binlog by removing the --log-bin option.
- C. Delete all binlog files manually on the file system to release storage spaces.
- D. To safely purge binary log files, perform these steps:
- E. Execute the purge binary logs statement without argument.
Answer: A,D
NEW QUESTION # 33
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 mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
- B. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
- C. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
- D. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
- E. The MASTER and SLAVE are grouped as one instance for monitoring.
Answer: A,E
NEW QUESTION # 34
When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?
- A. Cloud storage only
- B. Cloud tape library
- C. Flash-archive recovery area
- D. Both Cloud storage and local storage
Answer: A,D
NEW QUESTION # 35
......
Pass Your 1Z1-921 Exam Easily With 100% Exam Passing Guarantee: https://www.torrentexam.com/1Z1-921-exam-latest-torrent.html
100% Free 1Z1-921 Exam Dumps Use Real Oracle MySQL Dumps: https://drive.google.com/open?id=1JLNDTcw36pzuxTkg0wqik6cuvnAls9Wv
