최신Oracle MySQL 5.6 Database Administrator - 1z0-883무료샘플문제
문제1
When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.
When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.
정답: A
문제2
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?
정답: B,C
문제3
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows:
-The Mysql instance has 400 databases.
-Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
'ENGINE',
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GROUP BY TABLE_SCHEMA, 'ENGINE'
;
Why is this query slow to execute?
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows:
-The Mysql instance has 400 databases.
-Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
'ENGINE',
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GROUP BY TABLE_SCHEMA, 'ENGINE'
;
Why is this query slow to execute?
정답: A
문제4
A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event.
The server is configured with:
You have identified that the DELETE statement to skip has the Global Transaction Identifier (GTID) 'dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with:
Mysqlbinlog - exclude-gtides=' dbbe07da-fe25-11e2-b6c7-0800274aa49e:5' binlog.00000.2 | mysql
However all events were skipped instead of just the one deleting the wrong row.
What is the reason for this?
A user has deleted the wrong row in a table and you are preparing a point-in-time recovery skipping the DELETE event.
The server is configured with:
You have identified that the DELETE statement to skip has the Global Transaction Identifier (GTID) 'dbbe7da-fe25-11e2-b6c7-0800274aa49e:5 and you replay the binary log with:
Mysqlbinlog - exclude-gtides=' dbbe07da-fe25-11e2-b6c7-0800274aa49e:5' binlog.00000.2 | mysql
However all events were skipped instead of just the one deleting the wrong row.
What is the reason for this?
정답: A
문제5
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \> mysqld - install Mysql56 - defaults - file = C : \my -opts.cnf
What is the expected outcome?
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \> mysqld - install Mysql56 - defaults - file = C : \my -opts.cnf
What is the expected outcome?
정답: D
문제6
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?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
The 'allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather the following information:
[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0
Three tables are stored in the innoDB shared tablespace and the details are as follows: -The table data_current has 1,000,000 rows.
-The table data_reports has 1,500,000 rows. -The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ...
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.
Shell> mysqldump - u root - p applicationdb data_archive > /backup/data_archive.sql
Mysql> DROP TABLE data_archive;
Which set of actions will allow you to free disk space back to the file system?
The 'allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather the following information:
[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0
Three tables are stored in the innoDB shared tablespace and the details are as follows: -The table data_current has 1,000,000 rows.
-The table data_reports has 1,500,000 rows. -The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ...
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.
Shell> mysqldump - u root - p applicationdb data_archive > /backup/data_archive.sql
Mysql> DROP TABLE data_archive;
Which set of actions will allow you to free disk space back to the file system?
정답: D
문제8
You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?
You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?
정답: E
문제9
Which statement is true about FLUSH LOGS command?
Which statement is true about FLUSH LOGS command?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제10
Which two events will cause a slave server to create a new relay log file?
Which two events will cause a slave server to create a new relay log file?
정답: B,E
설명: (ExamPassdump 회원만 볼 수 있음)