Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 321:

  To enable the Database Smart Flash Cache, you configure the following parameters:

  DB_FLASH_CACHE_FILE = `/dev/flash_device_1' , `/dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G

  What is the result when you start up the database instance?

  A. It results in an error because these parameter settings are invalid.
  B. One 64G flash cache file will be used.
  C. Two 64G flash cache files will be used.
  D. Two 32G flash cache files will be used.
  A. It results in an error because these parameter settings are invalid.

• Question 322:

  You set the following parameters in the parameter file and restart the database instance:

  

  Which two statements are true? (Choose two.)

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
  C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
  D. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.
  E. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.
  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  D. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

• Question 323:

  Which three are activities performed by SMON? (Choose three.)

  A. cleaning up the database buffer cache and freeing resources that a client process was using
  B. applying online redo during instance recovery
  C. cleaning up temporary segments that are no longer needed
  D. performing database services registration with the default listener
  E. restarting a server or a dispatcher process that terminated abnormally
  F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors
  B. applying online redo during instance recovery
  C. cleaning up temporary segments that are no longer needed
  F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

• Question 324:

  Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

  

  Which two statements are true? (Choose two.)

  A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
  B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
  C. The command will, create a common user whose description is contained in the root and each PDB.
  D. The schema for the common user C # # A_ADMIN can be different in each container.
  E. The command will create a user in the root container only because the container clause is not used.
  C. The command will, create a common user whose description is contained in the root and each PDB.
  D. The schema for the common user C # # A_ADMIN can be different in each container.

• Question 325:

  Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

  A. online redo log files
  B. parameter file
  C. multiplexed copies of the current control file
  D. archived log files
  E. Flashback Data Archive files
  F. Flashback logs
  A. online redo log files
  D. archived log files
  F. Flashback logs

• Question 326:

  Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

  A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.
  B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
  C. Install Oracle HTTP Server.
  D. Configure at least one dispatcher for the TCP/IP protocol.
  E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.
  D. Configure at least one dispatcher for the TCP/IP protocol.
  E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.

• Question 327:

  Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

  A. listener configured by using NETCA
  B. database service created by using SRVCTL
  C. database created by using a SQL statement
  D. database created by using DBCA
  E. ASM instance created by using ASMCA
  F. database service created by using DBMS_SERVICE.CREATE_SERVICE
  G. database service created by modifying the SERVICE_NAMES initialization parameter
  B. database service created by using SRVCTL
  C. database created by using a SQL statement
  E. ASM instance created by using ASMCA
  F. database service created by using DBMS_SERVICE.CREATE_SERVICE

  ---

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart002.htm#insertedID3

• Question 328:

  Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

  A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
  B. It automatically makes necessary changes to Oracle environment variables.
  C. It automatically enables unified auditing in the upgraded database.
  D. It automatically adds new data files if there is not enough disk space to grow.
  D. It automatically adds new data files if there is not enough disk space to grow.

  ---

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5

• Question 329:

  You enabled an audit policy by issuing the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

  For which database users and for which executions is the audit policy now active? Select two.

  A. SYS, SYSTEM
  B. SCOTT
  C. Only for successful executions
  D. Only for failed executions
  E. Both successful and failed executions
  A. SYS, SYSTEM
  E. Both successful and failed executions

  ---

  * The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

• Question 330:

  Examine the following command:

  SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');

  What is the effect of executing this command?

  A. Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
  B. Automatic statistics collection is stopped for the CUSTOMERS table.
  C. Statistics for the CUSTOMERS table are locked and cannot be overwritten.
  D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.
  D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.