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

Page 4 of 36
PDF with 228 Questions

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. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
  2. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
  3. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
  4. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Answer(s): C



You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

  1. installing and configuring the Connection Control plugin
  2. avoiding concatenation of SQL statements and user-supplied values in an application
  3. using stored procedures for any database access
  4. using PREPARED STATEMENTS

Answer(s): C


Reference:

https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql- injection-attacks/



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. MySQL server was not started due to a problem while executing process 2732.
  2. MySQL server continued to start up even though another process existed.
  3. systemd found the mysqld service disabled and failed to start it.
  4. systemd waited for 30 seconds before timing out and start up failed.
  5. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer(s): E



Examine these entries from the general query log:



All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements?

  1. Connection 24 experiences a lock wait timeout.
  2. Connection 25 experiences a lock wait timeout.
  3. A deadlock occurs immediately.
  4. All statements execute without error.
  5. A deadlock occurs after innodb_lock_wait_timeout seconds.

Answer(s): E



Viewing page 4 of 36



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

1z0-908 Exam Discussions & Posts