Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 51:

  Which three database objects have non-case-sensitive names on all operating system?

  A. Table
  B. Column
  C. Index
  D. Stored procedure
  E. Trigger
  A. Table
  B. Column
  C. Index

• Question 52:

  Which two Functions can be used in a C program to retrieve information about warning?

  A. mysql_info
  B. mysql_error
  C. mysql_warning_count
  D. mysql_errno
  A. mysql_info
  B. mysql_error

• Question 53:

  Which three statement types can be prepared?

  A. LOAD DATA INFILE
  B. CREATE TABLE
  C. CREATE VIEW
  D. ALTER VIEW
  E. CALL
  A. LOAD DATA INFILE
  B. CREATE TABLE

• Question 54:

  In the office table, the city column is structured as shown:

  Mysql> show columns from office like `city'\G

  ---------------------------------------------------1. row ---------------------__________________ Field: city Type: enum(`paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes Key:

  Default:NULL

  Extra:

  Consider the output of the SELECT query executed on the office table:

  Mysql> SELECT DISTINCT city FROM office ORDER BY city:

  

  If the query is written as:

  SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?

  A. Paris, Amsterdam. New York, Tokyo
  B. Tokyo, New York, Amsterdam, Paris
  C. Amsterdam, New York, Paris, Tokyo
  D. Tokyo, Paris, New York, Amsterdam
  C. Amsterdam, New York, Paris, Tokyo

• Question 55:

  The application logs contain many entries of the following:

  ERROR 1153 (OSSO1): Got a packet bigger than `max_allowed_packet' bytes

  With two scenarios can (Hibernate this error message?

  A. The application tried to INSERT a row that exceeded max_allowed_packet.
  B. The network caused an error Inducing the max_allowed_packet error.
  C. The application did not use the COMPRESS () function for a large result set.
  D. The application tried to SELECT many rows together that exceeded max__allowed_packet.
  E. The application tried to SELECT a row that exceeded max_allowed_packet.
  F. The operating system caused an error inducing the max_allowed_packet error.
  D. The application tried to SELECT many rows together that exceeded max__allowed_packet.
  F. The operating system caused an error inducing the max_allowed_packet error.

• Question 56:

  Inspect the SELECT query:

  Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11';

  

  2 rows in set (0.00 sec) Which action will optimize the query?

  A. Add an index to the employees. emp _no column.
  B. Add the keyword STRAIGHT_JOIN.
  C. Add an index on the to_ date column.
  D. Add the FORCE INDEX (PRIMARY) optimizer hint for the employees table.
  C. Add an index on the to_ date column.

• Question 57:

  You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables. Which query accomplishes this?

  A. SELECT * FROM tableA. tableB
  B. SELECT * FROM tableA JOIN tableB
  C. SELECT * FROM table A INNER JOIN tableB
  D. SELECT * FROM tableA NATURAL JOIN tableB
  E. SELECT and FROM tableA STRAIGHT JOIN tableB
  C. SELECT * FROM table A INNER JOIN tableB

• Question 58:

  You are connected to a MySQL server and using a prepared statement. You accidentally exit your session.

  What will happen if you log back in to use your prepared statement?

  A. The statement exists, but will need to be deallocated and re-created.
  B. The statement exists, but the user variables need to be redefined.
  C. The statement can be used, if the MySQL server hasn't been restarted.
  D. The statement no longer exists.
  A. The statement exists, but will need to be deallocated and re-created.

• Question 59:

  The tab-delimited file"/tmp/people,txt contains:

  1636 Carsten Pederson Denmark 4672 Kai Voigt Germany 4628 Max Mether France

  This is the structure of the people table: Mysq1> DESCRIBE people;

  

  Which statement will load the first and last names into the Names column and the country into the country column?

  A. LOAD DATA INFILE `/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4 (CONCAT (@First, ` `,@Last) , @ Country)
  B. LOAD DATA INFILE `/tmp/people.txt ` INTO TABLE People @Skip=$1 , @ First=$2, @Last=$3, @ Country=4, (CONCAT (@First, ` ` .@ Last) , @ Country)
  C. LOAD DATA INFILE `/tmp/people.txt `INTO TABLE People (@ Skip, @First , @Last, @Country SET Name=CONCAT (@First, ` `,@Last)
  D. LOAD DATA INFILE `/tmp/people,txt, INTO TABLE People. (@Skip. @First, @Last, @Country) Country=@country
  E. It is not possible to load the data from the file/tmp/people.txt into the people table,as shown.
  C. LOAD DATA INFILE `/tmp/people.txt `INTO TABLE People (@ Skip, @First , @Last, @Country SET Name=CONCAT (@First, ` `,@Last)

• Question 60:

  Which Three options describe benefits of using the InnoDB memcached API?

  A. Provides a simple, well supported method for accessing and updating data.
  B. Provides a total in memory storage system that eliminates disk1/0 overhead.
  C. Bypasses the SQL layer thus avoiding extra processing.
  D. Implements a fast caching mechanism to replace the query cache.
  E. Provides protection via InnoDB buffers and crash recovery.
  C. Bypasses the SQL layer thus avoiding extra processing.
  D. Implements a fast caching mechanism to replace the query cache.
  E. Provides protection via InnoDB buffers and crash recovery.