Oracle 1Z0-873 Online Practice Questions and Exam Preparation

Oracle 1Z0-873 Online Questions & Answers

• Question 121:

  which of the following best describes why table locking is often not desirable compared to page or row locking?

  A. Table locks can have deadlocks.
  B. Table locks create concurrency issues.
  C. Table locks prevent other clients from making any changes to the table until released.
  D. Table locks can cause data corruption issues if more than one client tries to make changes while locked.
  B. Table locks create concurrency issues.

  ---

  28.1. Locking Concepts

  Table locking is not as desirable as page or row locking for concurrency in a mixed read/write environment.

  A table lock prevents other clients from making any changes to the table, even if the client that holds the lock is not accessing the parts of the table that other clients want to modify. With page and row locks, a client that locks a page or row

  does not prevent changes by other clients to other pages or rows. Deadlock cannot occur with table locking as it can with page or row locking.

• Question 122:

  Which of the following statements are true for tables using the FEDERATED storage engine?

  A. Each FEDERATED table is represented on disk by a .frm format file in the database directory of the local server.
  B. For each FEDERATED table, the content of the referenced table is stored in a .FED file on the local server.
  C. The FEDERATED storage engine does not support transactions.
  D. The FEDERATED storage engine supports transaction if the storage engine of the referenced table supports transactions.
  E. The FEDERATED storage engine supports SELECT statements.
  F. The FEDERATED storage engine supports DELETE, UPDATE, and INSERT statements.
  A. Each FEDERATED table is represented on disk by a .frm format file in the database directory of the local server.
  C. The FEDERATED storage engine does not support transactions.
  E. The FEDERATED storage engine supports SELECT statements.
  F. The FEDERATED storage engine supports DELETE, UPDATE, and INSERT statements.

  ---

  29.6. The FEDERATED Engine

  The FEDERATED storage engine manages tables that have the following characteristics:

  Each FEDERATED table is represented on disk only by an .frm format file in the database directory. The FEDERATED storage engine does not support transactions. The FEDERATED storage engine supports SELECT, DELETE, UPDATE,

  and INSERT statements.

  MySQL does not use any locking for FEDERATED tables.

• Question 123:

  Which of the following methods can be used to determine the storage engine of your table named "Country"?

  A. SHOW CREATE TABLE Country
  B. SHOW STORAGE ENGINE Country
  C. SHOWTABLE STATUS LIKE 'Country'
  D. SELECT ENGINEFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_NAME = 'Country'
  A. SHOW CREATE TABLE Country
  C. SHOWTABLE STATUS LIKE 'Country'
  D. SELECT ENGINEFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_NAME = 'Country'

• Question 124:

  Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?

  A. default_engine
  B. storage_default
  C. storage_engine
  D. default_storage_engine
  C. storage_engine

  ---

  29.1. MySQL Storage Engines

  If you create a table without using an ENGINE option to specify a storage engine explicitly, the MySQL server creates the table using the default engine, which is given by the value of the storage_engine system variable.

• Question 125:

  In a standard MySQL installation which of following files are stored below the data directory?

  A. Format files for all the tables
  B. Data and index files for MyISAM tables
  C. InnoDB tablespace files
  D. General server logs
  E. MySQL upgrade script files
  A. Format files for all the tables
  B. Data and index files for MyISAM tables
  C. InnoDB tablespace files
  D. General server logs

• Question 126:

  Which of the following statements best describe the purpose of the general query log and how you enable it?

  A. The purpose is to record when a client connects or disconnects and record every SQL statement issued to the server.
  B. The purpose is to record SQL statements that are issued to the server for use when restoring backups.
  C. The general query log is enabled with the --general-log or --general-log=file_name option.
  D. The general query log is enabled with the --log or --log=file_name option.
  A. The purpose is to record when a client connects or disconnects and record every SQL statement issued to the server.
  D. The general query log is enabled with the --log or --log=file_name option.

  ---

  24.5.1. The General Query Log The general query log contains a record of when clients connect and disconnect, and the text of every SQL statement received by the server (whether or not it was processed successfully). The server writes statements to the log in the order that it receives them. This log is useful for determining the frequency of a given type of statement or for troubleshooting queries that are not logged to other log files. To enable the general query log, use the --log or --log=file_name option. If no filename is given, the default name is host_name.log, where host_name stands for the server hostname. By default, the server creates the general query log file under the data directory unless you specify an absolute pathname.

• Question 127:

  Suppose you install a server with a service name of "MySQL5" rather than the default. What sections in the option files will the server use for configuration?

  A. [service]
  B. [MySQL5]
  C. [service MySQL5]
  D. [mysqld]
  E. [mysqld MySQL5]
  B. [MySQL5]
  D. [mysqld]

  ---

  24.2.

  If you install a server using a service name other than MySQL and do not specify a --defaults-file option, the server reads options in the standard option files from the [my_service] group in addition to options from the [mysqld] group.

• Question 128:

  Some statements implicitly commit pending transactions and start a new one.

  A. True
  B. False
  A. True

  ---

  29.4.3. The InnoDB Transaction Model

  If you issue any of the following statements, InnoDB implicitly commits the preceding uncommitted statements of the current transaction and begins a new transaction:

  ALTER TABLE BEGIN CREATE INDEX DROP DATABASE DROP INDEX DROP TABLE RENAME TABLE TRUNCATE TABLE LOCK TABLES UNLOCK TABLES SET AUTOCOMMIT = 1 START TRANSACTION

• Question 129:

  Consider the three binary log files bin.00010, bin.00011 and bin.00012 which you want to restore data from. How should you process these files when using mysqlbinlog to satisfy inter-file dependencies?

  A. shell> mysqlbinlog bin.00010 | mysqlshell> mysqlbinlog bin.00011 | mysqlshell> mysqlbinlog bin.00012 |mysql
  B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
  C. You can use both of the above statements, i.e. process the files either in a group or separately. All inter-file dependencies will be taken care of with both methods.
  B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

  ---

  32.8.3. Processing Binary Log Contents shell> mysqlbinlog bin.000050 bin.000051 bin.000052 | mysql All the binary log files that you want to process should be handled in a single mysqlbinlog command. There may be inter-file dependencies that will not be satisfied if you process them separately.

• Question 130:

  A windows binary installation includes several servers in the MySQL installation directory. What is the purpose of the mysqld-nt server?

  A. It is the standard server with no extra features
  B. It is the standard server with additional support for named pipes.
  C. It is the standard server with additional support for named pipes and extra storage engines.
  D. It is a debug-version of the server with named pipes and error reporting facilities to help track down errors in the server.
  E. It is the standard server, compiled to be optimized forWindows NT 4.0 (but not otherWindows versions).
  B. It is the standard server with additional support for named pipes.

  ---

  24.2.1. Server Startup Prerequisites on Windows

  mysqld-nt is like mysqld, but includes support for named pipes on NT-based systems such as Windows NT, 2000, XP, and 2003.