Pass Authentic Oracle 1Z0-908 with Free Practice Tests and Exam Dumps

New 1Z0-908  Exam Questions Real Oracle Dumps

NEW QUESTION # 49
A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

• A. You use the InnoDB storage engine and statements wait while data is inserted.
• B. The Innodb Buffer pool is full.
• C. You use the MyISAM storage engine for most common tables.
• D. Your table accesses wait for the operating system level flush.

Answer: A

NEW QUESTION # 50
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

• A. Run mysqldwith --datadirdefined for each instance.
• B. Use systemdwith different settings for each instance.
• C. Use resource groups to lock different instances on separate CPUs.
• 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: A,B,E

Explanation:
Explanation/Reference:

NEW QUESTION # 51
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

• A. This file is for storing MySQL Server configuration options in ISON format.
• B. It is always updated with changes to system variables.
• C. This file is for logging purposes only and is never processed.
• D. It is read and processed at the end of startup configuration.
• E. It is read and processed at the beginning of startup configuration.
• F. This file is for storing MySQL server_uuid values only.

Answer: B,D

NEW QUESTION # 52
You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

• A. --shared-memory-base-name=world
• B. --protocol=UDP
• C. --database=world
• D. --host=192.0.2.1
• E. --protocol=pipe
• F. --user=admin
• G. --port=3306
• H. --socket=/tmp/mysql.sock
• I. --password

Answer: A,D,E,I

NEW QUESTION # 53
Examine these commands and output:

Which connection ID is holding the metadata lock?

• A. 0
• B. 1
• C. 2
• D. 3
• E. 4
• F. 5

Answer: B

NEW QUESTION # 54
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. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  RESET SLAVE;
• B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-
• D. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
  RESET MASTER;
• E. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
  RESET SLAVE;

Answer: E

NEW QUESTION # 55
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

• A. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
• B. MySQL writes SDI to the binary log for distributed backups.
• C. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
• D. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
• E. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

Answer: C,E

NEW QUESTION # 56
Which two are true about binary logs used in asynchronous replication? (Choose two.)

• A. They contain events that describe only administrative commands run on the master.
• B. They contain events that describe database changes on the master.
• C. They are pulled from the master to the slave.
• D. They contain events that describe all queries run on the master.
• E. They are pushed from the master to the slave.

Answer: B,E

Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)

NEW QUESTION # 57
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

• A. SELECT email,passwd FROM members
• B. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• C. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
• D. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
• E. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
  (‘[email protected]’, ‘secret’);--‘;
  SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
• F. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
  (‘[email protected]’,‘secret’);--‘;

Answer: A,C

NEW QUESTION # 58
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)

• A. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
• B. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
• C. Configuring SSL group communication also configures SSL distributed recovery.
• D. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
• E. If only some InnoDB Cluster members are enabled for SSL group communication, and
  --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
• F. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

Answer: A,F

NEW QUESTION # 59
You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

• A. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.
• B. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.
• C. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.
• D. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

Answer: C

NEW QUESTION # 60
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 instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).
• B. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
• C. The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
• D. The instance deployed on host3must be rebuilt with a backup from the primary instance.
• E. The cluster is running and there is at least one ONLINEinstance.

Answer: A

NEW QUESTION # 61
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

• A. *.sdi files
• B. *.CSM files
• C. *.ibd files
• D. ibbackup files
• E. ib_logfile* files

Answer: C,E

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

Answer: D,E

NEW QUESTION # 63
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

• A. Change the default database and re-execute the failed statement in your transaction.
• B. Roll back the transaction and start the transaction again in the same session.
• C. Close the connection, reconnect, and start the transaction again.
• D. Re-execute the failed statement in your transaction.

Answer: D

NEW QUESTION # 64
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

• A. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
• B. Existing connections can continue to use the roles' privileges until they reconnect.
• C. It fails if any of the roles is specified in the mandatory_roles variable.
• D. It fails if at least one of the roles does not exist.
• E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
• F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

Answer: B,E

NEW QUESTION # 65
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

• A. MEMORY
• B. BLACKHOLE
• C. NDB
• D. InnopB
• E. MyISAM
• F. ARCHIVE

Answer: B,C,E

NEW QUESTION # 66
Which two methods allow a DBA to reset a user's password? (Choose two.)

• A. ALTER USER statement
• B. mysqladmin client program
• C. GRANT statement
• D. mysql_secure_installation utility
• E. SET PASSWORD statement

Answer: A,E

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

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

Answer: B

NEW QUESTION # 68
......

Oracle 1Z0-908 (MySQL 8.0 Database Administrator) Exam is designed for individuals who want to prove their expertise in administering MySQL 8.0 databases. MySQL 8.0 Database Administrator certification exam evaluates the candidate's knowledge and ability to install, configure, manage, and troubleshoot MySQL 8.0 databases. 1Z0-908 exam also tests the candidate's understanding of MySQL architecture, data types, security, backup and recovery, and performance optimization.

 

1Z0-908 Exam Info and Free Practice Test Professional Quiz Study Materials: https://prep4sure.vce4dumps.com/1Z0-908-latest-dumps.html