• ホーム
  • ブログ
  • 合格できるOracle 1Z0-888のPDF問題集！最近更新された155問あります [Q79-Q102]

合格できるOracle 1Z0-888のPDF問題集！最近更新された155問あります [Q79-Q102]

Share

合格できるOracle 1Z0-888のPDF問題集！最近更新された155問あります

更新されたテストエンジン1Z0-888練習問題集と練習試験合格させます


Oracle 1Z0-888 認定試験の出題範囲：

トピック出題範囲
トピック 1
  • SQLインジェクションからの保護
  • ネットワークセキュリティの理解
トピック 2
  • サーバーオプション、変数、およびコマンドラインを理解する
  • インストールされているファイルとディレクトリを特定する
トピック 3
  • サーバーの速度低下の原因を特定する
  • ユーザーアカウントを作成および変更する
トピック 4
  • レプリケーショントポロジの構成
  • レプリケーションのトラブルシューティング
トピック 5
  • レプリケーションスレッドの特定
  • パスワードセキュリティの使用
  • 低速クエリの特定
トピック 6
  • セキュリティリスクの特定
  • クエリパフォーマンスの最適化
トピック 7
  • バイナリログを使用する手法を説明する
  • 初期構成を理解する
トピック 8
  • オペレーティングシステムのセキュリティを説明する
  • Mysqlがリクエストを処理する方法を理解する
  • EXPLAINステートメントを理解する
トピック 9
  • レプリケーションの監視
  • Mysqlの開始と停止
  • レプリケーションの構成
トピック 10
  • 忘れたルートパスワードをリセットする
  • システム変数を使用する
  • キャパシティプランニングを使用する
トピック 11
  • Mysqlがデータを保存する方法を説明する
  • REDOおよびUndoログを特定する
トピック 12
  • パスワードとアカウントの有効期限を設定する
  • Mysql特権システムを特定する

 

質問 79
You have just executed a manual backup by using this command:
mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

  • A. Backup State = Prepared Backup
    Operation = validate
  • B. Backup State = Raw Backup
    Operation = backupdir-to-image
  • C. Backup State = Compressed Backup
    Operation = copy-back
  • D. Backup State = Raw Backup
    Operation = apply-log
  • E. Backup State = Prepared Backup
    Operation = apply-log

正解: B

 

質問 80
You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

  • A. service mysqld prepare-init
  • B. mysqld_safe --user=mysql
  • C. mysql -u root -p < support-files/mysqldb.sql
  • D. mysqld --initialize ...
  • E. mysqld_safe --initialize ...

正解: D

解説:
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html

 

質問 81
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

  • A. enforce_gtid_consistency=ONand consistency is broken between the master and the slave.
  • B. The sync_relay_log=1000setting on the slave is too small.
  • C. sync_binlog=0and the master server crashed.
  • D. binlog_cache_size=1024is too small and transactions are lost.
  • E. binlog_format=STATEMENTand a non-deterministic query was executed.

正解: A,D

解説:
Explanation/Reference:

 

質問 82
Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query?

  • A. The secondary indexes are optimized for unique key look-ups.
  • B. There are three indexes on the table.
  • C. There is a redundant index on the dept_no column.
  • D. The selectivity of the dept_no column is the best of the indexed columns.
  • E. There is a redundant index on the emp_no column.
  • F. The values on the emp_no column must be unique.

正解: A,E

 

質問 83
What is the order of tables shown in an EXPLAIN output?

  • A. It lists tables in the order in which their data will be read.
  • B. It lists tables from the most optimized to the least optimized.
  • C. It lists tables from the smallest to the largest.
  • D. It lists tables in the order in which they are specified in the statement that is being explained.

正解: D

 

質問 84
Which MySQL utility copies the master instance to a slave instance on the same host?

  • A. mysqlserverclone
  • B. mysqlfailover
  • C. mysqlrplsync
  • D. mysqldbcopy

正解: A

 

質問 85
What are two benefits of using the --tab option with mysqldump? (Choose two.)

  • A. It is possible to restore the data in parallel.
  • B. It can be piped directly into a running server.
  • C. The schema and data are automatically dumped to separate files.
  • D. It can be used together with --all-databases.

正解: A,D

 

質問 86
You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?

  • A. an abbreviation for NULL in a statement
  • B. the name of the user issuing the statement
  • C. an abstracted substitution for numbers indicated in WHERE clauses
  • D. the number of times the statement was executed

正解: D

解説:
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html

 

質問 87
Examine the mysqldumpslow output:

Which two options could explain the slow query?

  • A. A full table scan is being used.
  • B. No index has been defined on the filtered column.
  • C. There are 108 queries still being executed.
  • D. A table lock is causing delays.
  • E. There is network congestion between client and server.

正解: A,E

 

質問 88
How does the InnoDB storage engine handle deadlocks when they are detected?

  • A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
  • B. The transaction isolation level determines which transaction is rolled back.
  • C. Both the affected transactions will be rolled back.
  • D. One of the affected transactions will be rolled back, the other is allowed to proceed.
  • E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

正解: D

解説:
Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html

 

質問 89
In which order does MySQL process an incoming INSERT statement?

  • A. It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.
  • B. It checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.
  • C. It optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.
  • D. It checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.

正解: A

 

質問 90
You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

  • A. You would receive an error on the statement because you cannot update a different database that what is specified with the USEstatement.
  • B. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
  • C. The changes caused by the UPDATEstatement are logged to the binary log because the instance is using --binlog-format = ROW
  • D. The statement would fail because you cannot update more than one row at a time when using -- binlog-format = ROW.
  • E. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-formatvalue set to STATEMENT.

正解: B,E

 

質問 91
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

  • A. the mysql client with the --ignore-password-hashing option
  • B. the install plugin command for the mysql_cleartext_password plugin
  • C. the mysql_secure_installation script to update server security settings
  • D. the mysql_upgrade script
  • E. the mysql client with the --enable-cleartext-plugin option

正解: C

 

質問 92
You have the following in your my.cnf configuration file:
[ mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

  • A. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY
    'imbatman';
  • B. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
  • C. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY 'imbatman';
  • D. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
  • E. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH
    sha256_password 'imbatman';
  • F. CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS
    ' webdesign' USING 'imbatman';

正解: B,D

解説:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

 

質問 93
Which two methods accurately monitor the size of your total database size over time?

  • A. monitoring the innodb_redo_log_size variable
  • B. monitoring the information_schemA.TABLES table
  • C. monitoring cumulative Innodb_page_size increase
  • D. monitoring the performance_schema_hosts_size variable
  • E. monitoring datadir size in the operating system
  • F. monitoring the Innodb_rows_inserted status variable

正解: B,E

 

質問 94
Consider:

Which statement best describes the meaning of the values in the ref columns?

  • A. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.
  • B. world.City.CountryCodeis used as the primary key for the Country table.
  • C. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.
  • D. world.City.CountryCode is used to sort the rows in the Citytable.

正解: C

 

質問 95
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

  • A. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
  • B. Use the limit clause to limit the deletion to 100.000 rows.
  • C. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.
  • D. Use the limit clause in conjunction with the order 3Y clause.

正解: C,D

 

質問 96
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index?

  • A. Add a functional index for YEAR(Birthday).
  • B. Add FORCE INDEX (Birthday) to the query.
  • C. Add a generated column calculating YEAR(Birthday) and index that column.
  • D. Execute ANALYZE TABLE to update the index statistics.
  • E. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

正解: B,E

 

質問 97
What is the order of tables shown in an EXPLAIN output?

  • A. It lists tables in the order in which their data will be read.
  • B. It lists tables from the most optimized to the least optimized.
  • C. It lists tables from the smallest to the largest.
  • D. It lists tables in the order in which they are specified in the statement that is being explained.

正解: D

解説:
Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html

 

質問 98
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

  • A. the mysql client with the --ignore-password-hashing option
  • B. the install plugin command for the mysql_cleartext_password plugin
  • C. the mysql_secure_installation script to update server security settings
  • D. the mysql_upgrade script
  • E. the mysql client with the --enable-cleartext-plugin option

正解: C

解説:
Reference: http://planet.mysql.com/entry/?id=34077

 

質問 99
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

  • A. It is a shared-nothing architecture.
  • B. It is provided by means of IP-level disk replication.
  • C. It implements High Availability by using the NET Connector's load balancing capabilities.
  • D. It relies on the shared disk architecture being visible to both servers.

正解: D

 

質問 100
Consider the ANALYZE TABLE command.
In which two situations should this command be used?

  • A. when you need to find out why a query is taking a long time to execute
  • B. after large amounts of table data have changed
  • C. when you want to check a tables structure to see if it may have been damaged and needs repair
  • D. when you want to update index distribution statistics

正解: B,D

 

質問 101
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

  • A. It is a global buffer.
  • B. It caches index blocks for all storage engine tables.
  • C. It caches index blocks for MyISAM tables only.
  • D. It caches index blocks for InnoDB tables only.
  • E. It is set on a per-connection basis.

正解: C,E

解説:
Explanation/Reference:
Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer

 

質問 102
......

Oracle 1Z0-888問題集でカバー率リアル試験問題：https://www.goshiken.com/Oracle/1Z0-888-mondaishu.html

関するブログ

もっと
1Z0-888無料問題集