Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 31:

  Which two PHP modules provide APIs for developing MYSQL applications?

  A. Mysqli
  B. Mysqlnd
  C. PDO
  D. PDO_mysql
  A. Mysqli
  C. PDO

• Question 32:

  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
  B. A view containing a GROUP BY clause
  C. A view containing a WHERE clause
  D. A view containing a HAVING clause

• Question 33:

  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 =?.;
  C. PREPARE countrycode FROM `SELECT code FROM country WHERE Name =?.;

• Question 34:

  Consider the my_table table with these contents:

  

  You execute:

  SELECT 1 FROM my_table;

  What is the result?

  A. A single value: 1
  B. Two values: 1, 1
  C. Two values: 11, 12
  D. Two values: 11, 13
  E. An error message
  A. A single value: 1

• Question 35:

  Consider the table t1 created with this statement:

  CREATE TABLE t1(

  id INT NOT NULL AUTO_INCREMENT

  PRIMARY KEY,

  Name CHAR (20)

  ENGINE=InnoDB;

  After inserting three rows, the table contains:

  

  These commands are executed:

  DELETE FROM t1 WHERE id=200; INSERT INTO t1 (name) VALUES (`pluto'): Which data set is inserted in the table?

  A. (200.pluto)
  B. (101,Pluto)
  C. (201,Pluto)
  D. (300,Pluto)
  A. (200.pluto)

• Question 36:

  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
  B. Option B

• Question 37:

  An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code.

  Example: "ABCDEFOO ooozzz comments will be here FIELDS----FIELD64"

  Given the query pattern:

  SELECT----FROM sensors WHERE details LIKE `ABCDEF

  Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

  A. ALTER TABLE sensors ADD KEY (details ) USING BTREE
  B. ALTER TABLE sensors ADD KEY (details) USING HASH
  C. ALTER TABLE sensors ADD KEY (details) USING BTREE
  D. ALTER TABLE sensors ADD KEY (details )USING HASH
  E. ALTER TABLE sensors ADD FULLTEX (details)
  A. ALTER TABLE sensors ADD KEY (details ) USING BTREE
  B. ALTER TABLE sensors ADD KEY (details) USING HASH

• Question 38:

  Consider the query and its output:

  Mysql> SELECT Language As Lang FROM countrylanguage ->WHERE countrycode ='GBR';

  

  A user wants to have an output as shown:

  

  What query would achieve this?

  A. SELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE countrycode= `GBR';
  B. SELECT GROUP_CAT(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
  C. SELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
  D. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode='GBR';
  D. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

• Question 39:

  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
  B. The slow query log
  C. The performance schema

• Question 40:

  The people table contains the data as shown:

  

  Which two statements return two rows each?

  A. SELECT DISTINCT last_name, first_name FROM people
  B. SELECT 1,2 FROM people GROUP BY last_name
  C. SELECT first_name, last _name FROM people WHERE age LIKE `2'
  D. SELECT 1, 2 FROM people WHERE last _name ='smith'
  E. SELECT first _name, last_name FROM people LIMIT 1, 2
  C. SELECT first_name, last _name FROM people WHERE age LIKE `2'
  E. SELECT first _name, last_name FROM people LIMIT 1, 2