Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 161:

  Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.

  Which two statements are true in this scenario? (Choose two.)

  A. The user-managed backup consists of only formatted data blocks.
  B. The database must be shut down to take a user-managed backup.
  C. The RMAN backup contains only data files.
  D. The RMAN backup can be performed while the database is open.
  E. The database must be in MOUNT state to take RMAN backup.
  A. The user-managed backup consists of only formatted data blocks.
  B. The database must be shut down to take a user-managed backup.

• Question 162:

  You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

  A. RBAL
  B. CKPT
  C. SMON
  D. PMON
  E. MMON
  F. CTWR
  G. DBWR
  F. CTWR

• Question 163:

  Examine these commands:

  

  Now examine these steps:

  1) STARTUP NOMOUNT 2) STARTUP MOUNT 3) STARTUP FORCE 4) ALTER DATABASE ARCHIVELOG; 5) SHUTDOWN TRANSACTIONAL 6) ALTER DATABASE OPEN; 7) SHUTDOWN ABORT 8) ALTER DATABASE MOUNT

  Identify the required steps in the correct order to change the database to run in ARCHIVELOG mode.

  A. 5, 2, 4, 6
  B. 5, 1, 4, 8, 6
  C. 5, 1, 4, 6
  D. 7, 1, 4, 8, 6
  E. 5, 3, 4, 6
  F. 5, 2, 6, 4
  D. 7, 1, 4, 8, 6

  ---

  Reference: https://support.arcserve.com/s/article/202782255?language=en_US

• Question 164:

  You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.

  Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

  A. Archived redo log files that have multiple copies in a different archive location
  B. user-managed backups of data files and control files
  C. RMAN backups that are obsolete
  D. flashback logs
  C. RMAN backups that are obsolete
  D. flashback logs

• Question 165:

  Examine the following parameters for a database instance:

  MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m

  Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

  A. LOG_BUFFER
  B. SORT_AREA_SIZE
  C. JAVA_POOL_SIZE
  D. STREAMS_POOL_SIZE
  E. DB_16K_CACHE_SZIE
  F. DB_KEEP_CACHE_SIZE
  A. LOG_BUFFER
  E. DB_16K_CACHE_SZIE
  F. DB_KEEP_CACHE_SIZE

  ---

  Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter / The log buffer LOG_BUFFER / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE

  Note:

  *

  In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.

  *

  Table, Automatically Sized SGA Components and Corresponding Parameters

  

• Question 166:

  In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.

  On further investigation, you find that buffer busy waits is caused by contention on data blocks.

  Which option would you consider first to decrease the wait event immediately?

  A. Decreasing PCTUSED
  B. Decreasing PCTFREE
  C. Increasing the number of DBWN process
  D. Using Automatic Segment Space Management (ASSM)
  E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
  D. Using Automatic Segment Space Management (ASSM)

  ---

  *

  Automatic segment space management (ASSM) is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the pctused,freelists, and freelist groups storage parameters for schema objects created in the tablespace. If any of these attributes are specified, they are ignored.

  *

  Oracle introduced Automatic Segment Storage Management (ASSM) as a replacement for traditional freelists management which used one-way linked-lists to manage free blocks with tables and indexes. ASSM is commonly called "bitmap freelists" because that is how Oracle implement the internal data structures for free block management.

  Note:

  *

  Buffer busy waits are most commonly associated with segment header contention onside the data buffer pool (db_cache_size, etc.).

  *

  The most common remedies for high buffer busy waits include database writer (DBWR) contention tuning, adding freelists (or ASSM), and adding missing indexes.

• Question 167:

  Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.

  You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.

  What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

  A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
  B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
  C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
  D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
  D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

  ---

  * You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.

• Question 168:

  Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.

  Which command must you execute before starting the recovery of this tablespace?

  A. ALTER TABLESPACE users OFFLINE
  B. STARTUP FORCE NOMOUNT
  C. STARTUP FORCE
  D. SWITCH DATAFILE ALL
  A. ALTER TABLESPACE users OFFLINE

• Question 169:

  What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

  A. Effectively implements role separation
  B. Enables you to take advantage of Oracle Managed Files.
  C. Automatically registers the database with Oracle Restart.
  D. Helps you to easily upgrade the database from a prior release.
  E. Enables the Installation of Grid Infrastructure files on block or raw devices.
  A. Effectively implements role separation
  C. Automatically registers the database with Oracle Restart.

  ---

  C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart.

  Desupport of Block and Raw Devices

  With the release of Oracle Database 11g release 2 (11.2) and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files directly on block or raw devices is

  not supported.

  If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation.

  Performing a new installation using block or raw devices is not allowed.

• Question 170:

  A user establishes a connection to a database instance by using an Oracle Net. You want to ensure that:

  1.

  The user account must be locked after five consecutive unsuccessful login attempts.

  2.

  Data read per session must be limited for the user.

  3.

  The user cannot have more than three simultaneous sessions.

  4.

  The user must have a maximum of 10 minutes session idle time before being logged off automatically. Which two would you do to implement this? (Choose two.)

  A. by alerting the appropriate user attributes with an ALTER USER command
  B. by using appropriate PASSWORD parameters set in the profile assigned to the user
  C. by implementing Database Resource Manager and assign it a profile for the user
  D. by implementing Database Resource Manager and assign it a role for the user
  E. by using appropriate KERNEL parameters set in the profile assigned to the user
  A. by alerting the appropriate user attributes with an ALTER USER command
  D. by implementing Database Resource Manager and assign it a role for the user