Oracle Oracle Certifications 1Z0-882 Questions & Answers

• Question 61:

  Inspect the CREATE TABLE below:

  Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2

  warnings (0.11 sec)

  Mysql> SHOW WARNINGS;

  

  Which two is true connecting the meaning of the warnings?

  A. The InnoDB storage engine was disabled during server startup.

  B. Global variable skip _innodb was set to ON after the server had started.

  C. The default storage engine MYISAM was used for the table created.

  D. MYSQL server was not started with the option default storage engine=InnoDB

  E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB

  Correct Answer: DE

• Question 62:

  Which condition must be true in order that a view is considered updateable?

  A. The user must have the UPDATE or DELETE privilege for the underlying table.

  B. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.

  C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

  D. The view must only refer to literal values.

  Correct Answer: C

• Question 63:

  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

  Correct Answer: A

• Question 64:

  A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.

  You execute this query: SELECT col1 FROM t1 WHERE col1< 100 UNION SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200 UNION ALL SELECT col1 FROM t1 WHERE col 1 >=900

  What is the output?

  A. A list of unique values within the ranges of 1-200 and 900-1000

  B. A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the range of 900-1000

  C. A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000

  D. A list of all values, including duplicates, in the ranges of 1-200 and 900-1000

  E. An error, because mixing UNION and UNION ALL in the same query is not permitted

  Correct Answer: C

• Question 65:

  The contents of the parent and child tables are:

  

  The child table has the parent_id column that has a foreign key constraint to the id column of the parent

  table with ON DELETE CASCADE clause.

  Consider the command WHERE id =1;

  What is the effect of the above command?

  A. It does not delete anything from any table but returns an error.

  B. It deletes one row from the parent table but does not affect the child table.

  C. It deletes one row from the parent table and two rows from the child table.

  D. It deletes one row from the parent table and sets the parent _id column to NULL in the child.

  Correct Answer: A

• Question 66:

  Using the query:

  SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?

  A. PREPARE STATEMENT countrycode FROM `SELECT code FROM counyry WHERE Name =?.;

  B. PREPARE countrycode As `SELECT code FROM country WHERE Name =?.;

  C. PREPARE countrycode FROM `SELECT code FROM country WHERE Name =?.;

  D. PREPARE STATEMENT countrycode As `SELECT code FROM country WHERE Name =?.;

  Correct Answer: C

• Question 67:

  These there tables represent a many to-many relationship in asocial networking database: This query draft is constructed to report for the past 30 days: Which change will correct this query?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 68:

  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.

  Correct Answer: BEF

• Question 69:

  You have two tables: news_source and news_feed.

  

  Here is some sample data from the news _feed table:

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 70:

  Which three view types are not updateable?

  A. A view created with the TEMPTABLE algorithm

  B. A view containing a GROUP BY clause

  C. A view containing a WHERE clause

  D. A view containing a HAVING clause

  E. A view that contains a literal column

  Correct Answer: BCD