Free Oracle 1z1-882 Exam Dumps Questions & Answers

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.  Read committed
• B.  Single user
• C.  Repeatable read
• D.  Read uncommitted
• E.  serializable

Inspect the SELECT query:
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';

2 rows in set (0.00 sec)
Which action will optimize the query?

• A.  Add an index on the to_ date column.
• B.  Add the FORCE INDEX (PRIMARY) optimizer hint for the employees table.
• C.  Add the keyword STRAIGHT_JOIN.
• D.  Add an index to the employees. emp _no column.

Consider the content of the class and student tables:
Class

Which three queries produce the same result?

• A.  SELECT *
  FROM JOIN student
  LEFT JOIN student
  ON class. Class.class_id=student.class_id
• B.  SELECT *
  FROM class
  INNER JOIN student
  ON class.class_id=student.class_id
• C.  SELECT *
  FROM JOIN student
  On class .class_id=student.class_id
  WHERE NOT ISNULL (student.class_id)
• D.  SELECT *
  FROM student
  RIGHT JOIN class
  ON class.class_id=student.class_id
• E.  SELECT *
  FROM class
  INNER JOIN student
  WHERE NOT ISNULL (student.class_id)

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 (100,200,300)
• D.  (0,NULL,0) and(0,200,300)

As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?

• A.  The examinee_id column should be designated as PRIMARY KEY.
• B.  The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).
• C.  A NOT NULL qualifier should be added to examinee_id.
• D.  A NOT NULL qualifier should be moved from exam-id to examinee-id.