Oracle 1Z0-882 Online Practice Questions and Exam Preparation

Oracle 1Z0-882 Online Questions & Answers

• Question 41:

  A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?

  A. The results are in ascending order.
  B. The results are in descending order.
  C. The results are in the order inserted.
  D. The results are not in a set order.
  C. The results are in the order inserted.

• Question 42:

  Which two can be used to obtain information stored in the Diagnostics Area?

  A. SHOW WARNINGS
  B. GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT; SELECT @errno, @msg;
  C. SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
  D. SHOW GLOBAL STATUS LIKE `Diagnostics'
  A. SHOW WARNINGS
  B. GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT; SELECT @errno, @msg;

• Question 43:

  Consider the statements:

  Mysql> drop function foo;

  ERROR 1305 (420000): FUNCTION test, foo does not exist Mysql > show warnings;

  

  Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT; What is the result of the final statement?

  A. An empty result is returned.@msg is set to message of the warning.
  B. A warning message is generated that adds error 1758 (invalid condition number) to the diagnostics area.
  C. A line will be an output to the error log that contains the warning message details from the failed command.
  D. An error is generated as only one condition can exist in the diagnostics area.
  C. A line will be an output to the error log that contains the warning message details from the failed command.

• Question 44:

  You want to use the SHA -256 Authentication plugin with Connector/J. Which two parameter settings achieve this?

  A. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jd bc
  B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
  C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin
  D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
  A. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jd bc

• Question 45:

  Inspect the query:

  Mysql> SELECT count (emp_no) FROM titles WHERE title = `senior staff';

  

  How can this query be optimized?

  A. The query need an index on the emp-no column.
  B. The query cannot be optimized as an index is already used.
  C. The query needs an index that includes the title column.
  D. The query cannot be optimized as count () must read all rows.
  B. The query cannot be optimized as an index is already used.

• Question 46:

  Which two statements provide the definition for a view named view1 in the test database?

  A. SHOW CREATE VIEW view1 FROM test
  B. SHOW CREATE VIEW test-view1
  C. SELECT VIEW_DEFINITION_SCHEMA.VIEWS FROM INFORMATION _SCHEMA.VIEWS WHERE TABLE_NAME="view1" AND TABLE_SCHEMA = "test"
  D. SELECT DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE NAME = "test"
  E. SHOW DEFINITION FOR test.view
  A. SHOW CREATE VIEW view1 FROM test
  C. SELECT VIEW_DEFINITION_SCHEMA.VIEWS FROM INFORMATION _SCHEMA.VIEWS WHERE TABLE_NAME="view1" AND TABLE_SCHEMA = "test"

• Question 47:

  You started a MySQL command line session with sq1_ mode (empty), and created the person table with the structure: Mysql> DESC person;

  

  You issue:

  INSERT INTO person VALUES (`casper', `undefined')

  What is the effect?

  A. `Casper' and ` undefined values are inserted into the `name' and gender' column.
  B. The server returns an error indicating that `undefined' cannot be inserted into a column of ENUM type
  C. The server returns a warning and the empty string is inserted to the `gender' column.
  D. The server returns a warning and the first specified value ,"male" is inserted to the gender column.
  B. The server returns an error indicating that `undefined' cannot be inserted into a column of ENUM type

• Question 48:

  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
  D. MYSQL server was not started with the option default storage engine=InnoDB
  E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB

• Question 49:

  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
  A. Repeatable read
  E. serializable

• Question 50:

  You create a new,empty database called `test'. You want to change the database `s CHARACTER SET to "latin1" and the database `sCOLLATION to `latin_german_ci'. Which statement is true?

  A. You can do this one command: ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci
  B. You can only do this with two separate commands: ALTER DATABASE `test' CHARACTER SET latin1 ALTER DATABASE `test' COLLATE latin_german1_ci
  C. You cannot change the CHARACTER set or COLLATION value on an existing database.
  D. Databases do not have CHARACTER SET or COLLATION attributes.
  A. You can do this one command: ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci