Online Access Free 1z0-320 Exam Questions

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

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

When creating a FOREIGN KEY constraint, what SQL variable must be specified?

• A.a TRIGGER on the child table for cascading DELETE statements
• B.an INDEX on the FOREIGN KEY
• C.the SET_FOREIGN_KEY variable in the my.cnf file
• D.UNIQUE PRIMARY KEY values for both child and parent tables
• E.a REFERENCE in the child table to the parent table

You have a text file named "xyz.csv" exported from another system.

You are asked to import data to a MySQL Database table named "country".
The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

• A.Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv.
• B.Use the LOAD DATA INFILE syntax to load data into the database table.
• C.Convert the data into MDI and restore the MySQL data from it.
• D.Use mysqlimport to load the mycountry.csv data file with the --csv option specified.

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

• A.Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
• B.Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
• C.Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
• D.Go to the configuration section (MEM) and configure the default login credentials.

When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

• A.cloud-admin, oracle, and root
• B.root, opc-administrator, and oracle through sudo
• C.opc, oracle, and root (through sudo)
• D.administrator, opc, and oracle
• E.admin, ora-cloud, and oracle