Oracle Oracle Database Application Development 1Z0-883 Questions & Answers

• Question 21:

  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.

  Correct Answer: AC

• Question 22:

  Which two options describe how MySQL Server allocates memory?

  A. Each thread allocates memory from a global pool.

  B. Global memory resources are allocated at server startup.

  C. Thread memory is pre-allocated up to thread_cache_size for performance.

  D. Each connection may have its own per-thread memory allocations.

  Correct Answer: BD

• Question 23:

  MySQL is installed on a Linux server and has the following configuration:

  [mysqld]

  User=mysql

  Datadir=/data/mysql

  As the `root' user, change the datadir location by executing:

  Shell> cp R /var/lib/mysql/data/mysql/

  Shell> chown R mysql /data/mysql/

  What is the purpose of changing ownership of datadir to the `mysql' user?

  A. MySQL cannot be run as the root user.

  B. MySQL requires correct file ownership while remaining secure.

  C. MySQL needs to be run as the root user, but file cannot be owned by it.

  D. The mysqld process requires all permissions within datadir to be the same.

  Correct Answer: B

• Question 24:

  You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.

  Why is it important to remove snapshots after completing a RAW backup in this way?

  A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.

  B. The snapshot size will continue to grow as changes to the volume are made.

  C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.

  D. The system keeps a copy of changes in memory and can cause an out of memory event.

  Correct Answer: C

• Question 25:

  A user executes the statement;

  PURGE BINARY LOGS TO `mysql-bin.010';

  What is the result?

  A. It deletes all binary log files, except `mysql-in.010'.

  B. It deletes all binary log files up to and including `mysql-bin.010'.

  C. It deletes all binary log files before `mysql-bin.010'.

  D. It deletes all binary log files after `mysql-bin.010'.

  Correct Answer: B

• Question 26:

  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.

  Correct Answer: C

• Question 27:

  Which two capabilities are granted with the SUPER privilege?

  A. Allowing a client to kill other client connections

  B. Allowing a client to shut down the server

  C. Allowing change of the server runtime configuration

  D. Allowing client accounts to take over the account of another user

  Correct Answer: AB

• Question 28:

  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.

  Correct Answer: D

• Question 29:

  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. Windows Server Failover Clustering

  D. MySQL Cluster

  Correct Answer: A

• Question 30:

  You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

  [mysqld]

  Loq-bin

  Binrylog_format=ROW

  You do not notice the spelling error in binrylog_format and restart your production server.

  How does the MySQL server behave with incorrectly spelled options?

  A. Mysqld uses internal configuration versioning and reverts to the previous configuration.

  B. When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

  C. The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

  D. Mysqld prints to the error log about an unknown variable, and then exits.

  Correct Answer: D