移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

多选题 In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;

A

$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

B

Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'

C

$ mysql – u root – p – h localhost test < /tmp/t1.sql

D

Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1

E

$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

多选题 Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log: Which two points can be concluded from the given event?()

A

A connection as the user kate was successful

B

A connection failed due to authentication being unsuccessful

C

A connection was attempted via socket rather than TCP

D

A connection was blocked by a firewall or a similar security mechanism

E

A connection failed because the proxy user privileges did not match the login user

多选题 What are three facts about backups with mysqldump?()

A

Can back up a remote database server

B

Allow a consistent backup to be taken

C

Are always faster to restore than binary backups

D

Are able to back up specific items within a database

E

Create automatically compressed backups

F

Will lock all storage engines for duration of backup

多选题 You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?()

A

Shell> mysqladmin –u root –p shutdown

B

Shell> nmc mysql shutdown

C

Mysql> STOP PROCESS mysqld

D

Shell> /etc/init.d/mysql stop

E

Shell> service mysql safe_exit

F

Shell> pkill –u mysql mysqld_safe

G

Shell> net stop mysql

单选题 Consider the query: Mysql> SET @run = 15; Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation WHERE run=@run AND objective=’7.1’ GROUP BY objective,stage ORDER BY stage; The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation: This query is run several times in an application with different values in the WHERE clause in a growing data set. What is the primary improvement that can be made for this scenario?()

A

Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes

B

Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations

C

Drop the run_2 index because it has caused a conflict in the choice of key for this query

D

Execute the run_2 index because it has caused a conflict in the choice of key for this query

E

Add a composite index on (run,objective,stage) to allow the query to fully utilize an index

多选题 Which two requirements would lead towards a high availability solution?()

A

When uptime is critical

B

When data must be refactored

C

When application concurrency is static

D

When data loss is unacceptable

E

When application is a single point of failure

多选题 Which two events will cause a slave server to create a new relay log file?()

A

Execution of the FLUSH LOGS statement

B

Starting of the SQL thread

C

Reaching the slave_pendign _jobs_size_max limit

D

Execution of FULSH TABLES WITH READ LOCK

E

Starting of the I/O thread

多选题 Which two statements describe the behavior of the server's SQL mode?()

A

The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

B

The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

C

The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

D

The server's SQL mode, when globally set on a slave server, applies to events sent from the master

多选题 Which two capabilities are granted with the SUPER privilege?()

A

Allowing a client to kill other client connections

B

Allowing a client to shut down the server

C

Allowing change of the server runtime configuration

D

Allowing client accounts to take over the account of another user

最新资讯

首页 上一页 1 2 3 4 5 尾页 /

到第