Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 1:

  Examine this description of the PRODUCTS table:

  

  Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.

  Which three commands execute successfully on PRODUCTS? (Choose three.)

  A. CREATE INDEX price_idx ON products (price);
  B. ALTER TABLE products SET UNUSED (expiry_date);
  C. DROP TABLE products;
  D. ALTER TABLE products DROP COLUMN expiry_date;
  E. TRUNCATE TABLE products;
  F. ALTER TABLE products DROP UNUSED COLUMNS;
  A. CREATE INDEX price_idx ON products (price);
  C. DROP TABLE products;
  F. ALTER TABLE products DROP UNUSED COLUMNS;

• Question 2:

  You execute these commands:

  

  Which two, used independently, can replace so the query returns 1?

  A. ROLLBACK;
  B. ROLLBACK TO SAVEPOINT post_insert;
  C. ROLLBACK TO post_insert;
  D. COMMIT;
  E. COMMIT TO SAVEPOINT post_insert;
  B. ROLLBACK TO SAVEPOINT post_insert;
  C. ROLLBACK TO post_insert;

• Question 3:

  Examine this statement which executes successfully:

  

  Which statement will violate the CHECK constraint?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 4:

  Which statement fails to execute successfully?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

• Question 5:

  Examine the contents of the EMP table:

  

  Examine this query that executes successfully:

  

  What is the result?

  A. It will return the five employees earning the lowest salaries, in ascending order.
  B. It will return the six employees earning the highest salaries, in descending order.
  C. It will return the six employees earning the lowest salaries, in ascending order.
  D. It will return the five employees earning the highest salaries, in descending order.
  A. It will return the five employees earning the lowest salaries, in ascending order.

• Question 6:

  User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges. User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges. HR successfully executes this statement:

  

  HR attempts to execute:

  1.

  INSERT INTO scott.products VALUES (1, 'LAPTOP'); SCOTT attempts to execute:

  2.

  SELECT * FROM products;

  3.

  INSERT INTO scott.products VALUES (2, 'HDD');

  4.

  CREATE SYNONYM prod FOR products; Which will execute successfully?

  A. 1, 2 and 3
  B. 2, 3 and 4
  C. 1 only
  D. 2 and 3 only
  D. 2 and 3 only

• Question 7:

  Examine the description of the COUNTRIES table:

  

  Examine the description of the DEPARTMENTS table:

  

  Examine the description of the LOCATIONS table:

  

  Which two queries will return a list of countries with no departments? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B
  D. Option D

• Question 8:

  Examine this query and its output:

  

  Examine this query with an incomplete WHERE clause:

  

  Which two are true about operators that can be used in the WHERE clause? (Choose two.)

  A. Using ANY will display all the product names except the product named Fork.
  B. Using IN will display all the product names.
  C. Using NOT IN or ANY will give the same result.
  D. Using ANY will display all the product names.
  E. Using NOT IN or ANY will give the same result.
  A. Using ANY will display all the product names except the product named Fork.
  E. Using NOT IN or ANY will give the same result.

• Question 9:

  Examine this statement:

  

  Which two things must be changed for it to execute successfully? (Choose two.)

  A. The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.
  B. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
  C. The primary key constraint on EMP_ID must have a name.
  D. One of the LONG columns must be changed to a VARCHAR2 or CLOB.
  E. The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.
  B. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
  D. One of the LONG columns must be changed to a VARCHAR2 or CLOB.

• Question 10:

  Examine this partial statement:

  

  Which is true?

  A. Both the query and the subquery can select only zero rows or one row.
  B. Both the query and the subquery can select any number of rows.
  C. The query can select only zero rows or one row, but the subquery can select any number of rows.
  D. The query can select any number of rows, but the subquery can select only zero rows or one row.
  D. The query can select any number of rows, but the subquery can select only zero rows or one row.

  ---

  explanation:

  Explanation/Reference:

  Reference: https://community.oracle.com/tech/developers/discussion/3684885/statements-about-subqueries