Real Oracle 1Z0-888 Exam Questions Study Guide [Q52-Q77]

Real Oracle 1Z0-888 Exam Questions Study Guide

Updated and Accurate 1Z0-888 Questions for passing the exam Quickly

NEW QUESTION 52
You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup? (Choose two.)

• A.
• B.
• C.
• D.

Answer: A,D

 

NEW QUESTION 53
The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

• A. The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.
• B. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.
• C. All these tables have the same number of rows.
• D. The global_status table is equivalent to the SHOW GLOBAL STATUS statement.
• E. The session_status table is equivalent to status_by_thread for the current thread.

Answer: B,E

 

NEW QUESTION 54
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future? (Choose two.)

• A. Increase the size of the InnoDB buffer pool.
• B. Deactivate the query cache.
• C. Increase the value of the innodb_lock_wait_timeoutoption.
• D. Increase the value of the innodb_read_io_threadsoption.
• E. Change the table to use HASH indexes instead of BTREE indexes.
• F. Set the value of innodb_adaptive_hash_indexto zero.

Answer: A,D

 

NEW QUESTION 55
You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.
Which three statements are true? (Choose three.)

• A. The events_statements_current consumer must be enabled.
• B. The performance impact is less than SHOW FULL PROCESSLIST.
• C. The sys.session view provides the process list with additional information.
• D. A connection must be instrumented to be included in the list of processes.
• E. The threads table contains all the required columns.
• F. The PROCESS privilege is required.

Answer: A,E,F

Explanation:
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

 

NEW QUESTION 56
Is it true that binary backups always take less space than text backups?

• A. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
• B. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
• C. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
• D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.

Answer: B

 

NEW QUESTION 57
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

• A. to repair table structure problem
• B. to make sure a table has no structural problems
• C. to make sure that no table indexes are corrupted
• D. to improve performance by updating index distributing statistics on InnoDB tables
• E. to find out why a query takes a long time to execute on a given table

Answer: B,C

Explanation:
Explanation
The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK TABLE indicates that a table has problems, the table should be repaired.

 

NEW QUESTION 58
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 root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• B. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• C. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
  > /data/data.sql
• D. The applications have the SUPERprivilege, which allows them to update rows.
• E. The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.

Answer: B,C

 

NEW QUESTION 59
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

• A. There is no password defined in the login path.
• B. The host on the command line is not defined in the login path.
• C. The .mylogin.cnf file is not readable.
• D. The mysqld instance has not been restarted after creating the login path.
• E. The DNS is not configured correctly for slave1 host.

Answer: C

 

NEW QUESTION 60
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

• A. The version of the slave is newer that the version of the master.
• B. The shared_memory_base_name variable must match the master.
• C. server_id is not unique.
• D. The max_connections variable on the slave needs to be increased.
• E. The log_bin variable is set to OFF on the slave.

Answer: E

 

NEW QUESTION 61
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

• A. --skip-networking, to prohibit access from remote locations
• B. --read-only, to set all data to read-only except for super users
• C. --reset-grant-tables, to start the server with only the mysql database accessible.
• D. --old-passwords, to start MySQL to use the old password format while running without the grant tables.

Answer: A

 

NEW QUESTION 62
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUS indicates these values:
RELAY_LOG_FILE=hostname-relay-bin.00004
RELAY_LOG_POS=1383
Which command set would make the slave current?

• A. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004',RELAY_LOG_POS = 1383;
• B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

Answer: B

 

NEW QUESTION 63
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?

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

Answer: B,C

 

NEW QUESTION 64
What are three methods to reduce MySQL server exposure to remote connections?
(Choose three.)

• A. setting -skip-networking when remote connections are not required
• B. using SSL when transporting data over remote networks
• C. setting -mysql_secure_configuration to enable paranoid mode
• D. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
• E. setting specific grant privileges to limit remote authentication

Answer: A,B,E

 

NEW QUESTION 65
A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

• A. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
• B. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT '/C=.....'
• C. using GRANT ... REQUIRE SSL for a secure connection
• D. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'

Answer: B

 

NEW QUESTION 66
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

• A. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B. Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
• C. Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.
• D. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• E. Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

Answer: B,E

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html

 

NEW QUESTION 67
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

• A. --create-apply-log
• B. --skip-opt
• C. --single-transaction
• D. --master-data
• E. --lock-all-tables

Answer: B,E

 

NEW QUESTION 68
Which three allocate memory per thread in MySQL?

• A. thread cache
• B. read buffer
• C. query cache
• D. internal temporary table
• E. sort buffer
• F. InnoDB buffer pool instance

Answer: B,E,F

 

NEW QUESTION 69
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

• A. it contains the undo log.
• B. it contains the system tablespace.
• C. it contains the redo log.
• D. it is the default location for all new tables that you create.
• E. it contains a general tablespace.
• F. it contains the binary log.

Answer: B,D

 

NEW QUESTION 70
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

• A. iSCSI Lun
• B. NFS (Networked File System) mount
• C. battery-backed locally-attached RAID 5 array
• D. SAN (Fibre Channel) Lun

Answer: C

 

NEW QUESTION 71
Consider:

Which statement best describes the meaning of the values in the ref columns?

• A. world.City.CountryCodeis used as the primary key for the Country table.
• B. world.City.CountryCode is used to sort the rows in the Citytable.
• C. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCode column is used to select rows in the City table.
• D. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

Answer: D

 

NEW QUESTION 72
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• A. it contains the undo log.
• B. it contains the system tablespace.
• C. it contains the redo log.
• D. it is the default location for all new tables that you create.
• E. it contains a general tablespace.
• F. it contains the binary log.

Answer: B,D

 

NEW QUESTION 73
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

• A. The join buffer is used to process sorts when complex joins are being performed.
• B. The value should be increased if the client performs several SELECToperations.
• C. The join buffer is global and can be changed only by restarting the server.
• D. The join buffer is set per connection.
• E. The value should be increased from the default if the query joins large rows without using an index.

Answer: A,E

 

NEW QUESTION 74
Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A. Physical backups are usually faster than text backups.
• B. Logical backups are human-readable whereas physical backups are not.
• C. Physical backups can be used to recover from data corruption.
• D. Physical backups are usually slower than text backups.
• E. Logical backups are always larger than physical backups.

Answer: A,C

 

NEW QUESTION 75
You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?

• A. - -single-transaction as this obtains a consistent view of data only
• B. - -data-only as this specifies that only data is to be dumped
• C. - -no-create-info to skip writing CREATE TABLE statements
• D. - -table=userdata in order to dump only the data from the userdata table

Answer: A

 

NEW QUESTION 76
Where does MySQL Linux RPM install the mysqld binary?

• A. /usr/local/mysql/bin/
• B. /usr/libexec/
• C. /usr/bin/
• D. /opt/mysql/server/bin/
• E. /usr/sbin/

Answer: E

 

NEW QUESTION 77
......

Scope

This certificate verifies the fundamental knowledge to become an Oracle Certified MySQL 5.7 Database Administrator ensuring if the candidate is skilled enough of practically applying the knowledge gained through pieces of training and practical experience of working within the projects.

 

Prepare Important Exam with 1Z0-888 Exam Dumps: https://examboost.latestcram.com/1Z0-888-exam-cram-questions.html