Free Oracle 1Z0-908 Exam Questions

Become Oracle Certified with updated 1Z0-908 exam questions and correct answers

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart

Question 1

On a master server that is using Statement-based replication a table of log data has become very large. You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A : the LIMIT clause to limit the deletion to 100,000 rows.

B : ange the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

C : Use the LIMIT clause in conjunction with the ORDER BY clause.

D : the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Answer: B,C

Question 2

Which three statements are true about memory buffer allocation by a MySQL Server? (Choose three.)

A : obal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B : read buffers are allocated when a client connects, and are freed when the client disconnects.

C : ffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D : er buffers are allocated at server startup and freed when the user is dropped.

E : l dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Answer: A,C

Question 3

You want to shutdown a running Mysql Server cleanly.

Which three commands that are valid on either Windows or Linux will achieve this?

A : ell> pkill –u mysql mysqld_safe

B : ell> service mysql safe_exit

C : ell> /etc/init.d/mysql stop

D : ell> mysqladmin –u root –p shutdown

E : ql> STOP PROCESS mysqld;

F : ell> net stop mysql

G : ell> nmc mysql shutdown

Answer: A,C,D

Question 4

You execute mysqladmin shutdown on a MySQL server that is decribed as follows:

- It is running with both active and idle client connections.

- It has open transactions against InnoDB.

- It has active multi-row inserts into MyISAM engine tables.

- Innodb_fast_shitdown is set to 1.

What are three effects of shutting down the server by using a mysqladmin shutdown command?

A : nnections that have an open transaction are rolled back.

B : nnections with statements running against MyISAM tables wait for completion.

C : w client connections are not accepted after shutdown is initiated.

D : nnections are accepted during the shutdown process because a graceful shutdown can take large amounts of time.

E : rtial updates may occur for non-transactional tables.

Answer: A,C

Question 5

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A : QUIRED

B : RIFY_CA

C : RIFY_IDENTITY

D : EFERRED

E : ABLED

Answer: A

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart