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

  • 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 #6
Which two are features of MySQL Enterprise Firewall? (Choose two.)
  1. A
    recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
  2. B
    blocking of potential threats by configuring pre-approved whitelists
  3. C
    modifying SQL statement dynamically with substitutions
  4. D
    automatic locking of user accounts who break your firewall
  5. E
    provides stateless firewall access to TCP/3306

Correct Answer:
BC

Question #7
Examine the modified output:

Seconds_Behind_ Master value is steadily growing.
What are two possible causes? (Choose two.)
  1. A
    The master is most probably too busy to transmit data and the slave needs to wait for more data.
  2. B
    One or more large tables do not have primary keys.
  3. C
    This value shows only I/O latency and is not indicative of the size of the transaction queue.
  4. D
    The master is producing a large volume of events in parallel but the slave is processing them serially.
  5. E
    The parallel slave threads are experiencing lock contention.

Correct Answer:
CD

Question #8
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?
  1. A
    PREFERRED
  2. B
    VERIFY_CA
  3. C
    REQUIRED
  4. D
    VERIFY_IDENTITY

Correct Answer:
C

Question #9
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
  1. A
    kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
  2. B
    kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
  3. C
    kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
  4. D
    mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Correct Answer:
C

Question #10
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
  1. A
    installing and configuring the Connection Control plugin
  2. B
    avoiding concatenation of SQL statements and user-supplied values in an application
  3. C
    using stored procedures for any database access
  4. D
    using PREPARED STATEMENTS

Correct Answer:
C

Previous Questions Next Questions

All Pages