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

• Question 11:

  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

  Correct Answer: C

• Question 12:

  When executing a stored routine, how is the SQL_MODE determined?

  A. By the default SQL_MODE of the server

  B. By the current SQL _MODE of the session

  C. By the SQL_MODE that was set when the routine was defined

  D. By using TRADITTIONAL regardless of any other settings

  Correct Answer: B

• Question 13:

  Assume your connection uses SQL mode ANSI_QUOTES. Which two statements cause a syntax error?

  A. CREATE TABLE FRIENDS (NAME CHAR (10))

  B. CREATE TABLE BINARY (PRIMARY SMALLINT)

  C. CREATE TABLE `TABLE' (COLUMN' INTEGER)

  D. CREATE TABLE "CONDITION" ("DESCRIBE" TEXT)

  E. CREATE TABLE INTERVAL (ELAPSED_TIME TIME)

  Correct Answer: AB

• Question 14:

  You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows:

  Mysql> explain select comic_ title, publisher from comics where comic_title like `and Actionand';

  

  1 row in set (0.00 sec)

  You create the following index:

  CREATE INDEX cimic_title_idx ON comics (comic_title, publisher); You run the same EXPLAIN statement

  again;

  Mysql > explain select comic_title ,publisher from comics where comic_title like `and Actionand';

  

  1 row in the second SELECT statement need to read all 1183 rows in the index comic_title_idx?

  A. Because comic_title is not the primary key

  B. Because a LIKE statement always requires a full tables scan

  C. Because comic _title is part of acovering index

  D. Because a wildcard character is at the beginning of the search word

  Correct Answer: B

• Question 15:

  Consider the stored procedure

  CREATE PROCEDURE param_test (

  IN P_in INT,

  OUT P_out INT,

  INPUT P_inout INT)

  BEGIN

  SELECT P_in, P_out, P_ inout;

  SET P_in, P_inout

  END

  You execute a series of commands:

  

  What is the output of the CALL and SELECT?

  A. (0,0,0) and (0,0,0)

  B. (0,0,0,) and (0,200,300)

  C. (0,NULL,0) and(0,200,300)

  D. (0,NULL,0) and (100,200,300)

  Correct Answer: A

• Question 16:

  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.

  Correct Answer: CDE

• Question 17:

  Assume that the current database has a table with the following structure (the values for the Field column have been removed for the purpose of this question) Mysql > DEBS count trylanguage;

  

  How can you select only the first two columns?

  A. SELECT 1, 2 FROM Countrylanguage;

  B. SELECT * FROM Counytrylanguage LIMIT 1, 2,

  C. SELECT *{1,2} FROM Countrylanguage;

  D. SELECT * (1), *[2] FROM Counyrylanguage;

  E. It is not possible without using the column names or without using any other tables or queries.

  Correct Answer: B

• Question 18:

  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.

  Correct Answer: A

• Question 19:

  You have created your connector/Net object to connect to MySQL. What are three valid database operations you can call?

  A. ExecuteReader, ExecuteNonQuery, ExecuteScalar

  B. PreformReadonly, performNonQuery,perforIndexRead

  C. Query, Execute.MySql, Read. Execute. MySQl, Execute,Mysql

  D. Insert Mysql, UpdateMysql,DeleteMysql

  E. Query .Apply ,Mysql.Delete.Mysql,Query. Update .Mysql

  Correct Answer: A

• Question 20:

  Examine this table that contains over two million rows of data:

  CREATE TABLE `news_feed' (

  .id'bigint (20) NOT NULL AUTO _INCREMENT,

  .news _sources_id'varchar (11) NOT NULL,

  .dataline' datetime NOT NULL,

  .headline' varchar (256) NOT NULL,

  .story' text NOT NULL,.tag varchar (32768) DEFAULT NULL, PRIMARY KEY (`id')

  KEY `dateline' ( `dateline')

  )

  Examine this query that returns 332 rows of date:

  SELECT *

  FROM news_feed

  WHERE DATE(dateline)= `2013-01-01'

  Which change would show the greatest improvement in the response time of the query?

  A. Use the LIKE operator: SELECT . . .WHERE dateline LIKE `2013-10-01and'

  B. USE the DATEDIFF function: SELECT . . . WHERE DATEDIFF (dateline, `2013-01-01') = 0

  C. Use numeric equivalents for comparing the two dates: SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP (`2013-01-01')

  D. Use a date range comparison: SELECT . . . WHERE dateline >= `2013-01' and dateline < `2013-01-02'

  Correct Answer: D