Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 241:

  Examine the current value for the following parameters in your database instance:

  SGA_MAX_SIZE = 1024M

  SGA_TARGET = 700M

  DB_8K_CACHE_SIZE = 124M

  LOG_BUFFER = 200M

  You issue the following command to increase the value of DB_8K_CACHE_SIZE:

  SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

  Which statement is true?

  A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
  B. It succeeds only if memory is available from the autotuned components if SGA.
  C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
  D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
  D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

  ---

  *

  The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.

  *

  Example:

  For example, suppose you have an environment with the following configuration:

  SGA_MAX_SIZE = 1024M

  SGA_TARGET = 512M

  DB_8K_CACHE_SIZE = 128M

  In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as

  the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M

  *

  DB_8K_CACHE_SIZE

  Size of cache for 8K buffers

  *

  For example, consider this configuration:

  SGA_TARGET = 512M

  DB_8K_CACHE_SIZE = 128M

  In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the

  automatically sized components.

• Question 242:

  Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

  A. All administration tasks must be done to a specific pluggable database.
  B. The pluggable databases increase patching time.
  C. The pluggable databases reduce administration effort.
  D. The pluggable databases are patched together.
  E. Pluggable databases are only used for database consolidation.
  C. The pluggable databases reduce administration effort.
  D. The pluggable databases are patched together.

• Question 243:

  The HR user receives the following error while inserting data into the sales table:

  

  On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.

  Which two methods would you use to resolve this error? (Choose two.)

  A. Altering the data file associated with the USERS tablespace to extend automatically
  B. Adding a data file to the USERS tablespace
  C. Changing segment space management for the USERS tablespace to manual
  D. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
  E. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
  A. Altering the data file associated with the USERS tablespace to extend automatically
  B. Adding a data file to the USERS tablespace

• Question 244:

  When does a database checkpoint occur?

  A. When there is an online redo log switch.
  B. When a user session terminates abnormally.
  C. When a server process terminates abnormally.
  D. When the SHUTDOWN ABORT command is issued.
  A. When there is an online redo log switch.

• Question 245:

  Your database is configured in ARCHIVELOG mode.

  Examine the RMAN configuration parameters:

  

  Examine the command:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which two are true? (Choose two.)

  A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command
  B. It creates image copies of the archivelogs
  C. It creates a backupset of archive log files
  D. It creates image copies of the database files
  E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command
  B. It creates image copies of the archivelogs
  E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

• Question 246:

  Examine the parameter for your database instance:

  

  You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

  

  Identify the reason why the optimizer chose different execution plans.

  A. The optimizer used a dynamic plan for the query.
  B. The optimizer chose different plans because automatic dynamic sampling was enabled.
  C. The optimizer used re-optimization cardinality feedback for the query.
  D. The optimizer chose different plan because extended statistics were created for the columns used.
  A. The optimizer used a dynamic plan for the query.

• Question 247:

  Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

  A. All AWR tables belong to the SYSTEM schema.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
  E. AWR contains system wide tracing and logging information.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

• Question 248:

  Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. The ADDM requires at least four AWR snapshots for analysis
  B. The ADDM runs after each AWR snapshot is collected automatically by MMON
  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
  D. The ADDM analysis provides only diagnostics information but does not provide recommendations
  E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
  B. The ADDM runs after each AWR snapshot is collected automatically by MMON
  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

• Question 249:

  Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

  A. An Oracle database instance can support only one DBaaS instance.
  B. A DBaaS instance can support only one Oracle database instance.
  C. An Oracle database instance can support multiple DBaaS instances.
  D. A DBaaS instance can support multiple Oracle database instances.
  E. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).
  D. A DBaaS instance can support multiple Oracle database instances.

• Question 250:

  Which two statements are true? (Choose two.)

  A. A role cannot be assigned external authentication.
  B. A role can be granted to other roles.
  C. A role can contain both system and object privileges.
  D. The predefined RESOURCE role includes the UNLIMITED TABLESPACE privilege.
  E. All roles are owned by the SYS user.
  F. The predefined CONNECT role is always automatically granted to all new users at the time of their creation.
  B. A role can be granted to other roles.
  C. A role can contain both system and object privileges.