Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 71:

  The friends table has the columns and contents as shown:

  Mysql> SELECT * FROM friends;

  

  This statement was executed: SELECT AVG (age) FROM friends What value is returned?

  A. NULL
  B. 10
  C. 20
  A. NULL

• Question 72:

  Using the MYSQL command line client you have received the error "Lost connection to MYSQL server query"

  Which three are possible causes of the error?

  A. The MYSQL server stopped working during query execution.
  B. The network connection was interrupted during query execution.
  C. The connection that issued the query was killed.
  D. The client connection stayed idle for longer than interactive timeout seconds and was closed.
  E. The client sent an erroneous query to the server causing the connection to be closed.
  F. The server interrupted client connection after max-connect-errors was achieved.
  B. The network connection was interrupted during query execution.
  E. The client sent an erroneous query to the server causing the connection to be closed.
  F. The server interrupted client connection after max-connect-errors was achieved.

• Question 73:

  Inspect the query:

  Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004';

  

  4 rows in set (0.00 sec)

  Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004';

  

  2 rows in set (0.00 sec)

  Which two statements are true about the EXPLAIN output?

  A. All data for the result is read from the indexex.
  B. The PRIMARY KEY is used for filtering in both tables.
  C. The minimal number of rows possible are read.
  D. The dept_manager table has 4 times as many rows than the employees table.
  C. The minimal number of rows possible are read.

• Question 74:

  A table (t1) contains 1000 random integer values in the first column (col1).The random values are in the range of 0-1000.

  Examine this query: SELECT col1 FROM t1 WHERE col1 <=100 UNION SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC

  What is the expected output?

  A. A list of all values, including duplicates, sorted in descending order in the ranges of 0-100 and 900
  B. A list of all random unsorted values, including duplicates, in the range of 0-100 followed by the list of all values, including in the range of 900-1000 sorted in descending order
  C. A list of unique random values in the range of 0-100 followed by the list of unique values in the range of 900-1000 sorted in descending order
  D. A list of all unique values sorted in descending order within the ranges of 0-100 and 900
  B. A list of all random unsorted values, including duplicates, in the range of 0-100 followed by the list of all values, including in the range of 900-1000 sorted in descending order

• Question 75:

  Given the data:

  

  Expected output:

  

  Which query produces the expected output?

  A. SELECT colors2.name, colors1.name FROM colors2 OPTIONAL JOIN colors1 ON colors2.name, colors1.name
  B. SELECT colors2.name, colors1.name FROM colors2 NATURAL JOIN colors1 ON colors2.name=colors1.name
  C. SELECT colors2.name, colors1.name FROM colors2 STRAIGHT JOIN colors1 ON colors2.name, =colors1.name
  D. SELECT colors2.name,colors1.name FROM colors2 LEFT JOIN colors1 ON colors2.name=colors1.name
  E. SELECT colors2.name,colors1.name FROM colors2 RIGHT JOIN colors1 ON colors2.name=colors1.name
  D. SELECT colors2.name,colors1.name FROM colors2 LEFT JOIN colors1 ON colors2.name=colors1.name

• Question 76:

  Which statement describes the process of normalizing databases?

  A. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
  B. Redundant tables are combined into one larger table to simplify the schema design.
  C. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
  D. Columns that contain repeating data values are split into separate tables to reduce item duplication.
  E. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.
  D. Columns that contain repeating data values are split into separate tables to reduce item duplication.

• Question 77:

  Which two queries return a value of NULL?

  A. SELECT NULL =NULL
  B. SELECT NULL is NULL
  C. SELECT NULL NULL
  D. SELECT 1 > NULL
  E. SELECT COUNT (NULL);
  A. SELECT NULL =NULL
  B. SELECT NULL is NULL

• Question 78:

  A statement exists that can duplicate the definition of the `world'table.

  What is missing?

  CREATE TABLE t1 ___________world

  A. FROM
  B. USING
  C. COPY
  D. LIKE
  A. FROM

• Question 79:

  Consider the statement:

  CREATE TABLE t1 (a INT) PARTITION BY KEY

  /*150611 ALGORITHM = 1*/

  What does this statement do?

  A. Create the t1 table partitioned by KEY with the default algorithm in all versions.
  B. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the default algorithm in other versions.
  C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default algorithm in older versions.
  D. Create the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned error condition 50611.
  C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default algorithm in older versions.

• Question 80:

  Examine the structure and content of the MemberLocation table:

  

  You want to have the field location returned in all letters (example: BERLIN). Which query would you use?

  A. SELECT UPPER (Location) as location FROM MemberLocation
  B. SELECT UPPER (BINARY location) as location FROM MemberLocation
  C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
  D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
  C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation