1Z0-908 Dumps PDF - 1Z0-908 Real Exam Questions Answers

Get Started: 1Z0-908 Exam [2023] Dumps Oracle PDF Questions

NEW QUESTION # 79
How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A. The instances have appropriate net masks set.
• B. The instances use different socket names.
• C. The instances listen on different IP addresses.
• D. The instances use different user accounts unique to each instance.

Answer: C

NEW QUESTION # 80
Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

• A. ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE
• B. ALTER USER 'joe'@'%' ACCOUNT LOCK
• C. ALTER USER 'joe'@'%' SET password='*invalid*'
• D. REVOKE USAGE ON *.* FROM 'joe'@'%'
• E. REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
• F. ALTER USER 'joe'@'%' PASSWORD HISTORY 0

Answer: A,E

NEW QUESTION # 81
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

• A. Remove ib_logfile0 and ib_logfile1 files from the file system.
• B. Create a new ib_logfile0 file of size 26214400.
• C. First run mysqld --initialize to refresh the Size of ib_logfile.
• D. Execute mysqladmin flush-logs.

Answer: C

NEW QUESTION # 82
Examine this command, which executes successfully:

Which statement is true?

• A. Only non-encrypted files are backed up.
• B. Only tables stored in their own tablespaces are backed up.
• C. Only InnoDB data and log files are backed up.
• D. Only files for MySQL or Its built-in storage engines are backed
• E. The backup includes only data files and their metadata.

Answer: C

NEW QUESTION # 83
You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

• A. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
• B. A small amount of committed transactions may be lost in case they were committed just before the disk failure.
• C. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
• D. No committed transactions are lost.
• E. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
• F. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

Answer: B,F

NEW QUESTION # 84
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

• A. Use the Clone Plugin to copy the data to another MySQL system.
• B. Take a logical backup of the MySQL system.
• C. Take your backup from a slave of the MySQL system.
• D. Take a physical backup of the MySQL system.

Answer: B

NEW QUESTION # 85
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. max_connections=10000
• C. innodb_doublewrite=0
• D. buffer_pool_size=24G
• E. innodb_log_file_size=1G
• F. sync_binlog=0
• G. innodb_flush_log_at_trx_commit=1

Answer: B,E,G

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 # 86
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

• A. On the slave, alter the MySQL master connection setting with:
  ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• B. On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• C. Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency
• D. Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• E. Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;
• F. Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

Answer: B,C

NEW QUESTION # 87
Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
  'tom'@'%';
• B. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• C. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
• D. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

Answer: A

NEW QUESTION # 88
Examine this query and output:

Which two statements are true? (Choose two.)

• A. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
• B. The countrytable is accessed as the first table, and then joined to the city table.
• C. The query returns exactly 125 rows.
• D. It takes more than 8 milliseconds to sort the rows.
• E. 35 rows from the city table are included in the result.

Answer: A,E

NEW QUESTION # 89
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

• A. It is not necessary because innodb_data_home_dir is already defined.
• B. It adds more temporary workspace in addition to the innodb_tmpdir location.
• C. It allows scanning of other locations to discover more innodb tablespaces.
• D. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• E. It defines all innodb tablespace options relative to a starting parent directory.

Answer: A

NEW QUESTION # 90
Examine these statements and output:

Which statement is true?

• A. The user is logged in with --user=accounting as an option.
• B. The user is authorized as the accounting@localhost user.
• C. The user is authenticated as the anonymous proxy user ''@'%'.
• D. The user failed to define a username and the connecting username defaulted to ''@'%'.
• E. The user is authorized as the rsmith@localhost user.

Answer: E

NEW QUESTION # 91
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 = 0 in my.cnf and restart the server.
• B. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
• C. Set binlog_expire_logs_seconds in my.cnf.
• D. Use PURGE BINARY LOGS to <binlog_name>.
• E. Use SET PERSIST binlog_expire_logs_seconds=<value>.
• F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.

Answer: B,E

NEW QUESTION # 92
You want to dump all databases with names that start with "db".
Which command will achieve this?

• A. mysqlpump > all_db_backup.sql
• B. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
• C. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
• D. mysqlpump --include-databases=db --result-file=all_db_backup.sql

Answer: D

NEW QUESTION # 93
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

• A. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• B. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
• C. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
• D. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Answer: D

NEW QUESTION # 94
Examine this query:

What information does this query provide?

• A. total memory used across all connections associated with the user on connection number 10
• B. total memory used by connection number 10
• C. total memory used by the first 10 connections
• D. total memory used across all connections associated with the user on thread number 10
• E. total memory used by the first 10 threads
• F. total memory used by thread number 10

Answer: B

NEW QUESTION # 95
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

• A. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• B. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
• C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• D. Replication will work.
• E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

Answer: C

NEW QUESTION # 96
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

• A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• B. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
• C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
• D. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
• E. The mysqlcheck --optimize --all-databases command reclaims free space from table files.

Answer: A,D

NEW QUESTION # 97
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A. MySQL Replication monitoring
• B. network-related information and network characteristics
• C. disk usage and disk characteristics including disk advisors warnings
• D. security-related advisor warnings
• E. operating system memory utilization
• F. CPU utilization
• G. MySQL Query Analysis data

Answer: C,D,G

NEW QUESTION # 98
......

1Z0-908 Premium Exam Engine pdf Download: https://www.testsimulate.com/1Z0-908-study-materials.html