Oracle 1Z0-888 Real Exam Questions Guaranteed Updated Dump from BraindumpsPrep [Q67-Q84]

Oracle 1Z0-888 Real Exam Questions Guaranteed Updated Dump from BraindumpsPrep

Verified Pass 1Z0-888 Exam in First Attempt Guaranteed

NEW QUESTION 67
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

• A. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY
• B. 'imbatman';
  CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS
• C. 'imbatman';
  CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
• D. 'webdesign' USING 'imbatman';
  CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
• E. sha256_password 'imbatman';
  CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
• F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH

Answer: C,E

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

 

NEW QUESTION 68
You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

• A. [mysqld] and [mysqladmin]
• B. [mysqladmin]
• C. [mysqld]
• D. [mysql] and [mysqladmin]
• E. [mysql] and [mysqld]
• F. [mysql]
• G. [mysql] and [mysqld] and [mysqladmin]

Answer: F

Explanation:
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html

 

NEW QUESTION 69
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

• A. Have a second data centre in a different region or country.
• B. Create a master-master pair for each service.
• C. Keep software updated to the latest version.
• D. Use RAID 10 storage for data.
• E. Use on-site network-attached storage to separate service from data.
• F. Implement a failover strategy to another geographic location.

Answer: A,F

 

NEW QUESTION 70
The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

• A. MySQL starts but Binary Logging is disabled.
• B. MySQL fails to start due to conflicting options on the command line.
• C. MySQL starts and Binary Logging is enabled.
• D. MySQL fails to start due to the conflicting options in the configuration files.

Answer: B

 

NEW QUESTION 71
What is the order of tables shown in an EXPLAINoutput?

• A. It lists tables in the order in which their data will be read.
• B. It lists tables from the most optimized to the least optimized.
• C. It lists tables from the smallest to the largest.
• D. It lists tables in the order in which they are specified in the statement that is being explained.

Answer: D

Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html

 

NEW QUESTION 72
How does the InnoDB storage engine handle deadlocks when they are detected?

• A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• B. The transaction isolation level determines which transaction is rolled back.
• C. Both the affected transactions will be rolled back.
• D. One of the affected transactions will be rolled back, the other is allowed to proceed.
• E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Answer: D

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

 

NEW QUESTION 73
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

• A. to allow a backup to be created under reduced load
• B. to allow for point-in-time recovery on the slave
• C. to prevent schema changes from propagating to the slave before they are validated
• D. to allow the remaining events to be processed on the slave while not receiving new events from the master
• E. to prevent any transaction experiencing a deadlock

Answer: A,B

 

NEW QUESTION 74
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 slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.
• 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 root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• E. The applications have the SUPERprivilege, which allows them to update rows.

Answer: B,C

 

NEW QUESTION 75
You have a server that has very limited memory but has a very large table.
You will use mysqldumpto back up this table.
Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?

• A. --single-transaction
• B. --tab
• C. --quick
• D. --skip-buffer

Answer: C

Explanation:
Explanation/Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

 

NEW QUESTION 76
You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

• A. shell> mysql test < dump.sql
• B. mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';
• C. shell> mysqladmin recover test dump.sql
• D. mysql>USE test; mysql>SOURCE dump.sql;
• E. shell> mysqlimport test dump.sql

Answer: B,E

Explanation:
Explanation/Reference:

 

NEW QUESTION 77
Which statement best describes the purpose of the InnoDB buffer pool?

• A. It holds changes made during a transaction before they are written to the log.
• B. It caches only the indexes for InnoDB tables.
• C. It is amount of buffers available during a transaction.
• D. It caches data and indexes for InnoDB tables.
• E. It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Answer: D

Explanation:
Reference:
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

 

NEW QUESTION 78
A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

• A. Yes. Shut down the mysqldprocess, enable the transportable_tablespaceoption, and move the UNDO directory to the SSD.
• B. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directoryvalue in your my.cnf.
• C. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.
• D. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

Answer: C

 

NEW QUESTION 79
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?

• A. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
• B. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
• C. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
• D. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
• E. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

Answer: C,D

 

NEW QUESTION 80
Examine the mysqldumpslow output:

Which two options could explain the slow query? (Choose two.)

• A. A full table scan is being used.
• B. No index has been defined on the filtered column.
• C. There are 108 queries still being executed.
• D. A table lock is causing delays.
• E. There is network congestion between client and server.

Answer: A,E

 

NEW QUESTION 81
You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

• A. The changes caused by the UPDATEstatement are logged to the binary log because the instance is using
  --binlog-format = ROW
• B. You would receive an error on the statement because you cannot update a different database that what is specified with the USEstatement.
• C. The statement would fail because you cannot update more than one row at a time when using --binlog- format = ROW.
• D. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
• E. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-formatvalue set to STATEMENT.

Answer: D,E

 

NEW QUESTION 82
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 improve performance by updating index distributing statistics on InnoDB tables
• D. to make sure that no table indexes are corrupted
• E. to find out why a query takes a long time to execute on a given table

Answer: B,D

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 83
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

• A. apply-log
• B. gtid_enable
• C. binlog_format=STATEMENT
• D. log-bin
• E. bonlog_format=ROW

Answer: D

Explanation:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time- recovery.html

 

NEW QUESTION 84
......

Download Real Oracle 1Z0-888 Exam Dumps Test Engine Exam Questions: https://exams4sure.briandumpsprep.com/1Z0-888-prep-exam-braindumps.html