Oracle认证考试1z0-883章节练习(2019.04.21)

单项选择题
Identify a performance impact when using the Performance Schema.（）
A.There is no impact on performance
B.The overhead depends on the settings of the Performance Schema
C.There is an overhead for querying the Performance Schema but not for having it enabled
D.There is a constant overhead regardless of settings and workload
多项选择题
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）
A.Both technologies guarantee an identical copy of data on the secondary node
B.Only MySQL can maintain a time-delayed copy of data on the secondary node
C.Both technologies use the TCP/IP stack as their primary transmission medium
D.DRBD uses shared-disk technology
单项选择题
Consider the following:Which statement best describes the meaning of the value for the key_len column?（）
A.It shows the total size of the index row
B.It shows how many columns in the index are examined
C.It shows the number of characters indexed in the key
D.It shows how many bytes will be used from each index row
多项选择题
What are three methods to reduce Mysql server exposure to remote connections?（）
A.Setting — skip-networking when remote connections are not required
B.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
C.Setting specific GRANT privilege to limit remote authentication
D.Setting – mysql_secure_configuration to enable paranoid mode
E.Using SSL when transporting data over remote networks
多项选择题
What are three actions performed by the mysql_secure_installation tool?（）
A.It prompts you to set the root user account password
B.It checks whether file permissions are appropriate within datadir
C.It asks to remove the test database, which is generated at installation time
D.It can delete any anonymous accounts
E.It verifies that all users are configuration with the longer password hash
单项选择题
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）
A.UPDATE pets…
B.SELECT….FROM pets
C.INSERT INTO pets…
D.ALTER TABLE pets…
多项选择题
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）
A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B.Execute the PURGE BINARY LOGE NOT USED command
C.Remove all of the binary log files that have a modification date earlier than today
D.Edit the .index file to remove the files you want to delete
E.Ensure that none of the attached slaves are using any of the binary logs you want to delete
单项选择题
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?（）
A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
单项选择题
Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?（）
A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
多项选择题
A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）
A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function
C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity
D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite
E.The applications have the SUPER privilege, which allows them to update rows