1Z1-888無料問題集「Oracle MySQL 5.7 Database Administrator」

質問 1

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）mysql -u root -p < support-files/mysqldb.sql

（B）mysqld_safe --user=mysql

（C）service mysqld prepare-init

（D）mysqld --initialize ...

（E）mysqld_safe --initialize ...

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

（A）rpl-recovery-rank

（B）log-master-updates

（C）log_bin

（D）master-logging

（E）enable-master-start

（F）server-id

正解：C、F 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

（A）Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

（B）It results in a syntax error because you cannot specify more than one partition in the same statement.

（C）All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

（D）All data in p1 and p3 partitions is removed and the table definition is changed.

正解：C 解答を投票する

質問 4

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

（A）when you want to update index distribution statistics

（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 need to find out why a query is taking a long time to execute

正解：A、B 解答を投票する

質問 5

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

（A）setting the --local-service=0 option when starting mysqld

（B）executing REVOKE FILE ON *_* FROM ` `@'%'

（C）executing REVOKE FILE FROM *_*

（D）executing REVOKE LOAD FROM *.*

（E）setting the --local-infile=0 option when starting mysqld

（F）setting the --open-files-limit=0 option when starting mysqld

正解：F 解答を投票する

質問 6

A crucial database, `db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?

（A）validating all user input before sending it to the database server

（B）using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions

（C）changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password

（D）writing your client code to properly escape all user input

（E）using a hashing or encryption method to secure all user passwords in your MySQL tables

（F）removing any remaining anonymous accounts from your MySQL instance

（G）giving limited privileges to accounts used by application servers to interact with their backing databases

正解：C、E、F 解答を投票する

質問 7

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

（A）The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

（B）The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

（C）The transaction isolation level determines which transaction is rolled back.

（D）Both the affected transactions will be rolled back.

（E）One of the affected transactions will be rolled back, the other is allowed to proceed.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

Which two methods will provide the total number of partitions on a table? (Choose two.)

（A）Query the performance_schema.objects_summary_global_by_type table

（B）Query the INFORMATION_SCHEMA.TABLES table for the partition_count

（C）Use the command: SHOW CREATE TABLE

（D）Query the INFORMATION_SCHEMA.PARTITIONS table

（E）Use the command: SHOW TABLE STATUS

正解：D、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

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 City table. The world.City.CountryCode column is used to select rows in the Country table.

（B）world.City.CountryCode is used to sort the rows in the Citytable.

（C）No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.

（D）world.City.CountryCodeis used as the primary key for the Country table.

正解：A 解答を投票する

質問 10

What two statements are true regarding FLUSH TABLES FOR EXPORT?

（A）It can be used to export TEMPORARY tables.

（B）Partitioned tables are not supported.

（C）Table only exports when the table has its own tablespace.

（D）It is the safest way to extract tables from the shared tablespace.

（E）The InnoDB Storage engine must be used for the table being exported.

正解：A、C 解答を投票する

1Z1-888 無料問題集「Oracle MySQL 5.7 Database Administrator」

弊社を連絡する

関連リンク

トップ試験