Oracle 1z0-320 問題集

質問 1：
You execute the following statement SELECT NULL=NULL;
What is the result?
A. 0
B. FALSE
C. NULL
D. TRUE
E. 1
正解：B

質問 2：
What are security rules in Compute Cloud Service?
A. Security rules are data encryption levels that control who can see the data.
B. They are user-role designation that assign rights to certain users.
C. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.
D. These are rules established by HIPAA for securing end-user data.
E. They allow administrators access to applications in the cloud.
正解：C

質問 3：
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?
A. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)
B. Sort the "Exec" column and check for SQL queries with low QRTi values.
C. Sort the "Exec" column and check for SQL queries with high QRTi values.
D. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)
正解：D

質問 4：
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. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openssl_udf.so';
D. INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));
正解：C

質問 5：
You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Identify two reasons for this problem.
A. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
B. The MASTER and SLAVE are grouped as one instance for monitoring.
C. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
D. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
E. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
正解：B,D