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

Page 3 of 36
PDF with 228 Questions

Which statement is true about InnoDB persistent index statistics?

  1. Updating index statistics is an I/O expensive operation.
  2. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
  3. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
  4. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
  5. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
  6. Tables are scanned and index statistics recalculated when an instance is restarted.

Answer(s): D


Reference:

https://mariadb.com/kb/en/innodb-persistent-statistics/



Which two are features of MySQL Enterprise Firewall? (Choose two.)

  1. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
  2. blocking of potential threats by configuring pre-approved whitelists
  3. modifying SQL statement dynamically with substitutions
  4. automatic locking of user accounts who break your firewall
  5. provides stateless firewall access to TCP/3306

Answer(s): A,B



Examine the modified output:



Seconds_Behind_ Master value is steadily growing.
What are two possible causes? (Choose two.)

  1. The master is most probably too busy to transmit data and the slave needs to wait for more data.
  2. One or more large tables do not have primary keys.
  3. This value shows only I/O latency and is not indicative of the size of the transaction queue.
  4. The master is producing a large volume of events in parallel but the slave is processing them serially.
  5. The parallel slave threads are experiencing lock contention.

Answer(s): C,D



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. PREFERRED
  2. VERIFY_CA
  3. REQUIRED
  4. VERIFY_IDENTITY

Answer(s): C


Reference:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api- management/api- gateway/10-0/install-configure-upgrade/enable-ssl-connections-for-mysql.html



Viewing page 3 of 36



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

1z0-908 Exam Discussions & Posts