1z1-320 試験問題を無料オンラインアクセス

Which two methods can change password expiration for a database user account? (Choose two.)

• A.Create a new database user account with an explicit password expiration time
• B.Update the my.cnf configuration to include default_password_lifetime=100 and restart the server
• C.Use the SET GLOBAL command to update the default password expiration time
• D.Use an ALTER USER command to change the password expiration

What command should be used to execute a stored procedure named run_daily_report with the parameter
2016/12/31?

• A.SELECT SP run_daily_report ('2016/12/31') from mysql.procedures;
• B.EXECUTE PROC run_daily_report INCLUDE PARAMETER ('2016/12/31');
• C.UPDATE PROCEDURE run_daily_report WHERE VARIABLE = ("2016/12/31');
• D.CALL run_daily_report ('2016/12/31');

Your customer wants you to install and configure MySQL on the customer's Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.
What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer's requirement?

• A.The configuration basedir=/app/mysql is needed.
• B.The configuration datadir=/app/data is needed.
• C.The configuration log-bin=/app/data is needed.
• D.The configuration innodb_log_group_home_dir=/datadir is needed.
• E.The configuration basedir=/app/mysql/bin is needed.
• F.The configuration datadir=/app/mysql/data is needed.

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A.CREATE TABLE City_part AS SELECT * FROM City;
• B.CREATE TABLE City_part LIKE City;
• C.CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
• D.INSERT INTO City_part SELECT * FROM City;

Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

• A.mysqlreplicatems
• B.mysqlreplicate
• C.mysqlrplcheck
• D.mysqlrpladmin
• E.mysqlrplms