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

  • 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 #11
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?
  1. A
    MySQL server was not started due to a problem while executing process 2732.
  2. B
    MySQL server continued to start up even though another process existed.
  3. C
    systemd found the mysqld service disabled and failed to start it.
  4. D
    systemd waited for 30 seconds before timing out and start up failed.
  5. E
    systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Correct Answer:
E

Question #12
Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
  1. A
    Connection 24 experiences a lock wait timeout.
  2. B
    Connection 25 experiences a lock wait timeout.
  3. C
    A deadlock occurs immediately.
  4. D
    All statements execute without error.
  5. E
    A deadlock occurs after innodb_lock_wait_timeout seconds.

Correct Answer:
E

Question #13
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path
Which activity is performed?
  1. A
    MySQL Router is configured based on the information in files in directory_path.
  2. B
    MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
  3. C
    MySQL Router is restarted.
  4. D
    MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Correct Answer:
B

Question #14
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO ‘user1’;
How can you proceed with your transaction with the least interruption?
  1. A
    Roll back the transaction and start the transaction again in the same session.
  2. B
    Re-execute the failed statement in your transaction.
  3. C
    Change the default database and re-execute the failed statement in your transaction.
  4. D
    Close the connection, reconnect, and start the transaction again.

Correct Answer:
B

Question #15
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?
  1. A
    The statement was blocked by MySQL Firewall.
  2. B
    John has not activated the role.
  3. C
    John needs to reconnect to the database.
  4. D
    The DBA needs to execute FLUSH PRIVILEGES.

Correct Answer:
B

Previous Questions Next Questions

All Pages