Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 361:

  You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.

  Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

  A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)
  B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
  C. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM
  D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE
  D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

• Question 362:

  Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.

  In which three scenarios do you need media recovery? (Choose three.)

  A. loss of all the copies of the control file
  B. loss of all the inactive online redo log group members
  C. loss of a data file that belongs to the active undo tablespace
  D. loss of data files that belong to the SYSTEM tablespace
  E. logical corruption of data that is caused by a wrong transaction
  F. abnormal termination of the database instance
  A. loss of all the copies of the control file
  C. loss of a data file that belongs to the active undo tablespace
  D. loss of data files that belong to the SYSTEM tablespace

• Question 363:

  You find this query being used in your Oracle 12c database:

  

  Which method a used by the optimizer to limit the rows being returned?

  A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
  B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
  C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
  D. A TOP-N query is created to limit the rows to 20 percent of the total rows
  C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

• Question 364:

  Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

  A. A DBA can check specific tables with the DMU
  B. The database to be migrated must be opened read-only.
  C. The release of the database to be converted can be any release since 9.2.0.8.
  D. The DMU can report columns that are too long in the converted characterset.
  E. The DMU can report columns that are not represented in the converted characterset.
  A. A DBA can check specific tables with the DMU
  D. The DMU can report columns that are too long in the converted characterset.
  E. The DMU can report columns that are not represented in the converted characterset.

  ---

  A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.

  D: Exceed column limit

  The cell data will not fit into a column after conversion.

  E: Need conversion

  The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

  * Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.

  Incorrect:

  Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.

• Question 365:

  Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.

  Examine the following command and its output:

  $ crsctl config has

  CRS-4622: Oracle High Availability Services auto start is enabled.

  What does this imply?

  A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
  B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
  C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
  D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
  B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

  ---

  About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances. http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

• Question 366:

  Examine the details of the uncompressed, non-partitioned heap table CITIES.

  

  Examine the command:

  SQL> ALTER TABLE cities SHRINK SPACE COMPACT;

  What must you do before executing it?

  A. Ensure free space that is approximately equal to the space used by the table should be available.
  B. Ensure there are no pending transactions on the table.
  C. Enable row movement is enabled.
  D. Disable all indexes on the table.
  C. Enable row movement is enabled.

• Question 367:

  Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

  A. dbca
  B. asmca
  C. netca
  D. netmgr
  E. lsnrctl
  C. netca
  E. lsnrctl

  ---

  Reference: https://community.oracle.com/thread/3781791?start=15andtstart=0

• Question 368:

  Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

  A. SPFILEs and PFILEs may both be edited with an O/S editing utility
  B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
  C. A SPFILE can be created by an idle instance
  D. A PFILE can be created by an idle instance
  E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause
  F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
  B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
  D. A PFILE can be created by an idle instance
  E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause

• Question 369:

  In which situations does the Database Writer process (DBWn) write to data files? (choose two).

  A. when the RMAN recovery process starts
  B. when a user process commits a transaction
  C. when a tablespace is made read-only or taken offline
  D. when PMON cleans up dirty buffers in the database buffer cache
  E. when clean buffers for reading new blocks into the database buffer cache are not found easily
  B. when a user process commits a transaction
  D. when PMON cleans up dirty buffers in the database buffer cache

  ---

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm

• Question 370:

  Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction? (Choose four.)

  A. The Oracle server waits for all sessions to disconnect before completing the shutdown.
  B. An instance shutdown will occur if the transaction issues a COMMIT.
  C. Sessions are unable to begin new transactions.
  D. All sessions are terminated when the transaction ends.
  E. An instance shutdown will occur if the transaction issues a ROLLBACK.
  F. All the active transactions are rolled back and all user sessions are terminated.
  G. The next startup requires instance recovery, which occurs automatically.
  C. Sessions are unable to begin new transactions.
  E. An instance shutdown will occur if the transaction issues a ROLLBACK.
  F. All the active transactions are rolled back and all user sessions are terminated.
  G. The next startup requires instance recovery, which occurs automatically.

  ---

  Reference: https://www.oracletutorial.com/oracle-administration/oracle-shutdown/