Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 21:

  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.
  C. The command prints all parameter for the login-path. The password is replaced with stars.

• Question 22:

  You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?

  A. Each extra column in the copy with more columns must not have a default value.
  B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave.
  C. The slave database cannot have more columns than the master. Only the master database can have more columns.
  D. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.
  E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.
  A. Each extra column in the copy with more columns must not have a default value.
  E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

• Question 23:

  You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb- ccc-ddd-eee : 3 on a slave.

  Which command would you execute from a Mysql prompt?

  A. STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
  B. STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
  C. STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE;
  D. STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE;
  B. STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

• Question 24:

  The `allplicationdb' is using innoDB and consuming a large amount of file system space. You have a / backup partition available on NFS where backups are stored.

  You investigate and gather the following information:

  [mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0

  Three tables are stored in the innoDB shared tablespace and the details are as follows: The table data_current has 1,000,000 rows.

  

  The table data_reports has 1,500,000 rows.

  

  The table data_archive has 4,500,000 rows.

  

  Shell> is -1 /var/lib/mysql/

  -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ...

  You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.

  Shell> mysqldump u root p applicationdb data_archive > /backup/data_archive.sql Mysql> DROP TABLE data_archive;

  Which set of actions will allow you to free disk space back to the file system?

  A. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system: Mysql> OPTIMIZE TABLE data_current, data_reports;
  B. Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own: Mysql> SET GLOBAL innodb_file_per_table=1; Mysql> ALTER TABLE data_current ENGINE=InnoDB; Mysql> ALTER TABLE data_repors ENGINE=InnoDB;
  C. Take a backup, stop the server, remove the data files, and restore the backup: Shell> mysqldump u root p applicationdb / > /backup/applicationdb.sql Shell> /etc/init.d/mysql stop Shell> cd /var/lib/mysql/ Shell> rm ibdata1 ib_logfile0 ib_logfile1 Shell> /etc/init.d/mysql start Shell> mysql u root p applicationdb < /backup/applicationdb.sql
  D. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system: Mysql> SET GLOBLE innodb_file_per_table=1; Mysql> SET GLOBLE innodb_file_format=Barramcuda; Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; Mysql> ALTER TABLE data_history ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
  D. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system: Mysql> SET GLOBLE innodb_file_per_table=1; Mysql> SET GLOBLE innodb_file_format=Barramcuda; Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; Mysql> ALTER TABLE data_history ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

• Question 25:

  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.
  B. The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

• Question 26:

  Which two requirements would lead towards a high availability solution?

  A. When uptime is critical
  B. When data must be refactored
  C. When application concurrency is static
  D. When data loss is unacceptable
  E. When application is a single point of failure
  A. When uptime is critical
  D. When data loss is unacceptable

• Question 27:

  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. Running the server with skip-networking specified
  C. Limiting logins to originate from the application server or the server's subnet
  D. Starting the server with bind- address=0.0.0.0 specified
  E. Installing Mysql on the application server, and running the database and application on the same server
  F. Enabling and using SSL for connections to the Mysql database
  E. Installing Mysql on the application server, and running the database and application on the same server
  F. Enabling and using SSL for connections to the Mysql database

• Question 28:

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

  A. Mysqlslow
  B. Mysqldumpslow
  C. Mysqlshow
  D. Mysqldump
  E. Mysqlaccess
  B. Mysqldumpslow

• Question 29:

  Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data. Which method would use mysqlbinlog for greater consistency?

  A. shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql
  B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
  C. shell> mysqlbinlog restore bin.00010 bin.00011 bin.00012
  D. shell> mysqlbinlog include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql
  A. shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

• Question 30:

  Consider the Mysql Enterprise Audit plugin.

  A CSV file called data.csv has 100 rows of data.

  The stored procedure prepare_db ( ) has 10 auditable statements.

  You run the following statements in the mydb database:

  Mysql> CALL prepare_db ( );

  Mysql> LOAD DATA INFILE `/tmp/data.cav' INTO TABLE mytable; Mysql> SHOW TABLES;

  How many events are added to the audit log as a result of the preceding statements?

  A. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.
  B. 3; only the top-level statements are logged.
  C. 111; top-level statements and all lower-level statements are logged.
  D. 12; only top-level statements and stored procedure events are logged.
  B. 3; only the top-level statements are logged.