Oracle 1Z0-883 Free Practice Questions

Q1. 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 all parameters for the login-path. The password is printed in plain text. 

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 the encrypted entry for the login-path. The is only possible to see if an entry exists. 

View Answer

Q2. You use—login-path to access a MySQL server on a Linux installation. 

Which statement is true about the – login-path option that is created by using mysql_config_editor? 

A. All system users have access to the MySQL server via—login path local. 

B. __login-path can be used only for MySQL servers running on a local machine. 

C. __login-path allows you to provide login credentials without passing clear text passwords on the command line. 

D. When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later. 

View Answer

Q3. Consider the query: 

Mysql> SET @run = 15; 

Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) 

FROM iteminformation 

WHERE run=@run AND objective=’7.1’ 

GROUP BY objective,stage 

ORDER BY stage; 

The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation: 

This query is run several times in an application with different values in the WHERE clause in a growing data set. 

What is the primary improvement that can be made for this scenario? 

A. Execute the run_2 index because it has caused a conflict in the choice of key for this query. 

B. Drop the run_2 index because it has caused a conflict in the choice of key for this query. 

C. Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes. 

D. Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations. 

E. Add a composite index on (run,objective,stage) to allow the query to fully utilize an index. 

View Answer

Q4. What are three actions performed by the mysql_secure_installation tool? 

A. It prompts you to set the root user account password. 

B. It checks whether file permissions are appropriate within datadir. 

C. It asks to remove the test database, which is generated at installation time. 

D. It can delete any anonymous accounts. 

E. It verifies that all users are configuration with the longer password hash. 

View Answer

Q5. What is true regarding InnoDB locking? 

A. InnoDB row locks may be escalated to page or table-level locks. 

B. InnoDB only uses row locks, not page or table-level locks, 

C. InnoDB uses row and table-level locks, but row locks are not escalates, 

D. InnoDB locks only those rows that are updated. 

E. InnoDB uses row-level or table-level locks depending on the number of rows affected. 

View Answer

Q6. Which statement is true about using Microsoft Windows Cluster as a platform for Mysql? 

A. It is provided by means of IP- level disk replication. 

B. It is shared-nothing architecture. 

C. It implements High Availability by using the .NET Connector’s load balancing capabilities. 

D. It relies on the shared disk architecture being visible to both servers. 

View Answer

Q7. Consider typical High Availability (HA) solutions that do not use shared storage. 

Which three HA solutions do not use shared storage? 

A. Mysql Replication 

B. Distributed Replicated Block Device (DRBD) and Mysql 

C. Windows Cluster and Mysql 

D. Solaris Cluster and Mysql 

E. Mysql NDB Cluster 

View Answer

Q8. 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. Implementing storage engine data compression options 

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

D. Activating the MySQL Enterprise thread pool plugin 

View Answer

Q9. You have table ‘apps’,’userdata’ on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. 

You execute the following commands: 

ServerB commands: 

Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps 

Shell> mysql –u root –p –h server –e ‘ALTER TABLE ‘apps’,’userdata’ ENGINE=InnoDB;’ 

Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps 

What effect does the – order-by-primary argument have on the mysqldump command? 

A. It exports tables with the most indexes first to assist with import speeds. 

B. It ensures that unique indexes have no conflicts when the data is dumped. 

C. It orders by primary key to assist in speeding up importing to InnoDB tables. 

D. It must be specified so index data is dumped correctly when –on-create-info is used. 

View Answer

Q10. Which two statements describe the behavior of the server’s SQL mode? 

A. The server’s SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax. 

B. The server’s SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE. 

C. The server’s SQL mode can be changed at the session level with a SET SESSION sql_mode=”new_value” command. 

D. The server’s SQL mode, when globally set on a slave server, applies to events sent from the master. 

View Answer

Q11. Which two statements are true regarding partitioning in Mysql? 

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

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

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

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. 

View Answer

Q12. Which three are properties of the MyISAM storage engine? 

A. Transaction support 

B. FULLTEXT indexing for text matching 

C. Table and page level locking support 

D. Foreign key support 

E. Geospatial indexing 

F. HASH index support 

G. Table level locking only 

View Answer

Q13. Consider the following statement on a RANGE partitioned table: 

ALTER TABLE orders DROP PARTITION p1, p3; 

What is the outcome of executing the above statement? 

A. Only the first partition (p1) will be dropped as only one can be dropped at any time. 

B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged. 

C. A syntax error will result as you cannot specify more than one partition in the same statement. 

D. All data in pi and p3 partitions are removed and the table definition is changed. 

View Answer

Q14. 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. Shell> service mysql safe_exit 

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

D. Shell> mysqladmin –u root –p shutdown 

E. Mysql> STOP PROCESS mysqld; 

F. Shell> net stop mysql 

G. Shell> nmc mysql shutdown 

View Answer

Q15. An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be ”rolled forward” to provide all the latest data. 

The SHOW SLAVE STATUS indicates the following values: 

RELAY_LOG_FILE = hostname-relay-bin.00004 

RELAY_LOG_POS = 1383 

Which command set would make the slave current? 

A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE; 

B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = ‘hostname-relay-bin.00004’ , RELAY_LOG_POS = 1383; 

C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383; 

D. STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE; 

View Answer