Which two commands will display inde

多选题 Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

A、 DESCRIBE manufacturing.parts;

B、 SELECT ∗ FROM information_schema. statistics WHERE table_schema=' manufacturing' AND TABLE_ NAME=' Parts' ;

C、 SHOW INDEXES FROM manufacturing.parts;

D、 SELECT ∗ FROM information_schema. COLUMN_STATISTICS;

E、 EXPLAIN SELECT INDEXES FROM manufacturing. parts ;

查看答案

下载APP答题

由4l***b2提供分享举报纠错

相关试题

单选题 Examine this command: Shell> mysqldump --no-create-info --all-databases --result-file=dump.sql Which statement is true?

A、It will not write CREATE TABLESPACE statements.

B、It will not write CREATE LOGFILE GROUP statements.

C、It will not write CREATE TABLE statements.

D、It will not write CREATE DATABASE statements.

查看答案

单选题 Examine this command, which executes successfully:mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-andapply-log Which statement is true?

A、The backup accesses the MySQL server files by using a pre-existing connection.

B、The database server is put into a read-only state for the duration of the backup.

C、An offline backup of InnoDB tables is taken.

D、The backup can be impacted when DDL operations run during the backup.

查看答案

单选题 Examine the command, which execute successfully:

Shell> mysqld --initialize-insecure

Which statement is true?

A、

The installation creates a temporary test environment with data in the /tmp directory.

B、

The installation is created without enforcing or generating SSL certificates.

C、

The root password is created in the error log in plain text.

D、

The root password is not created allowing easy access from the same host.

查看答案

单选题 You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:

Mysql>SHOW GLOBAL VARIABLES

WHERE Varisble_name=’tmpdir ‘

OR Variable_name =’ tmp_table_size;

+------------------+-----------+

| Variable_name |Value |

+------------------------+-----+

|tmp_tabe_size | 16777216|

|tmpdir | /tmp |

+-------------------+----------+

Shell>cd/var/lib/mysql

Shell>ls -1|grep temp

Drwxr-x---.2 mysql mysql 4096 Dec 11 14:05 #innodb_temp

Which statement is true about disk temporary tables for this installation?

A、

Temporary tables are created in tmpdir only if configured to use MyISAM。

B、

Temporary tables are created in tmpdir only after they reach tmp_table_size.

C、

Temporary tables will use the InnoDB temporary tablespace located in datadir.

D、

Only internal temporary tables from the optimizer will be created in tmpdir.

E、Temporary tables will use the InnoDB temporary tablespace located in /tmp.

查看答案

单选题 The mysqld instance has the connection control plugin enabled with these settings:

Connection_control_min_connection_delay=1000

Connection_control_max_connection_delay=2000

The minimum and maximum delays need to be increased to 3000 and 5000, respectively.A command is executed:

mysql> SET GLOBAL connection_control_min_connection_delay=3000;

What is the result?

A、

The minimum connection value is changed to 2000.

B、

Only the minimum connection value is increased to 3000.

C、

The minimum value increases to 3000 and the maximum value increases to 4000.

D、

An error is returned.

查看答案

单选题 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?

A、error log

B、slow query log

C、general query log

D、binary log

E、audit log

查看答案

单选题 You reconfigure and start a slave that was not replicating for several days.The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave: Master: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321, Bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100, Bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Slave: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Which statement is true?

A、Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbbbbbb GTIDs in its binary logs.

B、Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc-cccc-cccccccccc GTIDs.

C、Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

D、Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.

E、Replication will work.

查看答案

单选题 A developer accidentally dropped the InnoDB table Customers from the Company database. There is a datadir

Copy from two days ago in the dbbackup directory.

Which set of steps would restore only the missing table?

A、

Stop the MySQL Server process, and execute: Mysqlbackup --datadir=/var/lib/mysql --backup-dir=/dbbackup --include-tables='Company\.Customers' copy-back Start the mysqld process.

B、

Stop the MySQL Server process and restart it with the command: mysqld --basedir=/usr/local/mysql -- Datadir=/var/lib/mysql Run mysqldump on this table and restore the dump file.

C、

Stop the MySQL Server process and restart it with the command: mysqld --basedir=/usr/local/mysql -- Datadir=/dbbackup Run mysqldump on this table and restore the dump file.

D、

Stop the MySQL Server process, copy the Customers.ibd file from the dbbackup directory, and start the mysqld Process.

查看答案