Oracle-1z0-060new(3)

Oracle 1z0-060 : Practice Test

* Parallel query

Parallel query uses shared pool memory to cache parallel execution message buffers.

* Recovery Manager

Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup andrestore operations. For I/O server processes, backup, and restore operations, OracleDatabase allocates buffers that are a few hundred kilobytes in size.

Question No : 12What are three purposes of the RMAN “FROM” clause?

A. to support PUSH-based active database duplication

B. to support synchronization of a standby database with the primary database in a Dataenvironment

C. To support PULL-based active database duplication

D. To support file restores over the network in a Data Guard environment E. To support file recovery over the network in a Data Guard environment

Answer: B,D,EExplanation: DE:

* With a control file autobackup, RMAN can recover the database even if the currentcontrol file, recovery catalog, and server parameter file are inaccessible.

* RMAN uses a recovery catalog to track filenames for all database files in a Data Guardenvironment. A recovery catalog is a database schema used by RMAN to store metadataabout one or more Oracle databases. The catalog also records where the online redo logs,standby redo logs, tempfiles, archived redo logs, backup sets, and image copies arecreated.

Question No : 13You notice that the performance of your production 24/7 Oracle database significantlydegraded. Sometimes you are not able to connect to the instance because it hangs. Youdo not want to restart the database instance.

11

Oracle 1z0-060 : Practice Test

How can you detect the cause of the degraded performance?

A. Enable Memory Access Mode, which reads performance data from SGA. B. Use emergency monitoring to fetch data directly from SGA analysis.

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latestAutomatic Workload Repository (AWR) snapshots.

D. Use Active Session History (ASH) data and hang analysis in regular performancemonitoring.

E. Run ADDM in diagnostic mode.

Answer: B

Question No : 14You plan to use the In Database Archiving feature of Oracle Database 12c, and store rowsthat are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Networkarray

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files D. Database files stored in ZFS and accessed using conventional NFS mounts. E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature F. Database files stored in any file system and accessed using the Oracle Direct NFSfeature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: A,E,G

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) orSun ZFS Storage Appliance (ZFSSA).

Note:

* Hybrid Columnar Compression, initially only available on Exadata, has been extended tosupport Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used withOracle Database Enterprise Edition 11.2.0.3 and above

* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS).Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself.Oracle Direct NFS client overcomes many of the challenges associated with using NFS

12

Oracle 1z0-060 : Practice Test

with the Oracle Database with simple configuration, better performance than traditionalNFS clients, and offers consistent configuration across platforms.

Question No : 15In your multitenant container database (CDB) containing pluggable databases (PDB), userscomplain about performance degradation.

How does real-time Automatic database Diagnostic Monitor (ADDM) check performancedegradation and provide solutions?

A. It collects data from SGA and compares it with a preserved snapshot. B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report.

Answer: BExplanation: Note:

* The multitenant architecture enables an Oracle database to function as a multitenantcontainer database (CDB) that includes zero, one, or many customer-created pluggabledatabases (PDBs). A PDB is a portable collection of schemas, schema objects, andnonschema objects that appears to an Oracle Net client as a non-CDB. All Oracledatabases before Oracle Database 12c were non-CDBs.

* The System Global Area (SGA) is a group of shared memory areas that are dedicated toan Oracle “instance” (an instance is your database programs and RAM).

* The PGA (Program or Process Global Area) is a memory area (RAM) that stores dataand control information for a single process.

Question No : 16The tnsnames.ora file has an entry for the service alias ORCL as follows:

13

Oracle 1z0-060 : Practice Test

The TNS ping command executes successfully when tested with ORCL; however, from thesame OS user session, you are not able to connect to the database instance with thefollowing command:

SQL > CONNECT scott/tiger@orcl

What could be the reason for this?

A. The listener is not running on the database node.

B. The TNS_ADMIN environment variable is set to the wrong value.

C. The orcl.oracle.com database service is not registered with the listener.

D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file. E. The listener is running on a different port.

Answer: C

Explanation: Service registration enables the listener to determine whether a databaseservice and its service handlers are available. A service handler is a dedicated server

process or dispatcher that acts as a connection point to a database. During registration, theLREG process provides the listener with the instance name, database service names, andthe type and addresses of service handlers. This information enables the listener to start aservice handler when a client request arrives.

Question No : 17Examine the following steps of privilege analysis for checking and revoking excessive,unused privileges granted to users:

1. Create a policy to capture the privilege used by a user for privilege analysis.

2. Generate a report with the data captured for a specified privilege capture.

3. Start analyzing the data captured by the policy.

4. Revoke the unused privileges.

14

Oracle 1z0-060 : Practice Test

5. Compare the used and unused privileges’ lists.

6. Stop analyzing the data.

Identify the correct sequence of steps.

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

Answer: B

Explanation: 1. Create a policy to capture the privilege used by a user for privilegeanalysis.

3. Start analyzing the data captured by the policy. 6. Stop analyzing the data.

2. Generate a report with the data captured for a specified privilege capture. 5. Compare the used and unused privileges’ lists. 4. Revoke the unused privileges.

Question No : 18You database is running an ARCHIVELOG mode.

The following parameter are set in your database instance:

LOG_ARCHIVE_FORMAT = arch+%t_%r.arc

LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’

DB_RECOVERY_FILE_DEST_SIZE = 50G

DB_RECOVERY_FILE = ‘/u01/oradata’

Which statement is true about the archived redo log files?

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1parameter.

15

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle-1z0-060new(3)在线全文阅读。