http://https://www.lead1pass.com/Oracle/1z0-320-practice-exam-dumps.html (80 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 6
You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?
A. A MySQL Cluster backup process will be kick-started automatically.
B. The entire cluster will be shut down.
C. Components from one of the machines will be chosen as victim. Only one machine will provide service.
D. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
E. The MySQL Cluster service will be pause. After the network is online, the MySQL Cluster service will be resumed.
Answer: E
Section: (none)

NEW QUESTION NO: 7
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.
A. Email
B. SMS
C. Notification tab on the dashboard
D. Browser pop-ups
E. Direct support call from an Oracle representative
Answer: A,B,C
Section: (none)

NEW QUESTION NO: 8
For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client.
Identify the correct steps.
A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.
B. Convert the private key to ppk format first, and use the new private key for authentication.
C. Use the provided private key for authentication.
D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
Answer: D
Section: (none)

NEW QUESTION NO: 9
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?
A. 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
B. 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';
C. 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;
D. 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
E. 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
Answer: C,E
Section: (none)

NEW QUESTION NO: 10
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
Section: (none)
Explanation/Reference:

NEW QUESTION NO: 11
Identify three levels in which MySQL Enterprise Monitor provides access control.
A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
B. Asset visibility: the rights to access data collected from hosts or MySQL instances
C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
D. Specific data access: the rights to view specific types of potentially sensitive data
E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
Answer: B,C,D
Section: (none)
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-acl-users-roles-ref.html

NEW QUESTION NO: 12
After the installation of the MySQL Server, you cannot find MySQL Utilities.
How would you correct the problem?
A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.
B. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.
C. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.
D. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.
E. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.
Answer: E
Section: (none)
Explanation/Reference:
Reference: https://dev.mysql.com/doc/workbench/en/wb-mysql-utilities.html

NEW QUESTION NO: 13
How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?
A. Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.
B. You cannot deny access to a user based on his or her username.
C. CREATE USER 'joe'@%' DENY ALL PRIVILEGES
D. UPDATE mysql.user SET Password=PASSWORD ('Invalid') WHERE User= 'joe';
E. CREATE USER 'joe'@'0.0.0.0'SET Password=PASSWORD ('%!%')
Answer: A
Section: (none)

NEW QUESTION NO: 14
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.
B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.
C. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file.
D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
Answer: A
Section: (none)
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html

NEW QUESTION NO: 15
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
Section: (none)
Explanation/Reference:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key- constraints

NEW QUESTION NO: 16
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?
A. Sort the "Exec" column and check for SQL queries with high QRTi values.
B. Sort the "Exec" column and check for SQL queries with low QRTi values.
C. Look for queries with low latency times in the Latency section in the times series graph (Query Analyzer.)
D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)
Answer: C
Section: (none)