Latest Oracle 1z0-883 Actual Free Exam Questions & Community Discussion, Page 3

Question #21

Which two statements are true regarding partitioning in Mysql?

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

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

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

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question #22

You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files?

A. Remove all of the binary log files that have a modification date earlier than today.

B. Execute the PURGE BINARY LOGE NOT USED command.

C. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

D. Ensure that none of the attached slaves are using any of the binary logs you want to delete.

E. Edit the .index file to remove the files you want to delete.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #23

Which three statements are characteristic of the MEMORY storage engine?

A. It can support transactions

B. Table contents are not saved if the server is restarted.

C. It cannot contain text or BLOB columns.

D. Each table is represented on disk as an.frm file.

E. It can support foreign keys.

F. Each table has a corresponding.MYI and .MYD file.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #24

You are investigating the performance of the server and see the following information:
-Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
-The table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?

A. Increase the value of table_open_cache.

B. Decrease the value of table_open_cache.

C. Increase the value of table_open_cache_instances.

D. Increase the value of table_definition_cache.

E. Decrease the value of table_open_cache_instances.

F. Decrease the value of table_definition_cache.

Discussion 0

Correct Answer: A Vote an answer

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

Question #25

The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE 'validate_password%';

When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD ('Hoverl@%');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?

A. The password is eight characters long, but needs to exceed validate_password_length to be valid.

B. All of the MEDIUM password policy requirements have not been honored.

C. The password matches a substring Hover as a dictionary word.

D. There is no dictionary file defined, so password validation cannot work as expected.

E. The password does not match the validate_passoword_number_count requirement.

Discussion 0

Correct Answer: B Vote an answer

Question #26

You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?

A. Restore the backup to another databases instance and obtain a copy of the reports table individually.

B. Extract the 'apps' . 'reports' table from the backup using the SOURCE command.

C. Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.

D. Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'

Discussion 0

Correct Answer: A Vote an answer

Question #27

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

A. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.

B. The command prints all parameters for the login-path. The password is shown only when you provide the -password option.

C. The command prints all parameter for the login-path. The password is replaced with stars.

D. The command prints all parameters for the login-path. The password is printed in plain text.

Discussion 0

Correct Answer: C Vote an answer

Question #28

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 - ignore-password-hashing option

B. The mysql_secure_installation script to update server security settings

C. The mysql_upgrade script

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

E. The install plugin command for the mysql_cleartext_password plugin

Discussion 0

Correct Answer: D Vote an answer

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

Question #29

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

A. If no indexes exist, a hidden clustered index is generated based on row IDs.

B. A primary key must exist for creation of a clustered index.

C. The first unique index is always used as a clustered index and not a primary key.

D. A clustered index provides direct access to a page containing row data.

E. A clustered index allows fulltext searching within InnoDB,

F. A primary key is used as a clustered index.

G. A clustered index is a grouping of indexes from different tables into a global index for faster searching.

Discussion 0

Correct Answer: A,E,F Vote an answer

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

Question #30

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:
$ pidof mysqld
$tail - n2 /var/lib.mysql/hostname.err
2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.13-enterprise-commercial-advaced' socket: '/tmp/mysql.sock' port;
3306 Mysql Enterprise Server - Advanced Edition (Commercial)
You attempt to log in as the root user with the following command:
$mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Which statement is true about this scenario?

A. The mysql_install_bd post-installation script used - random-password.

B. The local root user must log in with a blank password initially: mysql -u root -p.

C. New security measures mean that the mysql_secure_installation script must be run first on all new installations.

D. The RPM installation script sets a default password of password for new installations.

Discussion 0

Correct Answer: B Vote an answer

Oracle 1z0-883 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-883 Demo