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

• Question 81:

  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 9001000

  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

  Correct Answer: B

• Question 82:

  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

  Correct Answer: C

• Question 83:

  In MYSQL 5.6 you have the table t1:

  CREATE TABLE t1 (

  id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;

  There are two connections to the server. They execute in this order:

  Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Connection 1> START

  TRANSACTION;

  Connection 1> SELECT * FROM t1 WHERE id =1;

  Connection 2> TRUNCATE TABLE t1;

  What happens to the TRUNCATE TABLE command in connection 2?

  A. It immediately proceeds and causes an implicit commit of the transaction in connection1.

  B. It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1 table.

  C. It blocks waiting for a metadata lock until the transaction in connection 1 ends.

  D. It blocks waiting for a table lock until the transaction in connection 1 ends.

  Correct Answer: A

• Question 84:

  Your application is running slow.

  Which two features provide information that help to identify problems?

  A. The MYSQL error log

  B. The slow query log

  C. The performance schema

  D. The GET DIAGNOSTICS statement

  Correct Answer: BC

• Question 85:

  Cormcctor/Net supports a decoupled database connection mode, where a database Connection is

  established only when needed.

  '

  Choose the three parts that are involved when working with decoupled data.

  A. OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql

  B. MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results

  C. DecoupODBCConn, DecoupMyScjlruiiimanrt, DecoupMySqlRetum

  D. DataSet, MySqlDataAdapter, MySql Command Builder

  Correct Answer: D

• Question 86:

  You have two test tables:

  Code_innodb as InnoDB engine

  Code_ myisam as MYISAM engine

  The tables have the same structure:

  

  The tables have one row of data:

  

  You execute an INSERT statement on both code_myisam tables and receive duplicate key errors: mysql> INSERT INTO code_innodb VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie,),(4, `Delta'); ERROR 1062 (23000): Duplicate entry `3' for key `PRIMARY'

  Mysql> INSERT INTO code_myisam VALUES (1, `Alpha'), (2, `Beta'), (3, `charlie'), (4, `Delta'); ERROR 1062 (23000); Duplicate entry `3' for key `PRIMARY'

  What is the expected output of the SELECT statements?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 87:

  You have a transaction that queries a table at the beginning of the transaction and performs the same

  query later.

  Which two transaction isolation levels guarantee that you get the same results both times?

  A. Repeatable read

  B. Read committed

  C. Read uncommitted

  D. Single user

  E. serializable

  Correct Answer: AE

• Question 88:

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

  A. Table

  B. Column

  C. Index

  D. Stored procedure

  E. Trigger

  Correct Answer: ABC

• Question 89:

  Which three connector/J connection strings can be used to connect to the MYSQL server?

  A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx

  B. Jdbc :mysqli://localhost/test?user=xxxandpassword=xxx

  C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx

  D. Jdbc:mysql:proxy://localhost/test?user=xxxandpassword=xxx

  E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx

  Correct Answer: ACE

• Question 90:

  A floating- point column defined as FLOAT(7,5)allows___________

  A. 7 digits to the left of the decimal point and 5 digits to the right

  B. 5 digits to the left of the decimal point and 7 digits to the right

  C. 7 digits in total, of which 5 are to the right of the decimal point

  D. 7 digits in total, of which 5 are to the left of the decimal point

  Correct Answer: C