Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 91:

  What are three facts about backups with mysqldump?

  A. Can back up a remote database server
  B. Allow a consistent backup to be taken
  C. Are always faster to restore than binary backups
  D. Are able to back up specific items within a database
  E. Create automatically compressed backups
  F. Will lock all storage engines for duration of backup
  D. Are able to back up specific items within a database
  E. Create automatically compressed backups
  F. Will lock all storage engines for duration of backup

• Question 92:

  You are attempting to secure a MySQL server by using SSL encryption.

  On starting MySQL, you get this error:

  130123 10:38:02 [ERROR] mysqld: unknown option `--ssl'

  What is the cause of the error?

  A. The --- ssl level was not specified.
  B. The server was not started with the enable--ssl-plugin option.
  C. -- ssl is not a valid server option.
  D. The mysqld binary was not compiled with SSL support.
  E. The server's SSL certificate was invalid.
  B. The server was not started with the enable--ssl-plugin option.

• Question 93:

  You want to start monitoring statistics on the distribution of storage engines that are being used and the

  average sizes of tables in the various databases.

  Some details are as follows:

  The Mysql instance has 400 databases.

  

  Each database on an average consists of 25-50 tables.

  

  You use the query:

  SELECT TABLE_SCHEMA,

  `ENGINE',

  COUNT (*),

  SUM (data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = `BASE TABLE' GROUP BY TABLE_SCHEMA, `ENGINE' ;

  Why is this query slow to execute?

  A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.
  B. Collecting information requires various disk-level operations and is time consuming.
  C. Aggregating details from various storage engine caches for the final output is time consuming.
  D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.
  B. Collecting information requires various disk-level operations and is time consuming.

• Question 94:

  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.
  D. When using login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.

• Question 95:

  Which three methods will show the storage engine for the Country table?

  A. SHOW CREATE TABLE Country;
  B. SHOW ENGINE Country STATUS;
  C. SHOW TABLE STATUS LIKE `Country';
  D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= `Country';
  E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= `Country';
  A. SHOW CREATE TABLE Country;
  D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= `Country';
  E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= `Country';

• Question 96:

  Which three statements are true about memory buffer allocation by a MySQL Server?

  A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
  B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
  C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
  D. User buffers are allocated at server startup and freed when the user is dropped.
  E. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
  A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
  B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
  C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

• Question 97:

  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.
  D. It relies on the shared disk architecture being visible to both servers.

• Question 98:

  You need to dump the data from the master server and import it into a new slave server.

  Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

  A. Include-master-info
  B. Master-binlog
  C. Include-log-file
  D. Master-data
  D. Master-data

• Question 99:

  You want a record of all queries that are not using indexes.

  How would you achieve this?

  A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
  B. By enabling the Error Log because not using indexes is an error
  C. By enabling the Slow Query Log and using the log-queries-not-using-indexes option
  D. By enabling the Error Log and using the log-queries-not-using-indexes option
  C. By enabling the Slow Query Log and using the log-queries-not-using-indexes option

• Question 100:

  You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.

  C:

  \> mysqld install Mysql56 defaults file = C : \my opts.cnf What is the expected outcome?

  A. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file.
  B. Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
  C. An error message is issued because install is not a valid option for mysqld.
  D. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf.
  B. Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file