Instant Download Oracle 1Z0-921 Free Updated Test Dumps [Q45-Q63]

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

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

Q47. Which Oracle product is certified to work with MySQL Enterprise Edition?

Q48. You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

Q49. Which statement would you use to remove the population column from the city table?

Q50. 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?

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

Q52. 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?

Q53. 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?

Q54. 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?

Q55. 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?

Q56. Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

Q57. Which three are levels in which MySQL Enterprise Monitor provides access control?

Q58. 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?

Q59. Which two statements are true about MySQL Enterprise Authentication?

Q60. You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

Q61. You execute this statement:
SELECT NULL=NULL;
What is the result?

Q62. Which two statements are true about MySQL Enterprise Firewall?

Q63. Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?