Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 81:

  Which three are true about the Oracle Optimizer? (Choose three.)

  A. It determines the optimal table join order and method.
  B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
  C. It can optimize only SELECT statements.
  D. It will only generate SQL Plan Directives specific to a given SQL statement.
  E. It can re-optimize execution plans after previous executions detect suboptimal plans.
  F. It updates stale object statistics in the Data Dictionary.
  A. It determines the optimal table join order and method.
  B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
  C. It can optimize only SELECT statements.

• Question 82:

  In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA.

  Examine these parameters: Which tablespace stores UNDO generated by USER1's DML on temporary tables?

  

  A. DATA
  B. SYSTEM
  C. SYSAUX
  D. TEMP
  E. UNDOTBS1
  D. TEMP

• Question 83:

  The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.

  Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

  Examine this command:

  

  How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

  A. as SCOTT in BOSTON_DB
  B. as SYS in both the databases
  C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
  D. as SCOTT in both the databases
  E. as SCOTT in DALLAS_DB
  D. as SCOTT in both the databases

• Question 84:

  Yom database is in ARCHIEVELOG mode. The USER)! tablespace is online in read write and no error conditions exists for any of its data files.

  You want to take USER01 offline so that all existing transactions involving objects in it can complete. What must yon do?

  A. Change its state to read only, and then take it offline with the temporary option.
  B. Take it offline with the normal option.
  C. Take it offline with the temporary option.
  D. Take it offline with the immediate option.
  E. Change its state to read only, and then take it offline with the normal option.
  F. Change its state to read only, and then take it offline with the immediate option.
  E. Change its state to read only, and then take it offline with the normal option.

• Question 85:

  Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

  A. Run the Pre-Upgrade information tool on the source database.
  B. Take all user tablespaces offline before starting the upgrade.
  C. Copy the network configuration files from the existing database home to the new Oracle home location.
  D. Run the Parallel Upgrade utility from the new Oracle home.
  E. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.
  F. Make all user tablespaces "read only" before starting the upgrade.
  G. Start the existing database in upgrade mode.
  A. Run the Pre-Upgrade information tool on the source database.
  D. Run the Parallel Upgrade utility from the new Oracle home.
  G. Start the existing database in upgrade mode.

• Question 86:

  Which two functions are performed by a listener?

  A. creating a user session in the System Global Area (SGA)
  B. verifying the service name in an incoming user request
  C. verifying a user's authentication credentials
  D. maintaining the connection to a client's user process until the user request is completed
  E. returning the results of processing from the server process to the user process
  F. connecting a user process to a server process
  E. returning the results of processing from the server process to the user process
  F. connecting a user process to a server process

• Question 87:

  Examine these commands:

  

  What is the expected result?

  A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.
  B. Only the first row in EMP.DAT is inserted into U1.EMP.
  C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.
  D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.
  E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.
  D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.