1z0-883 by Oracle Actual Free Exam Questions And Answers

Question 1

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

A. MySQL Replication

B. Distributed Replication Block Device

C. MySQL Cluster

D. Windows Server Failover Clustering

Discussion 0

Correct Answer: A Vote an answer

Question 2

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?

A. Disconnecting idle localhost client sessions

B. Relocating your data and log files to separate storage devices

C. Activating the MySQL Enterprise thread pool plugin

D. Implementing storage engine data compression options

Discussion 0

Correct Answer: A Vote an answer

Question 3

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?

A. FLUSH PRIVILEGES;

B. GRANT USAGE ON *.* TO 'admin'@'%';

C. FLUSH HOST CACHE;

D. UPDATE mysql.user SET Create_user_priv = 'Y' WHERE user= 'admin';

E. CREATE USER 'admin' @'%';

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

Which two statements are true regarding partitioning in Mysql?

A. Tables with BLOB and TEXT columns cannot be partitioned.

B. Partitioning allows different columns to be stored in separate files.

C. The partitioning expression is an integer or function that returns an integer value or NULL value.

D. Partitioning is only available for those storage engines that implements it natively.

E. Partitioning allows easier management of smaller data sets for certain queries.

Discussion 0

Correct Answer: B,C Vote an answer

Question 5

Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?

A. Using the statement RESET PERFORMANCE CACHE;

B. Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;

C. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;

D. Using the statement FLUSH PERFORMANCE CACHE;

E. Restarting Mysql

F. Disabling and re-enabling all instruments

Discussion 0

Correct Answer: B,F Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Consider the Mysql Enterprise Audit plugin.
Which statement is true when you identify a connection event that has used external authentication?

A. The attribute "PRIV_USER" contains the username.

B. The attribute "STATUS" is set to the string EXTERNAL_AUTH.

C. External authentication is managed through external auditing logs.

D. The event type that is given in the attribute "NAME" is EXTERNAL_AUTH.

E. The "PROXY_PRIV" user shows a username if external authentication is used.

F. There is no differentiation between native and external authentication events.

Discussion 0

Correct Answer: D Vote an answer

Question 7

You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?

A. Shell> pkill -u mysql mysqld_safe

B. Mysql> STOP PROCESS mysqld;

C. Shell> net stop mysql

D. Shell> nmc mysql shutdown

E. Shell> service mysql safe_exit

F. Shell> /etc/init.d/mysql stop

G. Shell> mysqladmin -u root -p shutdown

Discussion 0

Correct Answer: C,F,G Vote an answer

Question 8

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

A. Mysqldumpslow

B. Mysqlshow

C. Mysqlslow

D. Mysqlaccess

E. Mysqldump

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?

A. Disabling connections from named pipes or socket files (depending on the operating system of the server)

B. Enabling and using SSL for connections to the Mysql database

C. Limiting logins to originate from the application server or the server's subnet

D. Installing Mysql on the application server, and running the database and application on the same server

E. Starting the server with - bind- address=0.0.0.0 specified

F. Running the server with - skip-networking specified

Discussion 0

Correct Answer: B,D Vote an answer

Question 10

You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' connot be loaded: plugin not enabled
What would you run to fix the issue?

A. The mysql client with the - enable-cleartext-plugin option

B. The install plugin command for the mysql_cleartext_password plugin

C. The mysql_secure_installation script to update server security settings

D. The mysql_upgrade script

E. The mysql client with the - ignore-password-hashing option

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle MySQL 5.6 Database Administrator - 1z0-883 Exam Practice Test

Contact Us

Useful Links

Latest Updated