1Z1-888 Dumps 2022 - New Oracle 1Z1-888 Exam Questions [Q29-Q54]

1Z1-888 Dumps 2022 - New Oracle 1Z1-888 Exam Questions

Free 1Z1-888 Braindumps Download Updated on Sep 26, 2022 with 155 Questions

NEW QUESTION 29
A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

• A. binary log, redo log, doublewrite buffer, and tablespace
• B. doublewrite buffer, redo log, tablespace, and binary log
• C. redo log, binary log, doublewrite buffer, and tablespace
• D. redo log, doublewrite buffer, tablespace, and binary log

Answer: A

 

NEW QUESTION 30
What two statements are true regarding FLUSH TABLES FOR EXPORT?

• A. Table only exports when the table has its own tablespace.
• B. It is the safest way to extract tables from the shared tablespace.
• C. It can be used to export TEMPORARY tables.
• D. Partitioned tables are not supported.
• E. The InnoDB Storage engine must be used for the table being exported.

Answer: A,C

 

NEW QUESTION 31
You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

• A. THREAD_ID 21has stopped running.
• B. At most, two schemas are being updates concurrently.
• C. The slave cannot process the relay log fast enough to use all threads.
• D. The server needs more cores to use all slave threads.
• E. The slave is configured with slave_parallel_workers= 4
• F. The salve has two intermediate relay slaves connected to it.

Answer: C,E

 

NEW QUESTION 32
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

• A. Invoke mysql with the --initialize option.
• B. Invoke mysqld with the --initialize option.
• C. Run the create_system_tables.sql file
• D. Run the mysql_unpack.sql file

Answer: B

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

 

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

Answer: C,E

 

NEW QUESTION 34
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 log_bin variable is set to OFF on the slave.
• B. The shared_memory_base_name variable must match the master.
• C. server_id is not unique.
• D. The version of the slave is newer that the version of the master.
• E. The max_connections variable on the slave needs to be increased.

Answer: A

 

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

• A. table_open_cache = 64
• B. log_bin=mysql -bin
  Innodb_flush_log_at_trx_commit=1
• C. sync_binlog=10
• D. innodb_flush_log_at_trx_commit=0
• E. max_heap_table_size = 2G
  tmp_table_size=2G
• F. query_cache_size = 2G
  query_cache_enabled=1
• G. innodb_flush_method=O_DIRECT
• H. innodb_buffer_pool_instances=64
  innodb_buffer_pool_size=200G

Answer: A,F,G,H

 

NEW QUESTION 36
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

• A. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.
• B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
• C. Use the limit clause to limit the deletion to 100.000 rows.
• D. Use the limit clause in conjunction with the order 3Y clause.

Answer: A,D

 

NEW QUESTION 37
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.)

• A. binlog_format=STATEMENTand a non-deterministic query was executed.
• B. binlog_cache_size=1024is too small and transactions are lost.
• C. enforce_gtid_consistency=ONand consistency is broken between the master and the slave.
• D. sync_binlog=0and the master server crashed.
• E. The sync_relay_log=1000setting on the slave is too small.

Answer: B,C

 

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

• A. The value should be increased if the client performs several SELECToperations.
• B. The join buffer is used to process sorts when complex joins are being performed.
• 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: B,E

Explanation:
Explanation/Reference:

 

NEW QUESTION 39
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

• A. SET GLOBAL enforce_gtid_consistency=ON
• B. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
• C. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";BEGIN; COMMIT;SET GTID_NEXT="AUTOMATIC";
• D. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
• E. SET GTID_NEXT="CONSISTENCY";BEGIN; COMMIT;SET GTID_NEXT="AUTOMATIC";

Answer: D

 

NEW QUESTION 40
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 log_bin variable is set to OFF on the slave.
• B. The shared_memory_base_name variable must match the master.
• C. server_id is not unique.
• D. The version of the slave is newer that the version of the master.
• E. The max_connections variable on the slave needs to be increased.

Answer: A

 

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

• A. It can load files both on the client host and the server host.
• B. It provides a command-line interface to the LOAD DATA INFILE.
• C. It can be used to easily import full binary backups.
• D. It can load files only on the server host.
• E. It bypasses the server and writes directly to the data files.

Answer: A,B

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

 

NEW QUESTION 42
Which two statements are true about InnoDB auto-increment locking? (Choose two.)

• A. The auto-increment lock can be a table-level lock.
• B. InnoDB never uses table-level locks.
• C. InnoDB always protects auto-increment updates with a table-level lock
• D. InnoDB does not use locks to enforce auto-increment uniqueness.
• E. Some settings for innodb_autoinc_lock_mode can help reduce locking.

Answer: A,E

 

NEW QUESTION 43
Which three options are most likely to be changed for production form their default values? (Choose three.)

• A. innodb_buffer_pool_size
• B. port
• C. character_set_system
• D. max_connections
• E. max_user_connections
• F. innodb_log_file_size
• G. join_buffer_size

Answer: B,E,F

 

NEW QUESTION 44
There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

• A. --backup-instance=/var/lib/mysql/instance2
• B. --copy-back-from-log
• C. --restore=2
• D. --defaults-file=/etc/mysql/instance2.cnf
• E. --instance=/var/lib/mysql/instance2

Answer: D

 

NEW QUESTION 45
After rebooting the host, you attempt to start the mysqldservice. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. You failed to specify the port number 3306to the command to start the server, so it is defaulting to port
  80, which is in use by the built-in web server.
• B. The mysql.sockfile in the MySQL /tmpdirectory was not removed after the reboot, so mysqldstill thinks there is an active server running.
• C. The /etc/hostsfile does not have a valid IP entry for mysqld localhost, so it is binding to
  127.0.0.1, which is already in use.
• D. The network service process in the server is frozen, so all TCP/IPconnections are paused and cannot be reused.
• E. The mysqlservice has already been started on the same port.

Answer: B

 

NEW QUESTION 46
SQL injection is a common security threat.
Which two methods would help protect against this risk?

• A. starting the server with the --injection-protection command-line option.
• B. installing the SQL Protection plugin to catch such attempts
• C. using prepared statements to handle unsecured values
• D. using stored procedures to validate values that are input
• E. using SQL variables to secure input values

Answer: D,E

 

NEW QUESTION 47
After rebooting the host, you attempt to start the mysqldservice. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. The mysql.sockfile in the MySQL /tmpdirectory was not removed after the reboot, so mysqldstill thinks there is an active server running.
• B. You failed to specify the port number 3306to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
• C. The /etc/hostsfile does not have a valid IP entry for mysqld localhost, so it is binding to
  127.0.0.1, which is already in use.
• D. The mysqldservice has already been started on the same port.
• E. The network service process in the server is frozen, so all TCP/IPconnections are paused and cannot be reused.

Answer: A

 

NEW QUESTION 48
You have installed the validate_passwordplug-in and set the validate_password_policyvariable.
Which validation is affected by the validate_password_policy setting?

• A. the amount of delay after an incorrect password is entered
• B. whether a new password is rejected if it contains a word found in a dictionary file.
• C. whether a new password is rejected if it contains the current user's username.
• D. the length of time before a newly created password expires

Answer: B

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html

 

NEW QUESTION 49
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';

• A. mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
  mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;
• B. mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
  'employee'@'localhost';
  mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
• C. mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
  mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';
• D. mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

Answer: D

 

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

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

Answer: A,E

 

NEW QUESTION 51
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

• A. the mysql client with the --ignore-password-hashing option
• B. the mysql_upgrade script
• C. the mysql_secure_installation script to update server security settings
• D. the install plugin command for the mysql_cleartext_password plugin
• E. the mysql client with the --enable-cleartext-plugin option

Answer: C

Explanation:
Reference: http://planet.mysql.com/entry/?id=34077

 

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

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

Answer: A,E

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

 

NEW QUESTION 53
You are contacted by a user who does not have permission to access a database table.
You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

• A. The access does not take effect until the user logs out and back in.
• B. The access is available immediately.
• C. The access does not take effect until the next time the server is started.
• D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Answer: B

 

NEW QUESTION 54
......

Oracle 1Z1-888 Exam Practice Test Questions: https://www.braindumpsvce.com/1Z1-888_exam-dumps-torrent.html