908-test1

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose two.
You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql] innodb_data_file_path=
Which two configurations would satisfy long-term storage demands?

choose two.
Which two are true about differences between logical and physical upgrades of MySQL databases?

Choose two.
Which two methods can be used to determine whether a query uses the hash join algorithm?

Choose two.
Examine this statement, which executes successfully:
CREATE USER mary@192.0.2.100 IDENTIFIED BY 'P@SSw0rd' REQUIRE NONE PASSWORD EXPIRE;
Which two are true?

Choose two.
Which two are true about binary logs used in asynchronous replication?

After installing MySQL 8.0 on Oracle Llinux 7, you initialize the data directory with the mysqld --initialize command.

Which two will assist in locating the root password ?

You have appropriate privileges and are about to shut down a running MySQL server process on Oracle Linux 7.

Which three are valid methods that will shut down the MySQL server?

choose two
You are attempting to start your mysqld.
Examine this log output:
（含图）
Which two things must you check?

choose three
Which three methods are part of a 'scale up' approach to capacity planning?

choose two
You want to install and configure MySQL on Linux server with tarball binaries in the /app/mysql/directory, where the bin directory is found at /app/mysql/bin and the data directory at /app/data.
Which two parameters are required to configure the MySQL instance?

choose two
Which two can minimize security risks when creating user accounts?

choose two
Which two are valid uses for binary logs on a MySQL instance?

choose two
The replication for master and slave MySQL Servers is up and running. The disk space occupied by the binary log files continues to grow.
Which two methods manage this issue?

choose two
Table t is an InnoDB table. Examine these statements and output:
Selet count(1) from t;
±-----------+
| count(1) |
±-----------+
| 72 |
±-----------+
Mysql show indexes from t\G
-----------1.row-------------
Table: t
Non_unique:0
Key_name:PRIMARY
Seq_in_index: 1
Column_name: a
Collation:A
Cardinality: 72
Sub_part:NULL
Packed:NULL
Null:
Index_type:STREE
Comment: Index_comment:
Visible:YES
Expression:NULL
-----------------2.row-----------------
Table: t
Non_unique:1
Key_name:b_idx
Seq_in_index: 1
Column_name: b
Collation:A
Cardinality: 1
Sub_part:NULL
Packed:NULL
Null:YES
Index_type:BTREE
Comment:
Index_comment:
Visible:NO – 不可见索引
Expression:NULL
2 row in set (0.00 sec)
Which two are true?

choose two
Which two situations will cause the binary log to rotate?

更多题库