1Z0-908 PDF問題集リアル2023最近更新された問題 [Q79-Q98]

1Z0-908 PDF問題集リアル2023最近更新された問題

リリースOracle 1Z0-908更新された問題PDF

質問 # 79
Examine these statements and output:

Which statement is true?

A. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
B. The user is logged in with --user=accountingas an option.
C. The user is authenticated as the anonymous proxy user ‘’@’%’.
D. The user is authorized as the rsmith@localhostuser.
E. The user is authorized as the accounting@localhostuser.

正解：D

質問 # 80
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

A. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
B. ALTER USER baduser@hostname ACCOUNT LOCK;
C. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
D. ALTER USER baduser@hostname DEFAULT ROLE NONE;
E. ALTER USER baduser@hostname PASSWORD DISABLED;

正解：B、C

質問 # 81
Which two statements are true about MySQL server multi-source replication? (Choose two.)

A. It needs to be re-instanced after a crash to maintain consistency.
B. It relies on relay_log_recovery for resilient operations.
C. It must use GTID replication.
D. It uses only time-based replication conflict resolution.
E. It does not attempt to detect or resolve replication conflicts.
F. It is not compatible with auto-positioning.

正解：C、D

質問 # 82
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

A. It does not support the transportable tablespaces feature.
B. It supports all indexes transparently.
C. It enforces encryption from disk to memory and over network transmission.
D. It supports only non-blob datatypes.
E. It decrypts data for use in memory.

正解：B、E

質問 # 83
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

A. audit log
B. slow query log
C. error log
D. general query log
E. binary log

正解：E

質問 # 84
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It is not necessary because innodb_data_home_dir is already defined.
B. It defines all innodb tablespace options relative to a starting parent directory.
C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
D. It allows scanning of other locations to discover more innodb tablespaces.
E. It adds more temporary workspace in addition to the innodb_tmpdir location.

正解：D

解説：
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

質問 # 85
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \

A. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;
B. SELECT * FROM information_schema.COLUMN_STATISTICS;
C. DESCRIBE manufacturing.parts;
D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
E. SHOW INDEXES FROM manufacturing.parts;

正解：A、B

解説：
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

質問 # 86
Which two statements are true about the binary log encryption feature? (Choose two.)

A. It can be activated per session.
B. It requires a keyring plugin.
C. It encrypts any connecting slaves connection thread.
D. It can be set at run time.
E. When enabled it encrypts existing binary logs.

正解：A、C

質問 # 87
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster?
(Choose two.)

A. Remove the @@GLOBAL.gtid_executed statement from the dump file.
B. Remove the group replication plugin from each instance before restoring.
C. Stop all instances except the primary read/write master instance and run the restore.
D. Restore using the --set-gtid-purged=OFF option.
E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
F. Create the backup by using the --set-gtid-purged=OFF option.

正解：E、F

質問 # 88
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

A. VERIFY_CA
B. REQUIRED
C. VERIFY_IDENTITY
D. DISABLED
E. PREFERRED

正解：A、C

解説：
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html

質問 # 89
Which statement is true about InnoDB persistent index statistics?

A. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
B. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
C. Tables are scanned and index statistics recalculated when an instance is restarted.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Updating index statistics is an I/O expensive operation.
F. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

正解：D

質問 # 90
Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

A. Remove world read privileges from the server-cert.pem certificate file.
B. Remove group read/write privileges from the private_key.pem file.
C. Change the parent directory owner and group to mysql.
D. Remove world read privileges from the public_key.pem file.
E. Remove the world read/execute privilege from the accounting directory.
F. Change the group ownership of the mysql directory to the mysql user group.

正解：C、F

質問 # 91
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

A. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
B. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘;
D. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
E. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
F. SELECT email,passwd FROM members

正解：A、F

質問 # 92
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A. The cluster will shut down to preserve data consistency.
B. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
C. A manual intervention to force group members to be only the working two instances is required.
D. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
E. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

正解：A、D

質問 # 93
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)

A. It executes flush tables with read lock.
B. It enforces consistent backups for all storage engines.
C. This option uses the READ COMMITTED transaction isolation mode.
D. It is a cold backup.
E. The backup created is a consistent data dump.

正解：A、C

質問 # 94
Which three statements are true about MySQL replication? (Choose three.)

A. Any instance can have multiple slaves, but it can have only one master.
B. Replication can use only TCP/IP connections.
C. A replication user must have the SELECT privilege for all tables that need to be replicated.
D. Each slave must have its own MySQL user for replication.
E. Binary logs contain only transactions originating from a single MySQL instance.
F. Binary logging must be enabled on the master in order to replicate to other instances.
G. Each instance in a replication topology must have a unique server ID.

正解：C、F、G

質問 # 95
Examine this query:

What information does this query provide?

A. total memory used by connection number 10
B. total memory used by thread number 10
C. total memory used across all connections associated with the user on connection number 10
D. total memory used across all connections associated with the user on thread number 10
E. total memory used by the first 10 connections
F. total memory used by the first 10 threads

正解：A

質問 # 96
You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)

A. ibdatal:12M:autoextend;ibdata2:12M:autoextend
B. ibdatal:12M;ibdata2:12M;ibdata3:12M
C. ibdatal:12M:autoextend
D. ibdatal:12M
E. ibdatal:12M;/tmp/ibdata2:12M:autoextend
F. ibdatal:12M;ibdata2:12M:autoextend

正解：B、D

質問 # 97
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

A. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
B. Setting transaction_allow_batching to on will improve data consistency.
C. Each slave thread is responsible for updating a specific database.
D. Increasing slave_parallel_workers will improve high availability.
E. Cross-database constraints can cause database inconsistency.
F. Setting slave_preserve_commit_order to on will improve data consistency.

正解：F

質問 # 98
......

1Z0-908問題集と練習テスト（142試験問題)：https://jp.fast2test.com/1Z0-908-premium-file.html

ガイド（2023年最新）実際のOracle 1Z0-908試験問題：https://drive.google.com/open?id=1C9yUZ62Rh4L_Ow7vih1l9J-OnY3tWq1C