Oracle认证考试1z0-883单项选择题每日一练(2018.11.30)

单项选择题
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）
A.A
B.B
C.C
D.D
单项选择题
An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?（）
A.Bob has max_user_connections set to zero, which blocks all his connections
B.Joe has exceeded the max_user_connections global limit
C.All users are blocked because max_user_connections is accumulated over the host account information
D.Kay is already connected elsewhere and attempting to log in again
E.Connect_timeout is too small to allow a connection to occur
单项选择题
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?（）
A.Activating the MySQL Enterprise thread pool plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options
单项选择题
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）
A.The snapshot size will continue to grow as changes to the volume are made
B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D.The system keeps a copy of changes in memory and can cause an out of memory 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