Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 361:

  The STORES table has a column START_ DATE of data type DATE, containing the date the row was inserted.

  You only want to display details of rows where START_ DATE is within the last 25 months.

  Which WHERE clause can be used?

  A. WHERE MONTHS_ BETWEEN (SYSDATE, start_ date)
  B. WHERE MONTHS_ BETWEEN (start_ date, SYSDATE)
  C. WHERE TO_ NUMBER (start_ date - SYSDATE)
  D. WHERE ADD_ MONTHS (start_ date, 25)
  A. WHERE MONTHS_ BETWEEN (SYSDATE, start_ date)

• Question 362:

  Which three items does a direction of a relationship contain?

  A. an attribute
  B. a cardinality
  C. label
  D. an optionality
  E. a unique identifier
  F. an entity
  A. an attribute
  B. a cardinality
  F. an entity

• Question 363:

  Which two will execute successfully?

  A. SELECT COALESCR('DATE', SYSDATE) FROM DUAL;
  B. SELECT NVL('DATE',SYSDATE) FROM DUAL;
  C. SELECT COALESCE(O,SYSDATE) TRCH DUAL;
  D. SELECT NVL('DATE', 200) FROM (SELECT NULL AS "DATE" FROM DUAL);
  E. SELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;
  B. SELECT NVL('DATE',SYSDATE) FROM DUAL;
  D. SELECT NVL('DATE', 200) FROM (SELECT NULL AS "DATE" FROM DUAL);

• Question 364:

  Which two are true about constraints? (Choose two.)

  A. A column with a FOREIGN KEY constraint can never contain a NULL value.
  B. A constraint can be disabled even if the constrained column contains data.
  C. Constraints are enforced only during INSERT operations.
  D. All constraints can be defined at the table or column level.
  E. A column with a UNIQUE constraint can contain a NULL value.
  B. A constraint can be disabled even if the constrained column contains data.
  E. A column with a UNIQUE constraint can contain a NULL value.

• Question 365:

  You issued this command:

  DROP TABLE hr.employees;

  Which three statements are true? (Choose three.)

  A. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
  B. Synonyms for HR.EMPLOYEES are dropped.
  C. Views referencing HR.EMPLOYEES are dropped.
  D. All constraints defined on HR.EMPLOYEES are dropped.
  E. The HR.EMPLOYEES table may be moved to the recycle bin.
  F. All indexes defined on HR.EMPLOYEES are dropped
  D. All constraints defined on HR.EMPLOYEES are dropped.
  E. The HR.EMPLOYEES table may be moved to the recycle bin.
  F. All indexes defined on HR.EMPLOYEES are dropped

• Question 366:

  Which two are true about global temporary tables? (Choose two.)

  A. Indexes can be created on them.
  B. Backup and recovery operations are available for these tables.
  C. Their data is always stored in the default temporary tablespace of the user who created them.
  D. If the ON COMMIT clause is transaction-specific, all rows in the table are deleted after each COMMIT OR ROLLBACK.
  E. They can be created only by a user with the DBA role, but can be accessed by all users who can create a session.
  F. If the ON COMMIT clause is session-specific, the table is dropped when the session is terminated.
  A. Indexes can be created on them.
  D. If the ON COMMIT clause is transaction-specific, all rows in the table are deleted after each COMMIT OR ROLLBACK.

• Question 367:

  Examine these SQL statements that are executed in the given order:

  

  What will be the status of the foreign key EMP_MGR_FK?

  A. It will be enabled and immediate.
  B. It will be enabled and deferred.
  C. It will remain disabled and can be re-enabled manually.
  D. It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
  C. It will remain disabled and can be re-enabled manually.

• Question 368:

  No-user-defined locks are used in your database.

  Which three are true about Transaction Control Language (TCL)?

  A. COMMIT erases all the transaction's savepoints and releases its locks.
  B. COMMIT ends the transaction and makes all its changes permanent.
  C. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
  D. ROLLBACK to SAVEPOTNT undoes the transaction's changes made since the named savepoint and then ends the transaction.
  E. ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.
  F. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
  A. COMMIT erases all the transaction's savepoints and releases its locks.
  B. COMMIT ends the transaction and makes all its changes permanent.
  E. ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.

• Question 369:

  Examine these statements which execute successfully:

  

  Both statements display departments ordered by their average salaries.

  Which two are true? (Choose two.)

  A. Both statements will execute successfully if you add E.AVG_SAL to the select list.
  B. Both statements will display departments with no employees.
  C. Only the second statement will execute successfully if you add E.AVG_SAL to the select list.
  D. Only the first statement will display departments with no employees.
  E. Only the second statement will display departments with no employees.
  F. Only the first statement will execute successfully if you add E.AVG_SAL to the select list.
  B. Both statements will display departments with no employees.
  C. Only the second statement will execute successfully if you add E.AVG_SAL to the select list.

• Question 370:

  You currently have an active transaction in your session and have been granted SELECT access to

  V$TRANSACTION.

  Executing:

  SELECT xid, status FROM v$transaction;

  in your session returns:

  

  In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started? (Choose three.)

  A. after successfully executing a CREATE TABLE statement followed by a CREATE INDEX statement
  B. after successfully executing a TRUNCATE statement followed by a DML statement
  C. after successfully executing a DML statement following a failed DML statement
  D. after successfully executing a CREATE TABLE AS SELECT statement followed by a SELECT FOR UPDATE statement
  E. after successfully executing a COMMIT or ROLLBACK followed by a DML statement
  F. after successfully executing a COMMIT or ROLLBACK followed by a SELECT statement
  B. after successfully executing a TRUNCATE statement followed by a DML statement
  D. after successfully executing a CREATE TABLE AS SELECT statement followed by a SELECT FOR UPDATE statement
  E. after successfully executing a COMMIT or ROLLBACK followed by a DML statement