Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 1

Question - 15 Maximum mark : - 27

Home
All Exams
Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Online Mock Tests
Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 1

Consider the following GRANT statement: GRANT USAGE ON *.* TO 'kofi'@'localhost' IDENTIFIED BY 'password' What is the implications of executing that statement?

Kofi can access all database objects. ✘ Kofi can access all his tables ✘ Kofi can display server system and status variables ✘ Kofi can grant privileges to others ✔ Kofi can access all database objects belonging to localhost ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Should all queries in the slow query log be optimized?

Yes. Yes, unless they depend on tables in the mysql database No; A query may have been entered into the slow query log because other, slow queries,prevented it from executing quickly No; Queries that are run rarely are probably not worth the effort of optimization No; Only the very slowest queries should be optimized

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Assuming that the user account 'joe'@'example.com' exists, executing DROP USER 'joe'@'example.com' has the following consequences:

The user account will immediately be removed from the server, if no object-level privileges are in effect for that account ✘ The account will be removed from the server the next time FLUSH PRIVILEGES is executed,if no object-level privileges are in effect for that account ✘ The account and all associated privileges will immediately be removed from the server ✘ The user account and all associated privileges will be removed from the server the next timeFLUSH PRIVILEGES is executed. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database?

GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%'; ✘ GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%' ✘ GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%' ✘ GRANT (SELECT, INSERT, DELETE, UPDATE) ON world.* TO 'kofi'@'%' ✔ Unless using ALL PRIVILEGES, it is not possible to assign more than one type of privilege atany one time. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table world.City to it and preload the index?

Mysql> SET GLOBAL city_cache.key_buffer_size = 4194304; mysql> CACHE INDEX world.City IN city_cache; mysql> LOAD INDEX INTO CACHE world.City; ✘ Mysql> ALTER TABLE world.city KEY_CACHE = 4194304; ✘ Mysql> CREATE CACHE FOR world.City SIZE = 4194304; ✘ It is not possible to create a key cache for a specific MyISAM table, only the global key cachecan be used. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider the following two partial outputs of the SHOW VARIABLES command on a master and slave server: Master: +--------------------------+---------------------------+ | Variable_name | Value | +--------------------------+---------------------------+ | connect_timeout | 5 | | log_bin | ON | | max_connections | 100 | | shared_memory_base_name | MYSQL | | server_id | 2 | | tmp_table_size | 5242880 | | version | 5.0.13-rc-nt | Slave: +--------------------------+---------------------------+ | Variable_name | Value | ---------------------------+---------------------------+ | connect_timeout | 5 | | log_bin | ON | | max_connections | 10 | | shared_memory_base_name | MYSQL | | server_id | 2 | | tmp_table_size | 4266336 | | version | 5.0.16-rc-nt | There is apparently a problem with the slave replicating from the master. Which of the following best describes the most likely problem?

The server_id is not unique. ✘ The version of the slave is newer than the version of the master. ✘ The connect_timeout variable needs to be increased. ✘ The max_connections variable needs to be increased. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?

Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups. ✘ Because InnoDB uses primary keys to locate table rows, and shorter keys make quickerlookups. ✘ Because InnoDB stores pointers in a log to all the primary keys and shorter keys make thislog smaller. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following best describes the order in which MySQL considers host names and user names when a client attempts connection?

Hostnames then usernames ✘ Usernames then hostnames ✘ Both hostnames and usernames are checked concurrently. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Is it possible to tell the MySQL server to throw an error on illegal dates rather than converting it to zero-date or legal dates?

Yes, by updating a system variable. ✘ No, it has to be done programmatically. ✘ Yes, there is a SQL mode that exists for that. ✘ No, all illegal date are converted regardless of any setting. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You have two databases, db1 and db2 and you have a table test in both of the databases. Your current default database is db1. Which of the following tables will be affected by the following command? mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test TO 'joe'@'%' IDENTIFIED BY 'sakila'

Db1.test ✘ Db2.test ✘ Both db1.test and db2.test ✘ The statement will return an error, because no database was specified. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner