Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-908

Free Oracle 1z0-908 Exam Questions (page: 6)

Page 6 of 36
PDF with 228 Questions

Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

  1. It reconfigures InnoDB Cluster if the cluster was stopped.
  2. It performs InnoDB Cluster instances rolling restart.
  3. It only starts all InnoDB Cluster instances.
  4. It is not mandatory that all instances are running and reachable before running the command.
  5. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
  6. It only stops and restarts all InnoDB Cluster instances.
  7. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Answer(s): B,D



Which two statements are true about MySQL server multi-source replication? (Choose two.)

  1. It is not compatible with auto-positioning.
  2. It needs to be re-instanced after a crash to maintain consistency.
  3. It uses only time-based replication conflict resolution.
  4. It relies on relay_log_recovery for resilient operations.
  5. It does not attempt to detect or resolve replication conflicts.
  6. It must use GTID replication.

Answer(s): C,F



Which command enables rule-based MySQL Auditing capabilities?

  1. shell> mysql < audit_log_filter_linux_install.sql
  2. shell> mysqld --initialize --log-raw=audit.log
  3. mysql> INSTALL PLUGIN audit_log;
  4. mysql> INSTALL COMPONENT audit_log;

Answer(s): A


Reference:

https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html



Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two are true? (Choose two.)

  1. Mark can grant the privileges assigned to the r_read@localhost role to another user.
  2. ADMIN OPTION causes the role to be activated by default.
  3. Mark can grant the r_read@localhost role to another user.
  4. Mark can revoke the r_read@localhost role from another role.
  5. ADMIN OPTION allows Mark to drop the role.
  6. Mark must connect from localhost to activate the r_read@localhost role.

Answer(s): C,D

Explanation:

https://dev.mysql.com/doc/refman/8.0/en/grant.html



Viewing page 6 of 36



Post your Comments and Discuss Oracle 1z0-908 exam prep with other Community members:

1z0-908 Exam Discussions & Posts