Question No : 1
When creating a FOREIGN KEY constraint, what SQL variable must be specified?
A. UNIQUE PRIMARY KEY values for both child and parent tables
B. a REFERENCE in the child table to the parent table
C. the SET_FOREIGN_KEY variable in the my.cnf file
D. an INDEX on the FOREIGN KEY
E. a TRIGGER on the child table for cascading DELETE statements
Answer: E
Question No : 2
A keyfile has been generated as follows:
# openssl rand 32 –hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.Which option can perform the backup with the keyfile provided in order to encrypt the backup files?
A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile - -
backup-dir=/var/tmp/backup backup-to-image
B. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup
C. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile -
- backup-dir=/var/tmp/backup backup-to-image
D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile - -
backup-dir=/var/tmp/backup backup-to-image
E. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup – timestamp backup
Answer: D
Oracle 1z0-320
Exam dumps - Get Oracle 1z0-320 PDF with Actual Questions Answers
Question No : 3
Identify two features of MySQL Enterprise Firewall.
A. You set the firewall per database.
B. You can automatically delete a user if the user breaks your firewall.
C. You can block out potential threats by setting up a preapproved whitelist.
D. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.
E. You can modify a request with a SQL statement substitution.
Answer: C,D
Question No : 4
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 datadir=/app/mysql/data is needed.
B. The configuration basedir=/app/mysql/bin is needed.
C. The configuration log-bin=/app/data is needed.
D. The configuration datadir=/app/data is needed.
E. The configuration innodb_log_group_home_dir=/datadir is needed.
F. The configuration basedir=/app/mysql is needed.
Answer: B,D
Latest
Oracle 1z0-320 Questions & 2018 Oracle 1z0-320 Latest Exam Topics
Question No : 5
Identify an example of creating an Enterprise Encryption function.
A. SET@function = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len);
B. VALIDATE FUNCTION create_asymmetric_priv_key WITH ‘openssl_udf.so’;
C. INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(‘RSA’,
1024));
D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME‘openssl_udf.so’;
Answer: D
Question No : 6
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.
Answer: B
Oracle
1z0-320 Actual Dumps - Valid Oracle 1z0-320 Braindumps Questions &
Answers
Question No : 7
You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?
SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= ‘JHacker’ OR 1=1;
A. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode.
B. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement.
C. Create a list of approved SQL users by using the INTERROGATION mode.
D. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.
Answer: D
Question No : 8
You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.Which syntax accomplishes this?
A. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
B. CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’;GRANT
RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP,
UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE,
INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO
‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* TO
‘mysqlbackup’@’localhost’;GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost;GRANT
PROCESS ON *.* ‘mysqlbackup’@’localhost’;
C. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT
RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP,
UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE,
INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO
‘mysqlbackup’@localhost’;
D. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT
RELOAD ON *.* to ‘mysqlbackup’@localhost’;GRANT CREATE, INSERT, DROP,
UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE,
INSERT, SELECT, DROP, UPDATE ONmysql.backup_history TO
‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* to
‘mysqlbackup’@’localhost’;GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’;GRANT
PROCESS ON *.* TO ‘mysqlbackup’@’localhost’;GRANT LOCK TABLES, SELECT,
CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT,
DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’;
E. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;GRANT
RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;GRANT CREATE, INSERT, DROP,
UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;GRANT CREATE,
INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO
‘mysqlbackup’@’localhost’;GRANT REPLICATION CLIENT ON *.* TO
‘mysqlbackup’@’localhost’;
Answer: A
Dumps4Download
Oracle 1z0-320 Accurate Study Material & Oracle 1z0-320 Valid Questions
Question No : 9
You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted.What steps would you perform to create a new audit file?
A. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
B. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.
C. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted file. Restart the MySQL server.
D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.
Answer: C
Question No : 10
The slave connects to the master and asks for updated records. What command was issued for this to happen?
A. RUN SLAVE
B. START RUN SLAVE
C. SLAVE RUN
D. SLAVE START
E. START SLAVE
Answer: D
Pass
Oracle 1z0-320 Exam Questions - Get Actual Oracle 1z0-320 Dumps 2018
