Download Oracle.1z0-320.CertKiller.2018-05-11.48q.tqb

Vendor:	Oracle
Exam Code:	1z0-320
Exam Name:	MySQL Cloud Service 2018 Implementation Essential
Date:	May 11, 2018
File Size:	222 KB
Downloads:	1

Download Exam

Demo Questions

You are requested to export data from a set of the following tables in the database ‘world_x’.

Tables (country, countryinfo, location)

Which two options would allow you to export data as files?

using MySQL Client and the - -dump option to dump the tables to files:
# mysql –u<user> -p –h<host> -P<port> -- dump world_x.country world_x.countryinfo world_x.location
using MySQL Client and EXPORT <table> TO <file> to export data one by one:
mysql>EXPORT world_x.country TO ‘/output/country.txt’;
mysql>EXPORT world_x.countryinfo TO ‘/output/countryinfo.txt’;
mysql>EXPORT world_x.location TO ‘/output/location.txt’;
using MySQL Client and SELECT …INTO OUTFILE ‘<filename>’ from <TABLE> to export data one by one:
mysql>select * into outfile ‘/output/country.txt’ from world_x.country;
mysql>select * into outfile ‘/output/countryinfo.txt’ from world_x.countryinfo;
mysql>select * into outfile ‘/output/location.txt’ from world_x.location;
using mysqlexport to export multiple tables in a database in one command line:
# mysqlexport –u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql
using mysqldump to dump multiple tables in a database in one command line:
# mysqldump –u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql

Correct answer: CE

Identify two features of MySQL Enterprise Firewall.

You set the firewall per database.
You can automatically delete a user if the user breaks your firewall.
You can block out potential threats by setting up a preapproved whitelist.
You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.
You can modify a request with a SQL statement substitution.

Correct answer: CD

Explanation:

Reference: https://www.mysql.com/products/enterprise/firewall/features.html

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.