Create Next App

Exam contains 143 questions

Page 10 of 24

Question 55 🔥

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

Which database solution meets these requirements?

A. dba.configureInstance()

Highly voted

B. cluster.setPrimaryInstance()

Highly voted

C. dba.configureLocalInstance()

Highly voted

D. cluster.forceQuorumUsingPartitionOf()

Highly voted

E. cluster.addInstance()

Highly voted

F. dba.createCluster()

Highly voted

G. dba.checkInstanceConfiguration()

Highly voted

Discussion of the question

Question 56 🔥

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

Which database solution meets these requirements?

A. It fails if any of the roles is specified in the mandatory_roles variable.

Highly voted

B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

Highly voted

C. Existing connections can continue to use the roles’ privileges until they reconnect.

Highly voted

D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

Highly voted

E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

Highly voted

F. It fails if at least one of the roles does not exist.

Highly voted

Discussion of the question

Question 57 🔥

Examine these statements and output:Which statement is true?

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

C. The user is authorized as the accounting@localhost user.

Highly voted

D. The user is authorized as the rsmith@localhost user.

Highly voted

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

Highly voted

Discussion of the question

Question 58 🔥

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

Which database solution meets these requirements?

A. It supports only non-blob datatypes.

Highly voted

B. It does not support the transportable tablespaces feature.

Highly voted

C. It supports all indexes transparently.

Highly voted

D. It decrypts data for use in memory.

Highly voted

E. It enforces encryption from disk to memory and over network transmission.

Highly voted

Discussion of the question

Question 59 🔥

You plan to install MySQL Server by using the RPM download.Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. You can provide the root password interactively.

Highly voted

B. You must manually initialize the data directory.

Highly voted

C. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

Highly voted

D. MySQL uses the RPM relocatable installation target feature.

Highly voted

E. The functionality is split among several RPM package files.

Highly voted

F. You can find the root password in the error log after the first start.

Highly voted

Discussion of the question

Question 60 🔥

Examine this statement, which executes successfully:You want to improve the performance of this query:Which change enables the query to succeed while accessing fewer rows?

Which database solution meets these requirements?

A. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

Highly voted

B. ALTER TABLE world.city ADD SPATIAL INDEX (Population);

Highly voted

C. ALTER TABLE world.city ADD INDEX (Population);

Highly voted

D. ALTER TABLE world.city ADD INDEX (Name);

Highly voted

E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

Highly voted

F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Highly voted

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