移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()

A

It implements High Availability by using the .NET Connector's' load balancing capabilities

B

It is shared-nothing architecture

C

It is provided by means of IP- level disk replication

D

It relies on the shared disk architecture being visible to both servers

多选题 You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()

A

Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files

B

Execute the PURGE BINARY LOGE NOT USED command

C

Remove all of the binary log files that have a modification date earlier than today

D

Edit the .index file to remove the files you want to delete

E

Ensure that none of the attached slaves are using any of the binary logs you want to delete

多选题 Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?()

A

Both technologies guarantee an identical copy of data on the secondary node

B

Only MySQL can maintain a time-delayed copy of data on the secondary node

C

Both technologies use the TCP/IP stack as their primary transmission medium

D

DRBD uses shared-disk technology

单选题 You have enabled the Slow Query Log for a short period. When you process the Slow Query Log, you receive the following snip of output: Count: 100 Time=0 .22a (22s) Lock=0.00s (0s) Rows=0.0 (0), root[root] @localhost CREATE TABLE 't1' (id serial,id0 varchar(N) unique key,intcaoll INT (N) ,intco12 INT(N) ,intco13 INT(N) ,intco14 INT(N) ,intco15 INT(N) ,charcol1 VARVHAR(N) ,charcol2 VARCHAR(N) charcol3 VARCHAR (N) ,charcol4 VARVHAR(N) ,charcol5 VARCHAR(N) charcol6 VARCHAR (N) ,charcol7 VARVHAR(N) ,charcol8 VARCHAR(N) charcol9 VARCHAR (N) .charcol 10 VACHAR (N) ) Count: 64000 Time-0.02s (1213s) Lock=0.00s (6s) Rows=1.0 (64000), root [root]@ localhost SELECT intocl1, intco12, intco13, intco14, intco15, intco16,intco17, intco18 ,intcol9, intcol10, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6 ,charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=1.0 (1) agent [agent] @localhost SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user, 's', host) = CURRENT_USER ( ) Count: 48000 Time=0.02s (778s) Lock=0.00 (3s) Rows=1.0 (48000), root[root]@localhost SELECT intocl1,intcol2,intcol3, intcol4, intcol5, charcol1, charcol2, charcol3 ,charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' You want to tune the query such that it provides the greatest overall time savings. Which query will accomplish this?()

A

CHEATE TABLE 't1' (id serial, id0 varchar (N) unique key, intcol1 INT (N) ,intcol2 INT (N), intcol3 INT(N) ,intcol4 INT(N), intcol5 INT(N), charool1 VARCHAR (N) ,charcol2 VARCHAR (N), charcol3 VARCHAR(N), charcol4 VARCHAR(N), charcol5 VARCHAR (N) ,charcol6 VARCHAR (N), charcol7 VARCHAR(N), charcol8 VARCHAR(N), charcol9 VARCHAR (N) ,charcol10 VARCHAR (N)

B

SELECT intcol1, intcol2, intcol3, intcol4, intcol5, intcol6, intcol7, intcol8, intcol9, Intcol10, intcol11, intcol12, intcol13, intcol14, intcol15, intcol16, intcol17, intcol18, intcol19, charcol10 FROM t1 WHERE id = 's'

C

SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user,'s', host) = CURRENT_USER()

D

SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'

多选题 Which three data components are needed for point-in-time recovery?()

A

The error log

B

The backup log

C

The general query log

D

Binary logs

E

The data backup

F

Configuration files

多选题 Which three tasks can be performed by using the performance Schema?()

A

Finding queries that are not using indexes

B

Finding rows that are locked by InnoDB

C

Finding client connection attributes

D

Finding the part of a code in which a single query is spending time

E

Finding the size of each table

多选题 You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?()

A

Each extra column in the copy with more columns must not have a default value

B

Columns that are common to both versions of the table must be defined in the same order on the master and the slave

C

The slave database cannot have more columns than the master. Only the master database can have more columns

D

Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

E

The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

最新资讯

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

到第