최신Oracle MySQL 5.6 Database Administrator - 1z1-883무료샘플문제
문제1
Which two statements are true about InnoDB auto-increment locking?
Which two statements are true about InnoDB auto-increment locking?
정답: B,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제2
Which query would you use to find connections that are in the same state for longer than 180 seconds?
Which query would you use to find connections that are in the same state for longer than 180 seconds?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제3
Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?
Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?
정답: C,D
문제4
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?
정답: E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
Which three statements describe how the strict SQL mode provides added security?
Which three statements describe how the strict SQL mode provides added security?
정답: B,C,D
문제6
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
문제7
The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?
The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?
정답: B,C,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?
Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?
정답: D
문제10
An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';
8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT... TO 'bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO 'key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO 'joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?
An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';
8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT... TO 'bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO 'key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO 'joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?
정답: A