Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 81:

  Which of the following best describe the effects on performance for the dynamic-row format for MyISAM has?

  A. Retrievals are more complex and slower.
  B. Retrievals are less complex and are faster.
  C. Rows generally take up less disk space than fixed-row format.
  D. Rows generally take up more disk space than fixed-row format.
  B. Retrievals are less complex and are faster.

• Question 82:

  Which of the following statements are true of compressed tables?

  A. They can be uncompressed.
  B. They can not be uncompressed.
  C. They can be uncompressed but some data corruption may occur.
  A. They can be uncompressed.

• Question 83:

  In regards to security, which of the following statements are true?

  A. mysqld should not be run as root or administrator.
  B. mysqld should be run as root or administrator.
  C. The user owning the server process should own all files and directories to which the server may write.
  D. The root or admininistrator users should own all files related to the server process
  A. mysqld should not be run as root or administrator.

• Question 84:

  Why should you be selective when granting the PROCESS privilege to an account?

  A. Because it allows the client to control running processes on the server.
  B. Because it allows the client to process scripts.
  C. Because it allows for the use of the SHOW PROCESSLIST command, which can expose data.
  D. Because it allows for the use of stored routines.
  C. Because it allows for the use of the SHOW PROCESSLIST command, which can expose data.

• Question 85:

  Which of the following disk characteristics are most important to a database server and why?

  A. Disk size, because a database needs a lot of storage space.
  B. Transfer rate, because the database needs to be able to transfer the data off the disks at a very high rate.
  C. Disk seek time, because it is more important for the heads of the disk to move quickly from track to track.
  C. Disk seek time, because it is more important for the heads of the disk to move quickly from track to track.

• Question 86:

  Privileges for using stored routines can be specified at the following levels:

  A. Server-wide
  B. Per database
  C. Per routine
  D. The ability to use stored procedures is not governed by the privilege system.
  A. Server-wide
  B. Per database
  C. Per routine

• Question 87:

  Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using where Which of the following best describes the meaning of the "id" column in the output from EXPLAIN?

  A. Which process it is running as.
  B. Which SELECT the row refers to.
  C. It is just an incremental number to identify the rows from the output.
  C. It is just an incremental number to identify the rows from the output.

• Question 88:

  Which of the following best describes how the relay log works?

  A. It records the times when the slave connects to the master.
  B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
  C. When a slave receives a change from the master, it is processed first and then recorded in the relay log.
  B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.

• Question 89:

  Which of the following best describes what mysqldumpslow does and how to use it?

  A. It shows a summary of the slow log contents.
  B. It dumps the contents of the slow log into a readable format.
  C. shell> mysqldumpslow log_name
  D. shell> mysqldumpslow < log_name
  B. It dumps the contents of the slow log into a readable format.

• Question 90:

  Is it ever safe to start the MySQL server as root?

  A. No it is never safe to start it as root.
  B. Yes it is always safe to start it as root.
  C. Yes provided you make it switch the effective user to mysql.
  D. No because you can not make it switch the effective user if started as root.
  C. Yes provided you make it switch the effective user to mysql.