Oracle Oracle Certifications 1Z0-883 Questions & Answers

• Question 71:

  Which two statements are true regarding partitioning in Mysql?

  A. Tables with BLOB and TEXT columns cannot be partitioned.

  B. Partitioning allows easier management of smaller data sets for certain queries.

  C. Partitioning allows different columns to be stored in separate files.

  D. The partitioning expression is an integer or function that returns an integer value or NULL value.

  E. Partitioning is only available for those storage engines that implements it natively.

  Correct Answer: CD

• Question 72:

  You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb- ccc-ddd-eee : 3 on a slave.

  Which command would you execute from a Mysql prompt?

  A. STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE

  B. STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

  C. STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE;

  D. STOP SLAVE;

  RESET SLAVE;

  BEGIN;

  SKIP NEXT GTID;

  COMMIT;

  START SLAVE;

  Correct Answer: B

• Question 73:

  You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.

  Which statement will accomplish this?

  A. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST='192.168.1.15';

  B. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';

  C. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';

  D. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

  Correct Answer: C

• Question 74:

  Identify a performance impact when using the Performance Schema.

  A. There is no impact on performance.

  B. There is an overhead for querying the Performance Schema but not for having it enabled.

  C. There is a constant overhead regardless of settings and workload.

  D. The overhead depends on the settings of the Performance Schema.

  Correct Answer: B

• Question 75:

  In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?

  A. Disk usage when storing data

  B. Syntax when writing queries involving JOINS

  C. Comparing the encoded data with similar columns on other tables

  D. Memory usage when working with the data

  E. Character set mapping index hash size

  Correct Answer: CDE

• Question 76:

  What are three actions performed by the mysql_secure_installation tool?

  A. It prompts you to set the root user account password.

  B. It checks whether file permissions are appropriate within datadir.

  C. It asks to remove the test database, which is generated at installation time.

  D. It can delete any anonymous accounts.

  E. It verifies that all users are configuration with the longer password hash.

  Correct Answer: ACD

• Question 77:

  Consider the query:

  Mysql> SET @run = 15;

  Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation

  WHERE run=@run AND objective='7.1'

  GROUP BY objective,stage

  ORDER BY stage;

  

  The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation:

  

  This query is run several times in an application with different values in the WHERE clause in a growing data set.

  What is the primary improvement that can be made for this scenario?

  A. Execute the run_2 index because it has caused a conflict in the choice of key for this query.

  B. Drop the run_2 index because it has caused a conflict in the choice of key for this query.

  C. Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.

  D. Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.

  E. Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

  Correct Answer: B

• Question 78:

  Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?

  A. Mysql Replication

  B. Distributed Replicated Block Device (DRBD) and Mysql

  C. Windows Cluster and Mysql

  D. Solaris Cluster and Mysql

  E. Mysql NDB Cluster

  Correct Answer: ACD

• Question 79:

  Which three statements are characteristic of the MEMORY storage engine?

  A. Each table is represented on disk as an.frm file.

  B. Each table has a corresponding.MYI and .MYD file.

  C. It can support foreign keys.

  D. It cannot contain text or BLOB columns.

  E. Table contents are not saved if the server is restarted.

  F. It can support transactions

  Correct Answer: ADE

• Question 80:

  Consider the Mysql Enterprise Audit plugin.

  The following event detail is found in the audit log:

  CONNECTION_ID=”3”

  STATUS=”1045” USER=”kate” PROXY_USER=”” HOST=”localhost” IP=”” DB=””/>

  Which two points can be concluded from the given event?

  A. A connection was blocked by a firewall or a similar security mechanism.

  B. A connection was attempted via socket rather than TCP.

  C. A connection failed because the proxy user privileges did not match the login user.

  D. A connection as the user kate was successful.

  E. A connection failed due to authentication being unsuccessful.

  Correct Answer: BD