[Nov-2021] Oracle 1Z0-908 Test Engine PDF - All Free Dumps from PrepAwayExam
Get New 1Z0-908 Certification – Valid Exam Dumps Questions
How much Oracle 1Z0-908: MySQL 8.0 Database Exam Cost
The price of the Oracle 1Z0-908 Exam is USD 245, for more information related to the Oracle 1Z0-908 Exam please visit Oracle website.
NEW QUESTION 50
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be protected with a password.
- B. It can be dropped using the DROP ROLEstatement.
- C. It can be granted to user accounts.
- D. It is created as a locked account.
- E. It can be renamed using the RENAME ROLEstatement.
- F. It is stored in the mysql.roletable.
Answer: A,B,C
Explanation:
Explanation/Reference:
NEW QUESTION 51
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- B. A manual intervention to force group members to be only the working two instances is required.
- C. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
- D. The cluster will shut down to preserve data consistency.
- E. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
Answer: C,D
NEW QUESTION 52
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 53
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It can be used to create and edit SSL certificates and log locations.
- B. It manages the configuration of client programs.
- C. It will use [client] options by default unless you provide --login-path.
- D. It manages the configuration of the MySQL Firewall feature.
- E. It can move datadir to a new location.
- F. It manages the configuration of user privileges for accessing the server.
- G. It provides an interface to change my.cnf files.
Answer: B,C
NEW QUESTION 54
Which three statements are true about MySQL replication? (Choose three.)
- A. Any instance can have multiple slaves, but it can have only one master.
- B. Each slave must have its own MySQL user for replication.
- C. Binary logs contain only transactions originating from a single MySQL instance.
- D. Each instance in a replication topology must have a unique server ID.
- E. Replication can use only TCP/IP connections.
- F. A replication user must have the SELECT privilege for all tables that need to be replicated.
- G. Binary logging must be enabled on the master in order to replicate to other instances.
Answer: D,F,G
NEW QUESTION 55
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It supports only non-blob datatypes.
- C. It supports all indexes transparently.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It does not support the transportable tablespaces feature.
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION 56
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
- A. DESCRIBE manufacturing.parts;
- B. SELECT * FROM information_schema.COLUMN_STATISTICS;
- C. SHOW INDEXES FROM manufacturing.parts;
- D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- E. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';
Answer: B,E
NEW QUESTION 57
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
- A. Connection 24 experiences a lock wait timeout.
- B. Connection 25 experiences a lock wait timeout.
- C. A deadlock occurs after innodb_lock_wait_timeout seconds.
- D. All statements execute without error.
- E. A deadlock occurs immediately.
Answer: C
NEW QUESTION 58
Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. employee
- B. world
- C. sys
- D. mysql
- E. information_schema
Answer: C,E
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 59
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. You can provide the root password interactively.
- B. The functionality is split among several RPM package files.
- C. MySQL uses the RPM relocatable installation target feature.
- D. You must manually initialize the data directory.
- E. You can find the root password in the error log after the first start.
- F. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
Answer: E,F
NEW QUESTION 60
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
- A. Set binlog_expire_logs_seconds in my.cnf.
- B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- C. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- D. Use PURGE BINARY LOGS to <binlog_name>.
- E. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- F. Use SET PERSIST binlog_expire_logs_seconds=<value>.
Answer: C,F
NEW QUESTION 61
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is at the table object level.
- B. The lock is a row-level lock.
- C. The lock is a shared lock.
- D. The lock is at the metadata object level.
- E. The lock is an exclusive lock.
- F. The lock is an intentional lock.
Answer: A,E
NEW QUESTION 62
Which two are characteristics of snapshot-based backups? (Choose two.)
- A. A separate physical copy must be made before releasing the snapshot backup.
- B. The frozen file system can be cloned to another virtual machine immediately into active service.
- C. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
- D. Snapshot backups can be used only in virtual machines.
- E. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
Answer: A,D
NEW QUESTION 63
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:
The OS metrics indicate that disk is a bottleneck.
Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)
- A. innodb_undo_directory=/dev/shm
- B. sync_binlog=0
- C. buffer_pool_size=24G
- D. max_connections=10000
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_log_file_size=1G
- G. innodb_doublewrite=0
Answer: D,E,F
Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION 64
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?
- A. The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
- B. The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).
- C. The cluster is running and there is at least one ONLINEinstance.
- D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- E. The instance deployed on host3must be rebuilt with a backup from the primary instance.
Answer: B
NEW QUESTION 65
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - C. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-
Answer: D
NEW QUESTION 66
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadat a. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?
- A. The cluster is running and there is at least one ONLINE instance.
- B. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
- C. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- D. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
- E. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
Answer: B
NEW QUESTION 67
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL log_error = ‘<new error log file>’.
- B. Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
- C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
Answer: D
Explanation:
Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/
NEW QUESTION 68
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be renamed using the RENAME ROLE statement.
- B. It can be dropped using the DROP ROLE statement.
- C. It can be protected with a password.
- D. It is stored in the mysql.role table.
- E. It can be granted to user accounts.
- F. It is created as a locked account.
Answer: B,C,E
NEW QUESTION 69
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. ARCHIVE
- C. InnoDB
- D. MEMORY
- E. MyISAM
Answer: D,E
NEW QUESTION 70
Which three actions are effective in capacity planning? (Choose three.)
- A. buying more CPU
- B. monitoring OS resources for patterns
- C. adding circular replication nodes for increased DML capability
- D. consulting the application team about any future projects and use
- E. basing expected growth on an average of the last 3 years
- F. buying more RAM
- G. upgrading to the latest application version
- H. buying more disk
Answer: B,D,E
NEW QUESTION 71
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)
- A. /etc/my.cnf file
- B. $HOME/.mysql/auth/login file
- C. $HOME/.my.cnf file
- D. $HOME/.mysqlrc file
- E. DATADIR/mysqld-auto.cnf file
- F. $HOME/.mylogin.cnf file
- G. $MYSQL_HOME/my.cnf file
Answer: A,E,G
NEW QUESTION 72
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?
- A. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - B. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167; - C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
- D. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300; - E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
Answer: A
NEW QUESTION 73
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use resource groups to lock different instances on separate CPUs.
- B. Run mysqldwith --datadirdefined for each instance.
- C. Use systemdwith different settings for each instance.
- D. Use system tools to lock each instance to its own CPU.
- E. Start mysqldor mysqld_safeusing different option files for each instance.
- F. Run MySQL Server docker containers.
Answer: B,C,E
Explanation:
Explanation/Reference:
NEW QUESTION 74
......
100% Passing Guarantee - Brilliant 1Z0-908 Exam Questions PDF: https://www.prepawayexam.com/Oracle/braindumps.1Z0-908.ete.file.html
1Z0-908 Dumps 2021 - NewOracle Exam Questions: https://drive.google.com/open?id=1PeTvLrn-T-YGA9gmblsmsnAclcsCJYGQ