Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 191:

  Which two statements are true about Oracle network connections? (Choose two.)

  A. A listener may listen on behalf of only one database instance at a time.

  B. A server process checks a user's authentication credentials and creates a session if the credentials are valid.

  C. The listener continuously monitors a connection after the user process connects to a service handler.

  D. The listener always spawns a new server process to deal with each new connection.

  E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

  Correct Answer: BE

• Question 192:

  Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

  A. Configure Label Security

  B. Database Vault in ORACLE_HOME

  C. Oracle Suggested Backup Strategy

  D. Database Resident Connection Pooling

  E. Nondefault blocksize tablespaces

  Correct Answer: AB

• Question 193:

  You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA).

  Which option should you use?

  A. Automatic Storage Management (ASM) for storage of data files

  B. a file system for storage of data files

  C. a Data Warehouse database template

  D. a custom database template

  Correct Answer: D

• Question 194:

  Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.

  Which statement is true about the loss of a duplexed control file?

  A. The database remains open but transactions are not permitted.

  B. The database instance aborts, and media recovery is required after restoration of the control file to open the database.

  C. The database instance remains open and the control file can be restored without shutting down the database.

  D. The database instance aborts and a control file restore operation does not require media recovery.

  Correct Answer: C

• Question 195:

  Examine the parameter settings in your local ORCL database:

  

  Examine the parameter settings for the remote SALES database:

  

  As the SYS user, you issue the following command on ORCL:

  CREATE PUBLIC DATABASE LINK sales.us.example.com USING `sales1';

  The sales1 tnsnames entry points to the sales database instance.

  Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

  A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.

  B. The SALES1 net service name should be known to both the local and remote databases.

  C. Local database users who use this database link should have accounts and the required privileges in the remote database.

  D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.

  E. Only the user creating the database link must have an account and the required privileges in the remote database.

  Correct Answer: AC

• Question 196:

  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

  Correct Answer: BCF

• Question 197:

  You are administering a database that supports an OLTP workload.

  The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause

  and undo retention set to 12 minutes.

  The user SCOTT queries a large table during peak activity.

  The query runs for more than 15 minutes and then SCOTT receives the following error:

  ORA-01555: snapshot too old

  Which is possible reason for this?

  A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

  B. The query is unable to place data blocks in the UNDO tablespace.

  C. The flashback data archive is not enabled for the table on which the query is issued.

  D. There is not enough space in Fast Recovery Area.

  E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

  Correct Answer: A

• Question 198:

  Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

  A. segments in tablespaces that have exceeded a critical or warning space threshold

  B. segments that have the highest growth rate in a database

  C. segments that are sparsely populated and have more than 10% of free space below the high water mark.

  D. segments that have unusable indexes

  E. segments for tables created using ADVANCED ROW COMPRESSION

  Correct Answer: AB

  References: http://www.dba-oracle.com/t_segment_advisor_10g.htm

• Question 199:

  Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the

  following command:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

  Which statement is true?

  A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

  B. It fails because DB_CACHE_SIZE is a static initialization parameter.

  C. It fails because ASMM is enabled and individual SGA components cannot be sized.

  D. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

  Correct Answer: A

• Question 200:

  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

  Correct Answer: BD

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