Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 91:

  The data from t1 table is:

  

  Assuming You want to see this output:

  

  Which query achieves the preceding result?

  A. SELECT name FROM t1 WHERE name LIKE ,_e%
  B. SELECT name FROM t1 WHERE name LIKE,e%.;
  C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
  D. SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;
  C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;

• Question 92:

  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
  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

• Question 93:

  You want to load data directly from a file into MYSQL by using the SOURCE command. Which types of data can the file contains to perform this?

  A. SQL commands
  B. Comma-delimited data
  C. Tab-delimited data
  D. MyISAM or InnoDB data files
  B. Comma-delimited data

• Question 94:

  What are two ways in which normalizing your tables helps improve performance In MySQL?

  A. Smaller table sizes and row lengths improve sorting operations.
  B. Separate tables allow indexing more columns.
  C. Fewer nullable column improve index usage.
  D. Normalizing Improves the performance of innodb_file_per _table.
  D. Normalizing Improves the performance of innodb_file_per _table.

• Question 95:

  A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0

  What happens when you execute an UPDATE statement without a WHERE clause?

  A. Results in an error
  B. Updates every row in the specified table(s)
  C. Results in - -safe-updates being enabled automatically
  D. Causes a syntax error
  A. Results in an error

• Question 96:

  Which statement is true about the difference between HASH and BTREE INDEXES?

  A. HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.
  B. HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.
  C. HASH indexes are used only for equality comparisons (= or),whereas BTREE indexes can also be used for range searches (>or
  D. HASH indexes are much faster than BTREE indexes but can only be used for a single column.
  C. HASH indexes are used only for equality comparisons (= or),whereas BTREE indexes can also be used for range searches (>or

• Question 97:

  Which two keywords cannot be used in multi-table deletes?

  A. USING
  B. ORDER BY
  C. LIMIT
  D. IGNORE
  E. JOIN
  B. ORDER BY
  C. LIMIT

• Question 98:

  Assume that none of the databases exist.

  A. CREATE DATABASE $test
  B. CREATE DATABASE 1$
  C. CREATE DATABASE $
  D. CREATE DATABASE _
  E. CREATE DATABASE 12
  E. CREATE DATABASE 12

• Question 99:

  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
  A. ExecuteReader, ExecuteNonQuery, ExecuteScalar

• Question 100:

  Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage;

  

  SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

  

  You add an index on the Isofficial column.

  Which two statement are true?

  A. The optimizer will choose the index when Isofficial='T' is in the WHERE clause.
  B. The optimizer will choose the index when Isofficial='F' is in the WHERE clause.
  C. The optimizer will not choose the index on the Isofficial column.
  D. The speed of INSERT statements to this table will be improved.
  E. The speed of INSERT statements to this table will be reduced.
  F. The speed of INSERT statements to this table will be unchanged.
  C. The optimizer will not choose the index on the Isofficial column.
  E. The speed of INSERT statements to this table will be reduced.