Pass Your Exam Easily! 1Z0-908 Real Question Answers Updated on Dec 29, 2023 [Q81-Q105]

1Z0-908 Oracle

admin • December 29, 2023

Pass Your Exam Easily! 1Z0-908 Real Question Answers Updated on Dec 29, 2023 [Q81-Q105]

Rate this post

Pass Your Exam Easily! 1Z0-908 Real Question Answers Updated on Dec 29, 2023

Actual Questions Answers Pass With Real 1Z0-908 Exam Dumps

The 1z1-908 exam covers various topics related to MySQL database administration, including installation and configuration, security management, backup and recovery, performance tuning, and high availability. 1Z0-908 exam is intended to assess the candidate’s understanding of MySQL architecture, data types, and SQL language. It also evaluates their ability to perform common database administration tasks, such as managing users and permissions, optimizing queries, and troubleshooting issues. Passing the 1z1-908 exam demonstrates that the candidate is proficient in MySQL server installation, configuration, and maintenance, making them a valuable asset to any organization that uses MySQL databases.

Q81. Examine this command and output:

Which two statements are true? (Choose two.)

The lock is at the metadata object level.

The lock is a shared lock.

The lock is an intentional lock.

The lock is at the table object level.

The lock is a row-level lock.

The lock is an exclusive lock.

Q82. Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Q83. You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

The mysqlcheck –check –all-databases command takes table write locks while performing a series of checks.

The mysqlcheck –optimize –all-databases command reclaims free space from table files.

The mysqlcheck –repair –all-databases command can repair an InnoDB corrupted table.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

The mysqlcheck –analyze –all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation

Q84. You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

They take roughly twice as long as logical backups.

They allow direct copying of table rows with operating system copy commands.

They work best for transaction storage engines that can perform their own recovery when restored.

The backup window is almost zero from the perspective of the application.

They do not back up views, stored procedures, or configuration files.

There is a slight performance cost while the snapshot is active.

They do not use additional disk space.

Q85. Examine this query:

What information does this query provide?

total memory used across all connections associated with the user on connection number 10

total memory used by the first 10 connections

total memory used by thread number 10

total memory used across all connections associated with the user on thread number 10

total memory used by connection number 10

total memory used by the first 10 threads

Q86. Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

It is possible to retrieve a normalized statement, but never the exact statement that was executed.

It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Q87. 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.)

The cluster will shut down to preserve data consistency.

The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

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.

A manual intervention to force group members to be only the working two instances is required.

Q88. Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

Executing ALTER TABLE transactions will enable you to free up disk space.

Truncating the sales and leads table will free up disk space.

Truncating the transactions table will free up the most disk space.

The transactions table was created with innodb_file_per_table=OFF.

Q89. Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p –protocol=TCP –ssl-mode=
Which two –ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

REQUIRED

VERIFY_CA

VERIFY_IDENTITY

PREFERRED

DISABLED

Q90. Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

sort_buffer_size

key_buffer_size

table_open_cache

read_buffer_size

innodb_buffer_pool_size

tmp_table_size

Q91. Which step or set of steps can be used to rotate the error log?

Execute SET GLOBAL log_error = ‘<new error log file>’.

Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.

Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/

Q92. Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.)

DESCRIBE manufacturing.parts;

SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;

SHOW INDEXES FROM manufacturing.parts;

SELECT * FROM information_schema.COLUMN_STATISTICS;

EXPLAIN SELECT INDEXES FROM manufacturing.parts;

Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

Q93. 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.)

The cluster will shut down to preserve data consistency.

The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.

The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

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.

A manual intervention to force group members to be only the working two instances is required.

Q94. You issue this command:
SHOW SLAVE STATUS –
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

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.

It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

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.

It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Q95. Which two are features of MySQL Enterprise Firewall? (Choose two.)

recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

blocking of potential threats by configuring pre-approved whitelists

modifying SQL statement dynamically with substitutions

automatic locking of user accounts who break your firewall

provides stateless firewall access to TCP/3306

Q96. Examine these commands and output:

Which connection ID is holding the metadata lock?

Q97. Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p –protocol=TCP –ssl-mode=
Which two –ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

REQUIRED

VERIFY_CA

VERIFY_IDENTITY

PREFERRED

DISABLED

Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html

Q98. 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?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

Q99. Examine this command, which executes successfully:
$ mysqlrouter –bootstrap user@hostname:port –directory=directory_path Which activity is performed?

MySQL Router is configured based on the information in files in directory_path.

MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

MySQL Router is restarted.

MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

Q100. Which four connection methods can MySQL clients specify with the –protocol option when connecting to a MySQL server? (Choose four.)

TCP

SOCKET

PIPE

DIRECT

IPv6

FILE

IPv4

MEMORY

Q101. Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

Mark can grant the privileges assigned to the r_read@localhost role to another user.

ADMIN OPTION causes the role to be activated by default.

Mark can grant the r_read@localhost role to another user.

Mark can revoke the r_read@localhost role from another role.

ADMIN OPTION allows Mark to drop the role.

Mark must connect from localhost to activate the r_read@localhost role.

Q102. Which three are characteristics of a newly created role? (Choose three.)

It can be dropped using the DROP ROLE statement.

It is stored in the mysql.role table.

It is created as a locked account.

It can be renamed using the RENAME ROLE statement.

It can be granted to user accounts.

It can be protected with a password.

Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/

Q103. Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

named pipes

shared memory

SOCKET

X Protocol

UDP

TCP/IP

Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html

Q104. Examine these statements and output:

Which statement is true?

The user is logged in with –user=accounting as an option.

The user is authenticated as the anonymous proxy user ”@’%’.

The user is authorized as the accounting@localhost user.

The user is authorized as the rsmith@localhost user.

The user failed to define a username and the connecting username defaulted to ”@’%’.

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

Run MySQL Server docker containers.

Use systemd with different settings for each instance.

Use system tools to lock each instance to its own CPU.

Start mysqld or mysqld_safe using different option files for each instance.

Run mysqld with –datadir defined for each instance.

Use resource groups to lock different instances on separate CPUs.

Loading …

Preparing for the Oracle 1z1-908 exam requires a lot of time and effort. You need to have a solid understanding of MySQL 8.0 and be familiar with the tools and techniques used in database administration. There are many resources available online that can help you prepare for the exam, such as study guides, practice tests, and online courses. It is recommended that you take advantage of these resources to ensure that you are fully prepared for the exam.

New 1Z0-908 Dumps – Real Oracle Exam Questions: https://www.2pass4sure.com/MySQL-Database-Administration/1Z0-908-actual-exam-braindumps.html