Free Oracle 1z0-883 Exam Dumps Questions & Answers

Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?

• A.  Check the command-line options provided for the Mysql Server and compare them with default values.
• B.  Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
• C.  Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
• D.  Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

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.  Use of delay_key_write=ON for batch index update
• B.  Allocation of RAM to the buffer pool such that more of the data can fit in RAM
• C.  Placement of InnoDB log files and datadir on separate physical disks
• D.  Use of soft links for database directories on the same physical disk
• E.  Use of separate directories on the same physical disk for log files and data files

You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?

• A.  Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'
• B.  Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.
• C.  Restore the backup to another databases instance and obtain a copy of the reports table individually.
• D.  Extract the 'apps' . 'reports' table from the backup using the SOURCE command.

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

• A.  DRBD uses shared-disk technology.
• B.  Both technologies guarantee an identical copy of data on the secondary node.
• C.  Both technologies use the TCP/IP stack as their primary transmission medium.
• D.  Only MySQL can maintain a time-delayed copy of data on the secondary node.

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.