1z0-908(175题)更240327_在线真题试卷与模拟练习_1z0-908(175题)更240327_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Choose the best answer. Examine these statements and output: mysql> GRANT PROXY ON accounting@localhost TO ''@'%'; mysql> SELECT USER(), CURRENT_USER(), @@proxy_user; +----------------+----------------+----------------+ | USER() | CURRENT_USER() | @@proxy_user | +----------------+----------------+----------------+ | rsmith@localhost| accounting@localhost| ''@'%' | +----------------+----------------+----------------+ Which statement is true?

Choose the best answer. Examine this statement, which executes successfully: CREATE TABLE world.city ( ID int NOT NULL AUTO_INCREMENT, Name char (35) NOT NULL DEFAULT '', CountryCode char (3) NOT NULL DEFAULT '', District char (20) NOT NULL DEFAULT '', Population int NOT NULL DEFAULT '0', PRIMARY KEY (ID), KEY CountryCode (CountryCode) ) ENGINE=InnoDB; You want to improve the performance of this query: SELECT Name FROM world.city WHERE Population BETWEEN 1000000 AND 2000000; Which change enables the query to succeed while accessing fewer rows?

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor. Using Query Analyzer, where do you begin to look for problem queries?

You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

Choose the best answer. Examine these commands, which execute successfully on the ic1 host: mysqlsh> dba.createCluster('cluster1', {memberWeight:35}) mysqlsh> var mycluster = dba.getCluster() mysqlsh> mycluster.addInstance ('ic@ic2', {memberWeight:25}) mysqlsh> mycluster.addInstance('ic@ic3', {memberWeight:50}) Now examine this configuration setting, which is the same on all nodes: group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER Which statement is true if primary node ic1 fails?

Choose the best answer. You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade. Examine the message sequence generated during the first start of MySQL 8.0.18: ... [System]... /usr/sbin/mysqld (mysqld 8.0.18-commercial) starting as process 2754 ... [System]... Starting upgrade of data directory. ... [ERROR]... Table upgrade required. Please do "REPAIR TABLE "columns_priv"" or dump/reload to fix it! ... [ERROR]... Table upgrade required. Please do "REPAIR TABLE "event"" or dump/reload to fix it! ... [ERROR]... Table upgrade required. Please do "REPAIR TABLE "proc"" or dump/reload to fix it! ... [ERROR]... Table upgrade required. Please do "REPAIR TABLE "proxies_priv"" or dump/reload to fix it! ... [ERROR]... Table upgrade required. Please do "REPAIR TABLE "tables_priv"" or dump/reload to fix it! ... [ERROR]... Failed to open mysql.event.Table. ... [ERROR]... Aborting ... [ERROR]... Failed to populate ID tables. ... [ERROR]... Fatal error: Can't open and lock privilege tables: Table 'mysql.columns_priv' doesn't exist ... [System]... /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-commercial) MySQL Enterprise Server - Commercial. Which step or set of steps will resolve the errors?

Choose the best answer. You plan to upgrade your MySQL 5.7 instance to version 8. You have installed the 8 build of MySQL Shell. Examine this command executed from the operating system shell prompt: mysqlsh --uri root@localhost:3306 -- util check-for-server-upgrade Which statement is true?

Database test contains a table named city that has the InnoDB storage engine. CREATE TABLE `city` ( `ID` int NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `CountryCode` (`CountryCode`) ) ENGINE=InnoDB TABLESPACE=innodb_file_per_table; What is the content of the test folder in the data directory?

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage () Reconfiguring the default cluster from complete outage... The instance 'host1:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N] : y The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N] : y Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?

Examine this partial report: mysql> SHOW FULL PROCESSLIST; +----+-----------------+-----------+ | Id | User | Host | +----+-----------------+-----------+ | 4 | event_scheduler | localhost | | 9 | root | localhost:51502 | | 10 | root | localhost:51670 | +----+-----------------+-----------+ Examine this query: SELECT SUM(m.CURRENT_NUMBER_OF_BYTES_USED) AS TOTAL FROM performance_schema.memory_summary_by_thread_by_event_name m INNER JOIN performance_schema.threads t ON m.THREAD_ID = t.THREAD_ID WHERE t.PROCESSLIST_ID = 10; What information does this query provide?

Choose the best answer. You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?

You must configure the MySQL command - line client to provide the highest level of trust and security when connecting to a remote MySQL Server. Which value of --ssl - mode will do this?

Choose the best answer. Which command enables rule - based MySQL Auditing capabilities?

You have a MySQL system with 500 GB of data that needs frequent backups. You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirements: - The MySQL system being backed up can never be unavailable or locked to the client applications. - The recovery from the backup must work on any system. - Only 1 hour of data can be lost on recovery of the backup. Which option fulfills all backup requirements?

You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation. Examine the output: # systemctl start mysqld Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. # systemctl status mysqld.service mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Thu 2019-12-12 07:54:53 ACDT; 33s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 2732 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE) Process: 2705 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 2732 (code=exited, status=1/FAILURE) Status: "Server startup in progress " Dec 12 07:54:49 oel7 systemd[1]: Starting MySQL Server... Dec 12 07:54:53 oel7 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE Dec 12 07:54:53 oel7 systemd[1]: Failed to start MySQL Server Dec 12 07:54:53 oel7 systemd[1]: Unit mysqld.service entered failed state. Dec 12 07:54:53 oel7 systemd[1]: mysqld.service failed. What statement is true about the start attempt?

You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

Examine these commands and output: mysql> SHOW FULL PROCESSLIST; [相关命令及输出内容] mysql> SELECT object_type, object_schema, object_name, lock_type, lock_status, owner_thread_id, owner_event_id -> FROM performance_schema.metadata_locks WHERE object_schema != 'performance_schema'; [相关命令及输出内容] mysql> SELECT thread_id, processlist_id, processlist_user, parent_thread_id -> FROM performance_schema.threads WHERE processlist_user='root'; [相关命令及输出内容] Which connection ID is holding the metadata lock?

Examine these commands and output: mysql> SHOW FULL PROCESSLIST; +----+----------------+-----------+-------------------+ | Id | User | State | Info | +----+----------------+-----------+-------------------+ | 6 | event_scheduler| Waiting on empty queue | NULL | | 20 | root |... | NULL | | 21 | root |... | Waiting for table metadata lock | optimize table test.demo_test | | 24 | root |... | Waiting for table metadata lock | select * from test.demo_test | | 25 | root | starting | SHOW FULL PROCESSLIST | +----+----------------+-----------+-------------------+ mysql> SELECT object_type, object_schema, object_name, lock_type, lock_status, owner_thread_id, owner_event_id -> FROM performance_schema.metadata_locks WHERE object_schema != 'performance_schema'; +-------------+--------------+--------------+-------------+-------------+----------------+----------------+ | OBJECT_TYPE | OBJECT_SCHEMA| OBJECT_NAME | LOCK_TYPE | LOCK_STATUS | OWNER_THREAD_ID| OWNER_EVENT_ID | +-------------+--------------+--------------+-------------+-------------+----------------+----------------+ | TABLE | test | demo_test | SHARED_READ | GRANTED | 60 | 7 | | TABLE | test | demo_test | INTENTION_EXCLUSIVE | GRANTED | 62 | 6 | | SCHEMA | test | NULL | INTENTION_EXCLUSIVE | GRANTED | 62 | 6 | | TABLE | test | demo_test | SHARED_NO_READ_WRITE | PENDING | 62 | 6 | +-------------+--------------+--------------+-------------+-------------+----------------+----------------+ mysql> SELECT thread_id, processlist_id, processlist_user, parent_thread_id -> FROM performance_schema.threads WHERE processlist_user='root'; +-----------+----------------+----------------+------------------+ | THREAD_ID | PROCESSLIST_ID | PROCESSLIST_USER | PARENT_THREAD_ID | +-----------+----------------+----------------+------------------+ | 60 | 20 | root | NULL | | 61 | 21 | root | NULL | | 62 | 22 | root | 1 | | 64 | 24 | root | 1 | | 65 | 25 | root | NULL | +-----------+----------------+----------------+------------------+ Which connection ID is holding the metadata lock?