無料で使える1Z0-921試験ブレーン問題集認定ガイド問題と解答 [Q38-Q59]

無料で使える1Z0-921試験ブレーン問題集認定ガイド問題と解答

1Z0-921認定概要最新の1Z0-921のPDF問題集

Oracle 1Z0-921 試験に備えて、候補者はオンラインのトレーニングコース、勉強ガイド、模擬試験など、さまざまなリソースを利用することができます。Oracle Universityでは、試験目標を詳しくカバーするトレーニングコースを提供しています。候補者は、さまざまなソースからの勉強ガイドや模擬試験を利用して、知識とスキルを向上させることもできます。

Oracle 1Z0-921試験は、MySQLデータベースの実装と管理に関する知識とスキルをテストするために設計されています。この試験は、MySQLのコンセプトに強い理解を持ち、自分のスキルと知識を確認したい個人を対象としています。試験は、データベースアーキテクチャ、データ型、セキュリティ、パフォーマンスチューニング、バックアップおよびリカバリなど、幅広いトピックをカバーしています。

 

質問 # 38
Which three options are valid reasons for using a primary key in a table?

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

正解：A、C、D

質問 # 39
Which two statements about the download of MySQL Enterprise Backup are correct?

• A. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
• B. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
• C. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
• D. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.
• E. MySQL Enterprise Backup comes with all MySQL editions including community edition.

正解：B、E

質問 # 40
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

• A. You forgot to enable port 3306.
• B. You forgot to create the correct SSL/TLC certificate during the setup process.
• C. The opc user can be used to access MySQL only with the created SSH-Key.
• D. The OCI instance is still in the "creation" process.
• E. Only root is allowed to access from non-localhost.

正解：A

質問 # 41
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 public key
• C. Public IP address
• D. The opc user
• E. SSH private key
• F. The root user

正解：D

質問 # 42
What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

• A. Pod and ReplicaSet
• B. PVC (Persistent Volume Claim) and ConfigMap
• C. Secret and Deployment
• D. PVC (Persistent Volume Claim) and PV (Persistent Volume)

正解：D

質問 # 43
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?

• A.
• B.
• C.
• D.
• E.

正解：B

質問 # 44
Which three are levels in which MySQL Enterprise Monitor provides access control?

• A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
• B. Specific data access: the rights to view specific types of potentially sensitive data
• C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
• D. Asset visibility: the rights to access data collected from hosts or MySQL instances
• E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

正解：B、C、D

質問 # 45
Which statement would you use to remove the population column from the city table?

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

正解：E

質問 # 46
Which two statements are true about MySQL Enterprise Authentication?

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

正解：A、E

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

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

正解：D

質問 # 48
You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

• A. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
• B. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
• C. Use mysqldump with the - -changesonly option.
• D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
• E. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

正解：A、C

質問 # 49
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

• A. There are no maintenance operations planned. You need to do them manually.
• B. You need to agree to the maintenance windows. If not, you are not affected by the outage.
• C. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
• D. You can expect an outage of your MySQL OCI instance during the planned time..

正解：D

質問 # 50
Which three statements are true about MySQL Enterprise Backup?

• A. It enables you to take non-locking backups.
• B. It performs hot or warm backups.
• C. It provides the ability to create incremental backups.
• D. It performs logical backups.
• E. It cannot back up encrypted tablespaces.

正解：A、C、D

質問 # 51
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?

• A. SHOW BINLOG EVENTS;
• B. GRANT PROXY
• C. SHOW PROCESSLIST;
• D. KILL PROCESS;
• E. SHUTDOWN
• F. SHOW STATUS;

正解：D、E、F

質問 # 52
Which is a correct example of creating an Enterprise Encryption function?

• A. SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);
• B. VALIDATE FUNCTION create_asymmetric_priv_key WITH ,openssl_udf.so';
• C. INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(,RSA,, 1024));
• D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ,openss1_udf.so,;

正解：D

質問 # 53
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A. Encryption key is stored in a centralized key memory location
• B. Data is encrypted automatically, in real time, after it is written to storage.
• C. Tablespace keys are managed manually behind the scenes.
• D. Enables data-at-rest encryption by encrypting the physical files of the database.

正解：D

質問 # 54
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

• A. random data substitution
• B. whitelisting and substitution
• C. strict or relaxed masking
• D. dictionary substitution
• E. misspelling

正解：A、C、D

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

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

正解：C

質問 # 56
Which three statements describe MySQL Enterprise Backup?

• A. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
• B. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
• C. MySQL Enterprise Backup provides the point-in-time recovery functionality.
• D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
• E. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

正解：A、C、D

質問 # 57
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 t1 table is created.
• B. Only the t2 table is created.
• C. Both the tables, t1 and t2, are created.
• D. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

正解：C

質問 # 58
The slave connects to the master and asks for updated records. What command was issued for this to happen?

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

正解：C

質問 # 59
......

ベストなOracle 1Z0-921学習ガイドと問題集には2025：https://www.jpntest.com/shiken/1Z0-921-mondaishu

トップクラスOracle 1Z0-921試験材料で学習ガイド！練習問題バージョンで挑もう：https://drive.google.com/open?id=1kPZO231cODY6vTQU4oj_X-2VJ7BnIkhv