Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 71:

  Why is --bind-address an important security option?

  A. On a server with multiple network interfaces, you can have mysqld accept connections only on the given interface.

  B. mysqld will only accept connections from the given address.

  C. mysqld will turn off networking and will only accept local connections

  D. mysqld won't accept any connections at all.

  Correct Answer: A

• Question 72:

  Connection strings in FEDERATED tables are stored...

  A. In variables.

  B. Within the table definition.

  C. In a .fed file corresponding to the table.

  D. They are not stored, but must be re-specified at server restart.

  Correct Answer: B

• Question 73:

  To prevent users from seeing the password used for FEDERATED tables, you should...

  A. not grant them privileges to execute SHOW CREATE TABLE for this table.

  B. not grant them privileges to execute SHOW CONNECTION for this table. C. not grant them privileges to execute SHOW TABLE STATUS for this table.

  C. not grant them privileges to execute SHOW CONNECTION STRING for this table.

  Correct Answer: C

• Question 74:

  Which of the following statements are true regarding the structure of grant tables in new distributions?

  A. They change with every upgrade.

  B. They are often changed.

  C. They remain the same for backwards compatibility.

  Correct Answer: B

• Question 75:

  How can the strict SQL mode provide added security?

  A. By restricting out of range values.

  B. By restricting incorrect data types.

  C. By limiting the operations that the server can perform.

  D. By rejecting actions that do not have values for columns without a default.

  Correct Answer: D

• Question 76:

  Is it possible to tell the MySQL server to throw an error on division-by-zero rather than converting it to NULL and a warning?

  A. No, it has to be done programmatically.

  B. Yes, by updating a system variable.

  C. Yes, there is a SQL mode that exists for that.

  D. No, division-by-zero is always converted regardless of any setting.

  Correct Answer: C

• Question 77:

  Is it possible to tell the MySQL server to throw an error on illegal dates rather than converting it to zero-date or legal dates?

  A. Yes, by updating a system variable.

  B. No, it has to be done programmatically.

  C. Yes, there is a SQL mode that exists for that.

  D. No, all illegal date are converted regardless of any setting.

  Correct Answer: C

• Question 78:

  Which of the following best describes how the binary log might be helpful in query optimization?

  A. By checking which queries it logs as slow.

  B. By checking the processor load it records when a query is executed.

  C. By identifying the WHERE clauses in queries for which indexes might be useful.

  Correct Answer: C

• Question 79:

  Which of the following statements are true regarding the slow query log?

  A. The slow query log can be switched on with the log_slow_queries option.

  B. The slow query log is always enabled.

  C. The slow query log contains queries that don't utilize any index.

  D. To have the slow query log contain queries that don't utilize any index, the log-queries-not- using-indexes option needs to be set.

  E. The slow query log will contain queries that take more than 10 seconds.

  F. The slow query log will contain queries that take more seconds than configured in the long_query_time option.

  G. You can use the mysqldumpslow command line tool to summarize the content of the slow query log.

  H. You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.

  Correct Answer: ABFH

• Question 80:

  Should all queries in the slow query log be optimized?

  A. Yes.

  B. Yes, unless they depend on tables in the mysql database

  C. No; A query may have been entered into the slow query log because other, slow queries, prevented it from executing quickly

  D. No; Queries that are run rarely are probably not worth the effort of optimization

  E. No; Only the very slowest queries should be optimized

  Correct Answer: ACE