Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-908

Oracle 1z0-908 Exam Practice Questions (P. 4)

  • Full Access (152 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
  1. A
    mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
  2. B
    mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
  3. C
    mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
  4. D
    mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Correct Answer:
D

Question #17
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
  1. A
    It reconfigures InnoDB Cluster if the cluster was stopped.
  2. B
    It performs InnoDB Cluster instances rolling restart.
  3. C
    It only starts all InnoDB Cluster instances.
  4. D
    It is not mandatory that all instances are running and reachable before running the command.
  5. E
    It stops and restarts all InnoDB Cluster instances and initializes the metadata.
  6. F
    It only stops and restarts all InnoDB Cluster instances.
  7. G
    It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Correct Answer:
BD

Question #18
Which two statements are true about MySQL server multi-source replication? (Choose two.)
  1. A
    It is not compatible with auto-positioning.
  2. B
    It needs to be re-instanced after a crash to maintain consistency.
  3. C
    It uses only time-based replication conflict resolution.
  4. D
    It relies on relay_log_recovery for resilient operations.
  5. E
    It does not attempt to detect or resolve replication conflicts.
  6. F
    It must use GTID replication.

Correct Answer:
CF

Question #19
Which command enables rule-based MySQL Auditing capabilities?
  1. A
    shell> mysql < audit_log_filter_linux_install.sql
  2. B
    shell> mysqld --initialize --log-raw=audit.log
  3. C
    mysql> INSTALL PLUGIN audit_log;
  4. D
    mysql> INSTALL COMPONENT audit_log;

Correct Answer:
A

Question #20
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
  1. A
    Mark can grant the privileges assigned to the r_read@localhost role to another user.
  2. B
    ADMIN OPTION causes the role to be activated by default.
  3. C
    Mark can grant the r_read@localhost role to another user.
  4. D
    Mark can revoke the r_read@localhost role from another role.
  5. E
    ADMIN OPTION allows Mark to drop the role.
  6. F
    Mark must connect from localhost to activate the r_read@localhost role.

Correct Answer:
AE

Previous Questions Next Questions

All Pages