최신Oracle MySQL 5.7 Database Administrator - 1Z1-888무료샘플문제
문제1
What three are correct statements about MySQL backups? (Choose three.)
What three are correct statements about MySQL backups? (Choose three.)
정답: A,D,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
Which statement is correct about how InnoDB storage engine uses disk space?
Which statement is correct about how InnoDB storage engine uses disk space?
정답: A
문제3
Consider the ANALYZE TABLE command.
In which two situations should this command be used?
Consider the ANALYZE TABLE command.
In which two situations should this command be used?
정답: B,C
문제4
SQL injection is a common security threat.
Which two methods would help protect against this risk? (Choose two.)
SQL injection is a common security threat.
Which two methods would help protect against this risk? (Choose two.)
정답: C,D
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
정답: D
문제6
You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?
You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
정답: C
문제8
Which three allocate memory per thread in MySQL?
Which three allocate memory per thread in MySQL?
정답: B,D,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제9
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?
정답: C
문제10
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?
정답: D
문제11
What does the Performance Schema provide?
What does the Performance Schema provide?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제12
Which two statements are true regarding MySQL security? (Choose two.)
Which two statements are true regarding MySQL security? (Choose two.)
정답: A,C
문제13
Which two statements describe how InnoDB recovery works?
Which two statements describe how InnoDB recovery works?
정답: B,F
문제14
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations. Which two other steps can help avoid data loss in a major catastrophe?
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations. Which two other steps can help avoid data loss in a major catastrophe?
정답: D,E