Oracle-1z0-060new(2)

Oracle 1z0-060 : Practice Test

alter the availability of a tablespace.

Question No : 7Which Oracle Database component is audited by default if the unified Auditing option isenabled?

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN) C. Oracle Label Security D. Oracle Database Vault

E. Oracle Real Application Security

Answer: B

Question No : 8Your multitenant container (CDB) containing three pluggable databases (PDBs) is runningin ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the rootcontainer.

The steps to recover the tablespace are as follows:

1. Mount the CDB.

2. Close all the PDBs.

3. Open the database.

4. Apply the archive redo logs.

5. Restore the data file.

6. Take the SYSAUX tablespace offline.

7. Place the SYSAUX tablespace online.

8. Open all the PDBs with RESETLOGS.

9. Open the database with RESETLOGS.

6

Oracle 1z0-060 : Practice Test

10. Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?

A. 6, 5, 4, 7 B. 10, 1, 2, 5, 8

C. 10, 1, 2, 5, 4, 9, 8 D. 10, 1, 5, 8, 10

Answer: A

Explanation: RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE; RMAN> RESTORE TABLESPACE sysaux; RMAN> RECOVER TABLESPACE sysaux;

RMAN> ALTER TABLESPACE sysaux ONLINE;

* Example:

While evaluating the 12c beta3 I was not able to do the recover while testing “all pdb fileslost”.

Cannot close the pdb as the system datafile was missing… So only option to recover was: Shutdown cdb (10) startup mount; (1)

restore pluggable database recover pluggable database alter database open;

alter pluggable database name open;

Oracle support says: You should be able to close the pdb and restore/recover the systemtablespace of PDB.

* Inconsistent backups are usually created by taking online database backups. You canalso make an inconsistent backup by backing up data files while a database is closed,either:

/ Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, allinstances)

/ After shutting down the database using SHUTDOWN ABORT

Inconsistent backups are only useful if the database is in ARCHIVELOG mode and allarchived redo logs created since the backup are available.

* Open the database with the RESETLOGS option after finishing recovery:

7

Oracle 1z0-060 : Practice Test

SQL> ALTER DATABASE OPEN RESETLOGS;

Question No : 9Which three are direct benefits of the multiprocess, multithreaded architecture of OracleDatabase 12c when it is enabled?

A. Reduced logical I/O

B. Reduced virtual memory utilization

C. Improved parallel Execution performance D. Improved Serial Execution performance E. Reduced physical I/O F. Reduced CPU utilization

Answer: B,C,F

Explanation: * Multiprocess and Multithreaded Oracle Database Systems

Multiprocess Oracle Database (also called multiuser Oracle Database) uses severalprocesses to run different parts of the Oracle Database code and additional Oracleprocesses for the users—either one process for each connected user or one or moreprocesses shared by multiple users. Most databases are multiuser because a primaryadvantage of a database is managing data needed by multiple users simultaneously.

Each process in a database instance performs a specific job. By dividing the work of thedatabase and applications into several processes, multiple users and applications canconnect to an instance simultaneously while the system gives good performance.

* In previous releases, Oracle processes did not run as threads on UNIX and Linuxsystems. Starting in Oracle Database 12c, the multithreaded Oracle Database modelenables Oracle processes to execute as operating system threads in separate addressspaces.

Question No : 10In order to exploit some new storage tiers that have been provisioned by a storage

8

Oracle 1z0-060 : Practice Test

administrator, the partitions of a large heap table must be moved to other tablespaces inyour Oracle 12c database?

Both local and global partitioned B-tree Indexes are defined on the table.

A high volume of transactions access the table during the day and a medium volume oftransactions access it at night and during weekends.

Minimal disrupt ion to availability is required.

Which three statements are true about this requirement?

A. The partitions can be moved online to new tablespaces.

B. Global indexes must be rebuilt manually after moving the partitions. C. The partitions can be compressed in the same tablespaces. D. The partitions can be compressed in the new tablespaces.

E. Local indexes must be rebuilt manually after moving the partitions.

Answer: A,C,D

Explanation: A: You can create and rebuild indexes online. Therefore, you can updatebase tables at

the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.

D: Moving (Rebuilding) Index-Organized Tables

Because index-organized tables are primarily stored in a B-tree index, you can

encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.

C: If a table can be compressed in the new tablespace, also it can be compressed in thesame tablespace.

http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.html

Incorrect:

Not B, not E: Local and Global indexes can be automatically rebuild with UPDATEINDEXES when you move the table.

9

Oracle 1z0-060 : Practice TestQuestion No : 11Which three are true about the large pool for an Oracle database instance that supportsshared server connections?

A. Allocates memory for RMAN backup and restore operations B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors D. Contains stack space

E. Contains a hash area performing hash joins of tables

Answer: A,B,C

Explanation: The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (usedwhere transactions interact with multiple databases)

/Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves

Note:

* large pool

Optional area in the SGA that provides large memory allocations for backup and restoreoperations, I/O server processes, and session memory for the shared server and OracleXA.

* Oracle XA

An external interface that allows global transactions to be coordinated by a transactionmanager other than Oracle Database.

* UGA

User global area. Session memory that stores session variables, such as logoninformation, and can also contain the OLAP pool.

* Configuring the Large Pool

Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Databasedoes not attempt to age objects out of the large pool. Consider configuring a large pool ifthe database instance uses any of the following Oracle Database features:

* Shared server

In a shared server architecture, the session memory for each client process is included inthe shared pool.

10

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