1Z0_908 questions • Exam prepare

Exam contains 143 questions

Page 19 of 24

Question 109 🔥

Examine this command, which executes successfully:Which statement is true?

Which database solution meets these requirements?

A. Only files for MySQL or Its built-in storage engines are backed

Highly voted

B. Only non-encrypted files are backed up.

C. The backup includes only data files and their metadata.

D. Only InnoDB data and log files are backed up.

E. Only tables stored in their own tablespaces are backed up.

Discussion of the question

Question 110 🔥

How can mysql_multi be configured to allow MySQL instances to use the same port number?

Which database solution meets these requirements?

A. The instances use different user accounts unique to each instance.

B. The instances listen on different IP addresses.

Highly voted

C. The instances use different socket names.

D. The instances have appropriate net masks set.

Discussion of the question

Question 111 🔥

What does the slave I/O thread do?

Which database solution meets these requirements?

A. connects to the master and requests it to send updates recorded in its binary logs

B. monitors and schedules I/O calls to the subsystem for the relay logs

C. acquires a lock on the binary log for reading each event to be sent to the slave

D. reads the relay log and executes the events contained in them

Discussion of the question

Question 112 🔥

You have an installation of MySQL 8 on Oracle Linux.Consider the outputs:Which statement is true about disk temporary tables for this installation?

Which database solution meets these requirements?

A. Only internal temporary tables from the optimizer will be created in tmpdir.

B. Temporary tables will use the InnoDB temporary tablespace located in datadir.

Highly voted

C. Temporary tables are created in tmpdir only if configured to use MyISAM.

D. Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

E. Temporary tables will use the InnoDB temporary tablespace located in /tmp.

Discussion of the question

Question 113 🔥

Which three are requirements for a secure MySQL Server environment? (Choose three.)

Which database solution meets these requirements?

A. Restrict the number of OS users that have access at the OS level.

Highly voted

B. Ensure appropriate file system privileges for OS users and groups.

Highly voted

C. Minimize the number of non-MySQL Server-related processes running on the server host.

Highly voted

D. Encrypt the file system to avoid needing exact file-system permissions.

E. Keep the entire software stack on one OS host.

F. Run MySQL server as the root user to prevent incorrect sudo settings.

Discussion of the question

Question 114 🔥

Examine this parameter setting:audit_log=FORCE_LOG_PERMANENTWhat effect does this have on auditing?

Which database solution meets these requirements?

A. It will force the load of the audit plugin even in case of errors at server start.

B. It causes the audit log to be created if it does not exist.

C. It prevents the audit plugin from being removed from the running server.

D. It prevents the audit log from being removed or rotated.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_908

Exam contains 143 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us