Get real 1Z0-874 exam questions for better preparation

MYSQL 1Z0-874 Exam Overview:

MYSQL 1Z0-874 Exam Syllabus Topics:

MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II Sample Questions:

1. Which of the following best describe the purpose of the long_query_time variable?

A) It is used to tell the server the total CPU seconds that are allotted to a client connection before it shut down.
B) It is used to tell the server after how many seconds to abort a query.
C) It is used to tell the server when to log a query as slow.
D) It is used to see the time it took the last longest query to run.

2. Consider a stored procedure or function that is going to be executed. Which of the following statements are true? (Choose two)

A) First, the global privileges are checked, then the database level privileges, then the stored routine level privileges.
B) First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.
C) First, the database level privileges are checked, then the global privileges, then the stored routine level privileges.
D) If the stored routine contains commands that access other databases and tables, access control for these objects will also be processed.

3. Consider the following EXPLAIN output. mysql> EXPLAIN SELECT Name FROM City WHERE Population > 8000000 *************************** 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? (Choose three)

A) All 4079 rows of the table need to examined.
B) The Population column should be indexed.
C) No index could be used to perform the query.
D) The Name column should be indexed.
E) The query cannot be optimized any better.

4. You have been granted SELECT, INSERT and DELETE privileges on the table city in the world database. You log in, and exercise all your privileges without any problems. While you are still connected and doing work, the administrator removes your DELETE privileges and informs you by mail that you can no longer delete from table city. Being skeptical, you decided to test your privileges and realize that you still have them all. What is are the most likely causes of this? (Choose two)

A) The administrator did not execute FLUSH PRIVILEGES
B) The administrator forgot to revoke your UPDATE privilege
C) The administrator forgot to revoke your SELECT privilege
D) The administrator removed the DELETE privilege by performing an UPDATE directly on the mysql.table_priv table

5. When choosing hardware for your MySQL server, is memory important to MySQL and why? (Choose two)

A) No, because MySQL makes use of virtual memory on disks.
B) Yes, because more memory allows for less swapping by the operating system.
C) No, because MySQL makes more use of disks and processors than memory.
D) Yes, because more memory allows for larger buffers improving caching and reducing disk usage

Solutions: