【英文】Oracle认证 MySQL OCP 1Z0-908 题库 | 最新真题 | 覆盖全考点 | 包更新

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which two are features of MySQL Enterprise Firewall? (Choose two.)

Examine this MySQL client command to connect to a remote database: mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

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?

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

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

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

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

Examine this statement, which executes successfully:
（含图）
You want to improve the performance of this query:
（含图）
Which change enables the query to succeed while accessing fewer rows?

Which three are characteristics of a newly created role? (Choose three.)

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:
（含图）
You plan to add this parameter to the configuration:
innodb_directories=’/innodb_extras’
Which statement is true?

Examine this command and output:
（含图）
Which two statements are true? (Choose two.)

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:
（含图）
What is the reason for the error?

Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

Examine these statements and output:
（含图）
Which statement is true?

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)

Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

Examine these entries from the general query log:
（含图）
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

更多题库