Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 311:

  Examine the description of the CUSTOMERS table:

  

  Which three statements will do an implicit conversion?

  A. SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';
  B. SELECT * FROM customers WHERE customer_id='0001';
  C. SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';
  D. SELECT * FROM customers WHERE insert_date'01-JAN-19';
  E. SELECT * FROM customers WHERE customer_id=0001;
  F. SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';
  B. SELECT * FROM customers WHERE customer_id='0001';
  C. SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';
  D. SELECT * FROM customers WHERE insert_date'01-JAN-19';

• Question 312:

  Examine these SQL statements Which execute successfully:

  

  Which two statements are true after execution?

  A. The primary key constraint will be enabled and DEFERRED.
  B. The primary key constraint will be enabled and IMMEDIATE.
  C. The foreign key constraint will be disabled.
  D. The foreign key constraint will be enabled and DEFERRED.
  E. The foreign key constraint will be enabled and IMMEDIATE.
  B. The primary key constraint will be enabled and IMMEDIATE.
  C. The foreign key constraint will be disabled.

• Question 313:

  Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

  A. During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and Which is cached in memory, is always reused for the current execution.
  B. During execution, the Oracle server may read data from storage if the required data is not already in memory.
  C. During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.
  D. During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.
  B. During execution, the Oracle server may read data from storage if the required data is not already in memory.

• Question 314:

  Which two statements are true regarding a SAVEPOINT?

  A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement.
  B. Only one SAVEPOINT may be issued in a transaction.
  C. A SAVEPOINT does not issue a COMMIT
  D. Rolling back to a SAVEPOINT can undo a TRUNCATE statement.
  E. Rolling back to a SAVEPOINT can undo a DELETE statement
  C. A SAVEPOINT does not issue a COMMIT
  E. Rolling back to a SAVEPOINT can undo a DELETE statement

• Question 315:

  You have the privileges to create any type of synonym.

  Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

  A. CREATE PUBLIC SYNONYM emp FOR hcm.employee_records;
  B. CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;
  C. CREATE SYNONYM emp FOR hcm.employee_records:
  D. CREATE SYNONYM SYS.emp FOR hcm.employee_records;
  E. CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;
  A. CREATE PUBLIC SYNONYM emp FOR hcm.employee_records;

• Question 316:

  Examine this incomplete query:

  SELECT DATE '2019-01-01' + FROM DUAL;

  Which three clauses can replace to add 12 hours to the date? (Choose three.)

  A. INTERVAL '0.5' DAY
  B. INTERVAL '720' MINUTE
  C. INTERVAL '11:60' HOUR TO MINUTE
  D. INTERVAL '12:00' HOUR TO SECOND
  E. INTERVAL '0 12' DAY TO HOUR
  F. INTERVAL '12' HOUR
  B. INTERVAL '720' MINUTE
  E. INTERVAL '0 12' DAY TO HOUR
  F. INTERVAL '12' HOUR

• Question 317:

  You own table DEPARTMENTS, referenced by views, indexes, and synonyms.

  Examine this command Which executes successfully:

  DROP TABLE departments PURGE;

  Which three statements are true?

  A. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
  B. It will remove all views that are based on the DEPARTMENTS table.
  C. It will delete all rows from the DEPARTMENTS table, but retain the empty table.
  D. It will remove the DEPARTMENTS table from the database.
  E. It will remove all synonyms for the DEPARTMENTS table.
  F. It will drop all indexes on the DEPARTMENTS table.
  A. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
  D. It will remove the DEPARTMENTS table from the database.
  F. It will drop all indexes on the DEPARTMENTS table.

  ---

  Explanation/Reference:

  Reference:https //docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505

• Question 318:

  Examine this data in the EMPLOYERS table

  

  Which statement will execute successfully?

  A. SELECT dept_id, INSTR(last_name, `A'), SUM(salary) FROM employees GROUP BY dept_id;
  B. SELECT dept_id, STDDEV(last_name), SUM(salary) FROM employees GROUP BY dept_id;
  C. SELECT dept_id, LENGTH(last_name), SUM(salary) FROM employees GROUP BY dept_id;
  D. SELECT dept_id, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;
  D. SELECT dept_id, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;

• Question 319:

  Which three statements are true about the ALTER TABLE....DROP COLUMN.... command?

  A. A column can be dropped only if it does not contain any data.
  B. A column can be dropped only if another column exists in the table.
  C. A dropped column can be rolled back.
  D. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
  E. A parent key column in the table cannot be dropped.
  B. A column can be dropped only if another column exists in the table.
  D. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
  E. A parent key column in the table cannot be dropped.

• Question 320:

  Evaluate the following ALTER TABLE statement:

  ALTER TABLE orders

  SET UNUSED (order_date);

  Which statement is true?

  A. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.
  B. The ORDER_DATE column must be empty for the ALTER TABLE command to execute successfully.
  C. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
  D. The DESCRIBE command would still display the ORDER_DATE column.
  A. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.