1Z0-874 Online Practice Questions and Answers

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?

A. The administrator forgot to revoke your UPDATE privilege

B. The administrator forgot to revoke your SELECT privilege

C. The administrator removed the DELETE privilege by performing an UPDATE directly on the mysql.table_priv table

D. The administrator did not execute FLUSH PRIVILEGES

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'

A. db1.test

B. db2.test

C. Both db1.test and db2.test

D. The statement will return an error, because no database was specified.

Which of the following are true regarding the usage of the IDENTIFIED BY clause in the GRANT statement used to create a new user account?

A. There is no IDENTIFIED BY clause for the GRANT statement

B. The IDENTIFIED BY clause is always optional

C. The IDENTIFIED BY clause is always mandatory

D. The IDENTIFIED BY clause may be mandatory depending on the current SQL mode

E. The IDENTIFIED BY clause specifies the password to be used with the account

F. The IDENTIFIED BY clause specifies an alternate user name for the account

To prevent users from seeing the password used for FEDERATED tables, you should...

A. not grant them privileges to execute SHOW CREATE TABLE for this table.

B. not grant them privileges to execute SHOW CONNECTION for this table. C. not grant them privileges to execute SHOW TABLE STATUS for this table.

C. not grant them privileges to execute SHOW CONNECTION STRING for this table.

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?

A. Yes, by updating a system variable.

B. No, it has to be done programmatically.

C. Yes, there is a SQL mode that exists for that.

D. No, all illegal date are converted regardless of any setting.

Consider the following:

mysql> SELECT * FROM CountryLanguages;

+----+---------------+-------------+----------+

| ID | CountryName | CountryCode | Language |

+----+---------------+-------------+----------+

| 1 | United States | USA | English |

| 2 | United States | USA | Spanish |

| 3 | Mexico | MEX | Spanish |

| 4 | Canada | CAN | English |

| 5 | Canada | CAN | French |

+----+---------------+-------------+----------+

Which of the following describe how this table would look correctly normalized?

A. Table Countries: CountryCode, CountryNameTable Languages: LanguageID, LanguageTable CountryLanguage: CountryCode, LanguageID

B. Table Countries: CountryCode, CountryNameTable Languages: LanguageID, CountryCode, Language

C. Table Countries: CountryCode, CountryName, LanguageIDTable Languages: LanguageID, Language

D. Table Countries: CountryCode, CountryNameTable Languages: LanguageID, CountryCodeTable CountryLanguage: LanguageID, CountryCode, Language

Why should one preferably group multiple statements for InnoDB tables within a transaction whenever it is possible?

A. It minimizes bandwidth usage.

B. It helps keep log file sizes down.

C. It minimizes the amount of flush operations needed.

D. It helps reduce the chance of the transaction failing due to a bad query.

Which of the following best describes the purpose of the InnoDB buffer pool?

A. It caches data and index information for InnoDB tables.

B. It is the amount of buffers available during a transaction.

C. It holds changes made during a transaction before they are written to the log.

Which of the following steps are used to create database symbolic links on Windows?

A. Stop the server.

B. Restart the server.

C. Use the ln -s command.

D. Update your my.ini with the path to the new location.

E. Move the database directory from the data directory to a new location.

F. Create a file in the data directory with the database name with an extension of .sym that contains the full path to the new location.

Which of the following are general features of replication?

A. Can be used to distribute the load caused by servicing many clients.

B. Provides complete redundancy and high availability at all times.

C. Multiple copies are available in case a server crashes or goes offline.

D. Allows the databases on one server to be made available on another server.