Oracle 1Z0-921 Real 2025 Braindumps Mock Exam Dumps [Q40-Q64] : Best Free Exam Guide : http://free.exams4sures.com

NO.40 Which statement adds a column with the largest integer data type?

ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

NO.41 The user ‘fwuser’@’localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser” @* localhost* user. Which statement should you run to accomplish this?

NO.42 The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

NO.43 Which three statements are true about MySQL Enterprise Backup?

It performs hot or warm backups.

It provides the ability to create incremental backups.

It cannot back up encrypted tablespaces.

It enables you to take non-locking backups.

It performs logical backups.

NO.44 Which two methods help prevent MySQL security risks?

Use a firewall to control access to MySQL ports.

Transmit plain (unencrypted) data over networks.

Ensure that MySQL accounts have short and easy passwords.

Allow unauthorized clients to connect to the server.

Use the secure installation script “mysql_alays_secure_installation”.

Grant only permissions that a user requires.

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

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

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

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

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

CREATE USER , joe,@1′ %’ DENY ALL PRIVILEGES

NO.46 Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

MySQL Advisors

Query Analyzer

MySQL Dashboard

MySQL Query Analyzer

NO.47 What SQL keyword must be specified when creating a foreign key constraint?

a TRIGGER on the child table for cascading delete statements

a REFERENCES in the child table to the parent table

unique PRIMARY key values for both child and parent tables

the SET_FOREGIN variable in the my .cnf file

an index on the foreign key

NO.48 Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

Custom Image

Object Storage

existing VCN

bare metal Oracle Linux shape

ssh key pair

subnet configured on a Virtual Cloud Network (VCN)

NO.49 Which two statements are correct about MySQL Enterprise Edition?

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

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

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

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

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

NO.50 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?

CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY ‘SecretPass123!,;

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

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

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

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

NO.51 Which MySQL command is used to grant specific privileges to a user on a database?
Response:

GRANT

GIVE ACCESS

SET PRIVILEGES

GRANT PERMISSIONS

NO.52 You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using – -backup-dir and by giving–hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using – -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using – – backup-dir and by specifying — config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

NO.53 What are Security Lists in Oracle Cloud Infrastructure?

They allow administrators access to applications in the cloud and external servers.

They are user-role designations that assign rights to certain internal users and external users.

They are essentially firewall rules that help control traffic between OCI instances.

Security lists are data encryption levels that control who can see the data.

They contain rules established by HIPAA for securing end-user data.

NO.54 You want to create an encrypted table. So, you enter this command:
CREATE TABLE ‘test_encryption2% (
‘id’ int(10) unsigned NOT NULL AUTO_INCREMENT,
‘server_name’ varchar(15) NOT NULL,
PRIMARY KEY (‘id’) ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = ‘Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for ‘test_encryption2’ doesn’t have this option Which statement correctly explains the reason for this error?

You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

The term “server_name” is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

NO.55 Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

creating e-mail alerts and SNMP traps for MySQL warnings

starting and stopping the MySQL instance

analyzing executed MySQL queries

deploying MySQL agent on supported target operating system

monitoring the availability of the MySQL Instance

tracing import and export with mysqldump

NO.56 You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

Go to the configuration section (MEM) and configure the default login credentials.

NO.57 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?

The SLAVE and MASTER instances are started with the same configured value for the option – – monitor_server_uuid.

The MASTER and SLAVE are grouped as one instance for monitoring.

The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

NO.58 Which three are characteristics of the JSON data type?

A set of SQL functions substantially support the SQL utilization of the data type.

It supports indexing directly against the JSON-defined column.

It validates the JSON syntax on insert or merge.

Comparisons of JSON values are not case-sensitive.

Key or array references enable quick read-access to look up document elements directly.

It is based on the TEXT data type.

NO.59 Which activity will take place if a table is created with both the compression and encryption options?

The compression is performed before tablespace data is encrypted.

The tablespace data is encrypted first and then compression is performed.

The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

The compression is performed, the ”data_at_rest_flag” is turned on and the tablespace data is encrypted.

NO.60 What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

Data is encrypted automatically, in real time, after it is written to storage.

Enables data-at-rest encryption by encrypting the physical files of the database.

Encryption key is stored in a centralized key memory location

Tablespace keys are managed manually behind the scenes.

NO.61 Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

Allocating more CPU to the database instance to improve throughput performance.

Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.

Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.

Increasing the storage capacity so that the database can store more data to scale.

NO.62 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?

Create user by using CREATE USER ‘newuser’ @’localhost’ SET PASSWORD AS ‘Sh@256Pa33’;

Add –default_authentication_plugin=sha256_password on the command line when you invoke the server.

Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

Create user by using CREATE USER ‘newuser’@’localhost’ IDENTIFIED WITH ‘Sh@256Pa33’;

NO.63 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?

The root password is not given and is blank. You must manually set the root password.

The root password inserted in the error log set by the –log-error=[file_name] variable

The root password displayed on the screen via a [warning] message.

The root_pw variable stored in the mysq1.install table.

As root, execute the show password command by using the SHA-256 password encryption plug-in.

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

MySQL Enterprise Monitor and MySQL Audit

MySQL Workbench and MySQL Enterprise Firewall

MySQL Audit and MySQL Workbench

SQL Enterprise Monitor and MySQL Enterprise Authentication