최신 Oracle MySQL 1Z0-921 무료샘플문제:
1. Which activity will take place if a table is created with both the compression and encryption options?
A) The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
B) The tablespace data is encrypted first and then compression is performed.
C) The compression is performed before tablespace data is encrypted.
D) The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
2. 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 can be used to import/export data from on-premises MySQL installations.
D) MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
E) MySQL Enterprise Backup provides the point-in-time recovery functionality.
3. 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.
4. Which statement is used to create a new MySQL database?
Response:
A) CREATE DATABASE
B) CREATE SCHEMA
C) CREATE TABLE
D) NEW DATABASE
5. Which two statements are true about MySQL Enterprise Firewall?
A) System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
B) MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
C) On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
D) Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
E) 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.
F) MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: A,D,E | 질문 # 3 정답: A | 질문 # 4 정답: A | 질문 # 5 정답: A,D |