Oracle Oracle Database 1Z0-888 Questions & Answers

• Question 11:

  You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.

  Why is it important to remove snapshots after completing a raw backup in this way?

  A. The snapshot size will continue to grow as changes to the volume are made.

  B. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.

  C. The snapshots take a significant amount of disk space because they are a duplicate copy of the data.

  D. The system keeps a copy of changes in memory and can cause an out-of-memory event.

  Correct Answer: C

• Question 12:

  Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

  A. mysqld_safe

  B. mysql_config_editor

  C. mysqladmin

  D. mysqlpasswd

  Correct Answer: B

  The obfuscation used by mysql_config_editor prevents passwords. Reference: https://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html

• Question 13:

  At which stage during query processing does MySQL create a query's execution plan?

  A. Optimizing

  B. Parsing

  C. Executing

  D. Authorizing

  Correct Answer: A

  Reference: https://dev.mysql.com/doc/refman/8.0/en/execution-plan-information.html

• Question 14:

  You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.

  Which three statements are true? (Choose three.)

  A. The performance impact is less than SHOW FULL PROCESSLIST.

  B. The PROCESS privilege is required.

  C. The events_statements_current consumer must be enabled.

  D. A connection must be instrumented to be included in the list of processes.

  E. The sys.session view provides the process list with additional information.

  F. The threads table contains all the required columns.

  Correct Answer: BCF

  The PROCESS privilege also enables use of SHOW ENGINE.

  The threads table columns with names having a prefix of PROCESSLIST_ provide information similar to

  that available from the INFORMATION_SCHEMA.PROCESSLIST table or the SHOW PROCESSLIST

  statement.

  Reference: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html

  https://www.percona.com/blog/2015/10/01/capture-database-traffic-using-performance-schema/

  https://dev.mysql.com/doc/mysql-perfschema-excerpt/5.7/en/threads-table.html

• Question 15:

  The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4. Which backup method would you use to reload the corrupted InnoDB tables?

  A. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

  B. A text backup. A binary backup will still contain the corrupted segments.

  C. A text backup. InnoDB does not allow you to make binary backups while the server is running.

  D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

  Correct Answer: C

  An innodb_force_recovery setting of 4 or greater places InnoDB in read-only mode. Reference: https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html

• Question 16:

  Which statement best describes a "warm" backup?

  A. It is similar to a "cold" backup, but differs in that it permits write operations.

  B. It backs up the binary log, which contains the most recent "warm" changes.

  C. It is similar to a "hot" backup, but differs in that it does not permit write operations.

  D. It only backs up "warm" data, that is, data that has been recently modified.

  Correct Answer: D

  A warm backup site is already stocked with hardware representing a reasonable facsimile of that found in your data center. To restore service, the last backups from your off-site storage facility must be delivered, and bare metal restoration completed, before the real work of recovery can begin.

  Reference:https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/4/html/ introduction_to_system_administration/s2-disaster-recovery-sites

• Question 17:

  Which two general properties relate to the mysqlimport client program? (Choose two.)

  A. It bypasses the server and writes directly to the data files.

  B. It can load files both on the client host and the server host.

  C. It can load files only on the server host.

  D. It provides a command-line interface to the LOAD DATA INFILE.

  E. It can be used to easily import full binary backups.

  Correct Answer: BD

  By default, files are read by the server on the server host. With this option, mysqlimport reads input files

  locally on the client host.

  Successful use of LOCAL load operations within mysqlimport also requires that the server permits local

  loading.

  The mysqlimport client provides a command-line interface to the LOAD DATA INFILE.

  Reference: https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html

  https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/mysqlimport.html

• Question 18:

  You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to "permissive".

  Examine this extract of the my.cnf file:

  

  You issue this command to start MySQL Server:

  systemctl start mysqld@replica

  On which port is the server listening?

  A. 3301

  B. 3303

  C. 3302

  D. 3304

  Correct Answer: A

• Question 19:

  What are two benefits of using the --tab option with mysqldump? (Choose two.)

  A. The schema and data are automatically dumped to separate files.

  B. It is possible to restore the data in parallel.

  C. It can be used together with --all-databases.

  D. It can be piped directly into a running server.

  Correct Answer: BC

  Reference: https://books.google.com.pk/books?id=zWY9DwAAQBAJandpg=PA265andlpg=PA265anddq=it+is +possible+to+restore+the+data+in+parallel.+mysqldumpandsource=blandots=jDXNfTRCeDandsig=ACfU3U3Iok36Kbw6pwL_23pTk0yibOwBQandhl=enandsa=Xandved=2ahUKEwix8JyF6avpAhVCyhoKHXMCCKAQ6AEwA3 oECAoQAQ#v=onepageandq=it%20is%20possible%20to%20restore%20the%20data%20in%20parallel.% 20mysqldumpandf=false https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

• Question 20:

  Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

  A. All users have unrestricted access.

  B. MySQL becomes read-only except for setting passwords.

  C. All connections succeed regardless of the username and password.

  D. Only the password for active account can be changed.

  E. User authentication is based on the operating system username.

  Correct Answer: AC

  You should not use -skip-grant-tables options as it will start your server without using the privilege system. It must be dangerous for you. Any one can access your account if you will use it.

  If the server is started with the -skip-grant-tables option, it does not read the grant tables or implement any access control. Anyone can connect and do anything, which is insecure.

  Reference: https://www.ppgia.pucpr.br/pt/arquivos/techdocs/mysql/security.html https://stackoverflow.com/questions/22849308/why-we-need-skip-grant-tables-in-mysql-to-remove-error1045access-denied-wha