Oracle 1Z0-888 Online Practice Questions and Exam Preparation

Oracle 1Z0-888 Online Questions & Answers

• Question 91:

  You are looking at these details:

  

  Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?

  A. The Event Schedular is not enabled on the slave host.
  B. The slave is waiting for an event to come into the relay log.
  C. The slave thread is waiting for another event to finish in another slave thread.
  D. The binary log on the master is not being updated.
  A. The Event Schedular is not enabled on the slave host.

  ---

  Explanation Explanation/Reference: https://jira.mariadb.org/browse/MDEV-15426

• Question 92:

  The `applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored. You investigate and gather this information:

  

  Three tables are stored in the InnoDB shared tablespace and the details are as follows:

  The table data_current has 1,000,000 rows. The table data_reports has 1,500,000 rows. The table data_archive has 4,500,000 rows.

  

  You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.

  

  Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out. Which set of actions will allow you to free disk space back to the file system?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

  ---

  Explanation Explanation/Reference:

• Question 93:

  Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

  A. executing REVOKE LOAD FROM *.*
  B. setting the --local-service=0 option when starting mysqld
  C. executing REVOKE FILE FROM *_*
  D. executing REVOKE FILE ON *_* FROM ` `@'%'
  E. setting the --local-infile=0 option when starting mysqld
  F. setting the --open-files-limit=0 option when starting mysqld
  F. setting the --open-files-limit=0 option when starting mysqld

• Question 94:

  What is the order of tables shown in an EXPLAIN output?

  A. It lists tables from the smallest to the largest.
  B. It lists tables in the order in which their data will be read.
  C. It lists tables from the most optimized to the least optimized.
  D. It lists tables in the order in which they are specified in the statement that is being explained.
  D. It lists tables in the order in which they are specified in the statement that is being explained.

  ---

  https://dev.mysql.com/doc/refman/8.0/en/explain-output.html

• Question 95:

  Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

  A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
  B. All MySQL client programs and connectors can be used for executing queries.
  C. It provides fully synchronous replication between the nodes.
  D. There is support for automatic failover when one node fails.
  E. The data is automatically shared between the nodes.
  F. Each query will be executed in parallel across the nodes.
  B. All MySQL client programs and connectors can be used for executing queries.
  D. There is support for automatic failover when one node fails.
  F. Each query will be executed in parallel across the nodes.

• Question 96:

  To query two system variables, you execute this statement and get the results shown:

  

  When you execute the following two statements, only the first one succeeds:

  SET @@autocommit=0;

  SET @@max_connections=200;

  Why does the second statement fail?

  A. max_connections is a read-only variable that cannot be set dynamically.
  B. max_connections must be set globally instead of locally.
  C. max_connections is a derived variable that can only be set indirectly.
  D. max_connections must be set at server start in an options file.
  D. max_connections must be set at server start in an options file.

  ---

  Explanation Explanation/Reference:https://books.google.com.pk/books?id=N4KzO2Tih98Candpg=PA385andlpg=PA385anddq=max_connections+must+be+set+at+server+start+in+an+options+file.andsource=blandots=KvEbu8PbDOandsig=ACfU3U1v48_bQW7O0JIjzTJ6NmL6bVsfwandhl=enandsa=Xandved=2ahUKEwj5x9iU5KfpAhXX3YUKHUlQCd8Q6AEwA3oECAgQAQ#v=onepageandq=max_connections%20must%20be%20set%20at%20server%20start%20in%20an%20options%20file.andf=false

• Question 97:

  A MySQL replication slave is set up as follows:

  Uses all InnoDB tables Receives ROW-based binary logs Has the read-only option

  The replication slave has been found in an error state. You check the MySQL error log file and find these entries:

  

  What are two possible causes for this error to occur? (Choose two.)

  A. The applications have the SUPER privilege, which allows them to update rows.
  B. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
  C. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
  D. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql
  E. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.
  C. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
  D. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql

• Question 98:

  Which statement describes how the relay log works?

  A. when a slave receives a change from the master, it is processed first, and then recorded in the relay log.
  B. It maintains a record of available master binary logs and the current executed log position.
  C. It stores changes on the master, and relays them to the slave.
  D. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
  B. It maintains a record of available master binary logs and the current executed log position.

• Question 99:

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

  A. It relies on the shared disk architecture being visible to both servers.
  B. It is provided by means of IP-level disk replication.
  C. It implements High Availability by using the .NET Connector's load balancing capabilities.
  D. It is a shared-nothing architecture.
  A. It relies on the shared disk architecture being visible to both servers.

• Question 100:

  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? (Choose two.)

  A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
  B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
  C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
  D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
  E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
  B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
  E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.