1Z1-921 무료 덤프문제 온라인 액세스

Which is true about inserting an additional line in a single document stored in MySQL document store?

• A.You specify the new element,s position in the JSON_ARRAY_INSERT statement.
• B.The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• C.Any new lines can only be inserted at the end of the document.
• D.You cannot insert a single line, you have to replace the entire document with a new document.

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

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

What is Kubernetes in the context of MySQL?
Response:

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

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

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

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?

• A.Only the t2 table is created.
• B.Both the tables, t1 and t2, are created.
• C.Only the t1 table is created.
• D.Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.