Oracle认证考试1z0-883章节练习(2019.03.21)

多项选择题
Which three statements are characteristic of the MEMORY storage engine?（）
A.It can support transactions
B.Table contents are not saved if the server is restarted
C.It cannot contain text or BLOB columns
D.It can support foreign keys
E.Each table is represented on disk as an.frm file
F.Each table has a corresponding.MYI and .MYD file
多项选择题
Which two are true regarding MySQL binary and text backups?（）
A.Binary backups are usually faster than text backups
B.Binary backups are usually slower than text backups
C.Text backups are human-readable while binary backups are not
D.Binary backups are not portable across different operating systems
多项选择题
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.Which two changes would ensure that the temporary table does not propagate to the slave?（）
A.Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B.Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C.Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D.Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E.Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
多项选择题
Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）
A.Mysql NDB Cluster
B.Mysql Replication
C.Distributed Replicated Block Device (DRBD) and Mysql
D.Windows Cluster and Mysql
E.Solaris Cluster and Mysql
多项选择题
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）
A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup
多项选择题
Which three are properties of the MyISAM storage engine?（）
A.Transaction support
B.FULLTEXT indexing for text matching
C.Table and page level locking support
D.Foreign key support
E.Geospatial indexing
F.HASH index support
G.Table level locking only
多项选择题
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
单项选择题
You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment.You execute this command:$mysql_config_editor print –login-path=adamlocal What is the expected output of this command?（）
A.The command prints all parameter for the login-path. The password is replaced with stars
B.The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists
C.The command prints all parameters for the login-path. The password is shown only when you provide the –password option
D.The command prints all parameters for the login-path. The password is printed in plain tex
单项选择题
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）
A.The snapshot size will continue to grow as changes to the volume are made
B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D.The system keeps a copy of changes in memory and can cause an out of memory event
单项选择题
Your developers have created table to store some of their program's data.After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…'What should you do to improve the overall performance?（）
A.Convert the column to TEXT and add a fulltext index to the table
B.Create multiple prefix indexes of differing lengths
C.Convert their column to BINARY
D.Redesign the table so that the most commonly searched for string patterns are in their own columns