Apr-2022 Oracle 1Z0-888 Actual Questions and 100% Cover Real Exam Questions [Q37-Q55]

By adminOn April 20, 2022

4/5 - (1 vote)

Apr-2022 Oracle 1Z0-888 Actual Questions and 100% Cover Real Exam Questions

1Z0-888 Free Exam Questions and Answers PDF Updated on Apr-2022

Brief Details

Following are the quick details related to the Oracle 1z0-888 Certification Exam

Pass Score: 58%
Exam Price: $245 (USD) Price may vary for a country based on the localized currency rates
Exam type: Multiple Choice Questions
Duration: 120 minutes
Exam Code: 1z0-888
Exam Voucher: Candidates can purchase the exam vouchers on Oracle Education Portal. Voucher is valid for 6 months from the date of issue and is like a gift voucher which will get forfeited if not used within 6 months.
Exam Mode: Online Proctored Exam.
Candidates can take the examination from any place at any time as per their convenience. Candidates also have the option to give exams at any of the authorized training centers. Candidates can select the exam mode based on their convenience at the time of registration.
Exam Name: MySQL 5.7 Database Administrator

NO.37 You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
Total dataset size is 200G with an average schema size of 2G.

The data is transient and is not backed up and can be repopulated easily.

Performance and responsiveness of the DB is paramount.

The query pattern for the DB instance is split 90/10 read/write.

DB host is dedicated server with 256G RAM and 64 cores.

One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance?

table_open_cache = 64

innodb_buffer_pool_instances=64
innodb_buffer_pool_size=200G

log_bin=mysql -bin
Innodb_flush_log_at_trx_commit=1

sync_binlog=10

innodb_flush_method=O_DIRECT

max_heap_table_size = 2G
tmp_table_size=2G

query_cache_size = 2G
query_cache_enabled=1

innodb_flush_log_at_trx_commit=0

NO.38 How does the InnoDB storage engine handle deadlocks when they are detected?

Both the affected transactions will be rolled back.

The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

One of the affected transactions will be rolled back, the other is allowed to proceed.

The transaction isolation level determines which transaction is rolled back.

The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html

NO.39 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?

–skip-opt

–lock-all-tables

–create-apply-log

–single-transaction

–master-data

NO.40 These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’; mysql> CREATE USER ”@” IDENTIFIED BY ‘valid_password’ WITH PROXY
’employee’@’localhost’;

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’; mysql> GRANT PROXY ON ’employee’@’localhost’ TO ‘robert’@’localhost’;

mysql> CREATE USER ‘robert’@’localhost’ IDENTIFIED BY ‘secret_password’; mysql>CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

mysql> CREATE_USER ”@” IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’; mysql> GRANT PROXY ON ’employee’@’localhost’ TO ”@”;

NO.41 Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

Add a functional index for YEAR(Birthday).

Execute ANALYZE TABLEto update the index statistics.

Add a generated column calculating YEAR(Birthday)and index that column.

Add FORCE INDEX (Birthday)to the query.

NO.42 Which three allocate memory per thread in MySQL?

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

NO.43 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?

STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE =
‘hostname-relay-bin.00004’,RELAY_LOG_POS = 1383;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE =
‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

NO.44 Which three are key advantages of standard MySQL replication? (Choose three.)

supports native automatic failover

enables automatic resync of databases when discrepancies are detected

provides arbitrary geographic redundancy with minimal overhead to master

synchronously guarantees identical slave copy

is easy to configure and has low performance overhead

can easily add slaves for read scaling

NO.45 An administrator installs MySQL to run under a mysqlOS account. The administrator decides to disable logins to the mysqlaccount by using /nologinor /bin/falseas the user’s shell setting.
Which statement is true?

The mysqluser needs a login and its home directory must be the base directory of the installation.

The OS needs to allow logging in as mysqlso that administrative tasks can be performed.

This prevents mysqldfrom starting when standard startup scripts are used.

This prevents creation of a command shell with the mysqlaccount, while allowing mysqldto run.

Explanation/Reference:

NO.46 A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

binlog_cache_size=1024 is too small and transactions are lost.

binlog_format=STATEMENT and a non-deterministic query was executed.

enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

The sync_relay_log=1000 setting on the slave is too small.

sync_binlog=0 and the master server crashed.

NO.47 An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

validate_password_policy cannot be set without restarting the MySQL instance.

The name of the dictionary file is too obvious.

The dictionary file word list is too short.

validate_password_dictionary_file cannot be set without restarting the MySQL instance.

The validate_password plug-in has not been loaded.

The dictionary file is an insecure location.

NO.48 You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host.
You installed the binary in the default location (the default –basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?

Execute a command with a minimal form of: mysql –initialize

Create a configuration file containing default-storage-engine=InnoDB.

Set an exception in the host machine’s firewall to allow external users to talk to mysqld.

Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

NO.49 Which MySQL utility copies the master instance to a slave instance on the same host?

mysqlfailover

mysqldbcopy

mysqlrplsync

mysqlserverclone

https://docs.oracle.com/cd/E17952_01/mysql-utilities-1.5-en/mysqlserverclone.html

NO.50 You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

service mysqld prepare-init

mysqld_safe –initialize …

mysql -u root -p < support-files/mysqldb.sql

mysqld_safe –user=mysql

mysqld –initialize …

https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html

NO.51 Which three allocate memory per thread in MySQL?

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html

NO.52

What does the possible_keys column in this output denote?

if it is possible for you to include any indexes in your query

whether there are any indexes on the tables that you are querying

if there are any indexes that may be used to solve this query

whether you are using any indexes in your query

NO.53 Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query?

There are three indexes on the table.

There is a redundant index on the dept_no column.

The secondary indexes are optimized for unique key look-ups.

The values on the emp_no column must be unique.

The selectivity of the dept_no column is the best of the indexed columns.

There is a redundant index on the emp_no column.

NO.54 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.)

Start the MySQL Server in –safe-mode, which only loads the privilege system for changes as data is inaccessible.

Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

Start the MySQL Server with –init-filepointing to SQL that executes an ALTER USER statement to change the root user password.

Start the MySQL Server with –skip-grant-tables and execute SQL, which will update the root password.

Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

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

NO.55 Which two statements are true regarding MySQL security? (Choose two.)

The mysql user needs to have sudo privileges.

The mysqld process owner should own all files and directories to which the server writes.

The root or administrator users should own all files and directories to which the server writes.

The mysqld process should be run as root or administrator.

The mysqld process should not be run as root or administrator.

Loading …

Target Audience

The Oracle 1z0-888 Certification Exam is targeted to the candidates having experience of working with MySQL Database technology and looking to pursue a career as an Oracle Certified Professional MySQL 5.7 Database Administrator OCP specialist in the field of MySQL Database technology.

Oracle 1Z0-888 Real 2022 Braindumps Mock Exam Dumps: https://www.testkingit.com/Oracle/latest-1Z0-888-exam-dumps.html

1Z0-888, Oracle1Z0-888 Cert Exam, 1Z0-888 reliable study guide sheet, 1Z0-888 valid practice questions files, 1Z0-888 vce files