1z1-883 by Oracle Actual Free Exam Questions And Answers

Question 1

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

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

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

C. DRBD uses shared-disk technology.

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

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'.
Query: 'insert into mytable VALUES ('8' , 'George') '
Skip_Counter: 0
Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8
Auto _Position: 1
You execute a "SHOW CREATE TABLE mytable" on the slave:
CREATE TABLE 'mytable' (
'ID' int(11) NOT NULL DEFAULT '0',
'name' char(10) DEFAULT NULL,
PRIMARY KEY ('ID')
)
The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.
Which statement should be used?

A. SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";

B. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT=" AUTOMATIC';

C. SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";

D. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

E. SET GLOBAL enforce_gtid_consistency=ON

Discussion 0

Correct Answer: D Vote an answer

Question 3

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
[mysqld] Loq-bin Binrylog_format=ROW
You do not notice the spelling error in binrylog_format and restart your production server.
How does the MySQL server behave with incorrectly spelled options?

A. Mysqld uses internal configuration versioning and reverts to the previous configuration.

B. When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C. Mysqld prints to the error log about an unknown variable, and then exits.

D. The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

Discussion 0

Correct Answer: C Vote an answer

Question 4

You are investigating the performance of the server and see the following information:
-Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
-The table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?

A. Decrease the value of table_definition_cache.

B. Increase the value of table_definition_cache.

C. Decrease the value of table_open_cache.

D. Decrease the value of table_open_cache_instances.

E. Increase the value of table_open_cache.

F. Increase the value of table_open_cache_instances.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1 Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?

A. Placement of InnoDB log files and datadir on separate physical disks

B. Use of separate directories on the same physical disk for log files and data files

C. Use of soft links for database directories on the same physical disk

D. Allocation of RAM to the buffer pool such that more of the data can fit in RAM

E. Use of delay_key_write=ON for batch index update

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Mysqldump was used to create a single schema backup;
Shell> mysqldump -u root -p sakila > sakila2013.sql
Which two commands will restore the sakila database without interfering with other running database?

A. Shell> mysql -u root -p -e 'use sakila; source sakila2013.sql'

B. Shell> mysql -u root -p sakila <sakila2013.sql

C. Shell> mysqlimport -u root -p sakila sakila2013.sql

D. Shell> mysql -u root -p -silent < sakila2013.sql

E. Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

Which three methods will show the storage engine for the Country table?

A. SHOW TABLE STATUS LIKE 'Country';

B. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Country';

C. SHOW CREATE TABLE Country;

D. SHOW ENGINE Country STATUS;

E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= 'Country';

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 8

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. Edit the .index file to remove the files you want to delete.

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

D. Execute the PURGE BINARY LOGE NOT USED command.

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

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

A. It is shared-nothing architecture.

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

C. It is provided by means of IP- level disk replication.

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

Discussion 0

Correct Answer: D Vote an answer

Question 10

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

A. If no indexes exist, a hidden clustered index is generated based on row IDs.

B. A clustered index allows fulltext searching within InnoDB,

C. A primary key is used as a clustered index.

D. A clustered index is a grouping of indexes from different tables into a global index for faster searching.

E. A clustered index provides direct access to a page containing row data.

F. The first unique index is always used as a clustered index and not a primary key.

G. A primary key must exist for creation of a clustered index.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle MySQL 5.6 Database Administrator - 1z1-883 Exam Practice Test

Contact Us

Useful Links

Latest Updated