Oracle 1Z0-874 dumps - 100% Pass Guarantee!

As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement:

GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com'

Which of the following best describe the effects of issuing this statement?

A. The account is not created, as you must always specify a password for new users

B. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.

C. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.

D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login

E. There is not enough information provided to determine the outcome of executing that statement.

Should all queries in the slow query log be optimized?

A. Yes.

B. Yes, unless they depend on tables in the mysql database

C. No; A query may have been entered into the slow query log because other, slow queries, prevented it from executing quickly

D. No; Queries that are run rarely are probably not worth the effort of optimization

E. No; Only the very slowest queries should be optimized

Consider the following EXPLAIN output. mysql> EXPLAIN SELECT Name FROM City WHERE Population > 8000000\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL

ref: NULL rows: 4079 Extra: Using where Which of the following statements are true?

A. The query cannot be optimized any better.

B. No index could be used to perform the query.

C. All 4079 rows of the table need to examined.

D. The Name column should be indexed.

E. The Population column should be indexed.

Which of the following statements are true?

A. A MERGE table cannot be used with compressed tables.

B. A MERGE table may span across compressed and uncompressed tables.

C. A MERGE table can only be a collection of either compressed or uncompressed tables.

Which of the following best describes what the connection backlog is and why it may need to be increased?

A. It may need to be increased on a server with a high rate of transactions.

B. The backlog is the queue of processes waiting to be processed on a server.

C. The backlog is the queue of network connections of clients waiting to connect.

D. It may need to be increased on a server with a high rate of client connections.