최신Oracle MySQL 5.7 Database Administrator - 1Z0-888무료샘플문제
문제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?
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?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
You are asked to examine user accounts and find:
Which two statements will best secure this environment? (Choose two.)
You are asked to examine user accounts and find:
Which two statements will best secure this environment? (Choose two.)
정답: C,D
문제3
Which statement best describes the purpose of the InnoDB buffer pool?
Which statement best describes the purpose of the InnoDB buffer pool?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:
Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.
You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.
Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?
The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:
Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.
You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.
Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?
정답: C
문제6
Consider:
What does the range value in the type column mean?
Consider:
What does the range value in the type column mean?
정답: A
문제7
Which statement describes how the relay log works?
Which statement describes how the relay log works?
정답: A
문제8
In which order does MySQL process an incoming INSERT statement?
In which order does MySQL process an incoming INSERT statement?
정답: C
문제9
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)