Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-060

Free Oracle 1Z0-060 Exam Questions (page: 4)

Page 4 of 55
PDF with 216 Questions

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

  1. Reduced logical I/O
  2. Reduced virtual memory utilization
  3. Improved parallel Execution performance
  4. Improved Serial Execution performance
  5. Reduced physical I/O
  6. Reduced CPU utilization

Answer(s): B,C,F

Explanation:

* Multiprocess and Multithreaded Oracle Database Systems
Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users—either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage 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 the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.

* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.



In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your 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 of transactions access it at night and during weekends.

Minimal disruption to availability is required.

Which three statements are true about this requirement? (Choose three.)

  1. The partitions can be moved online to new tablespaces.
  2. Global indexes must be rebuilt manually after moving the partitions.
  3. The partitions can be compressed in the same tablespaces.
  4. The partitions can be compressed in the new tablespaces.
  5. Local indexes must be rebuilt manually after moving the partitions.

Answer(s): A,C,D

Explanation:

A: You can create and rebuild indexes online. Therefore, you can update base 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 the same tablespace.

Incorrect Answers:
B, E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.


Reference:

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



Which three are true about the large pool for an Oracle database instance that supports shared server connections?

  1. Allocates memory for RMAN backup and restore operations
  2. Allocates memory for shared and private SQL areas
  3. Contains a cursor area for storing runtime information about cursors
  4. Contains stack space
  5. Contains a hash area performing hash joins of tables

Answer(s): 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 (used where 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 restore operations, I/O server processes, and session memory for the shared server and Oracle XA.

* Oracle XA
An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.

* UGA
User global area. Session memory that stores session variables, such as logon information, 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 Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the 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 in the shared pool.

* 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 and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.



What are three purposes of the RMAN “FROM SERVICE” clause? (Choose three.)

  1. to support PUSH-based active database duplication
  2. to support synchronization of a standby database with the primary database in a Data Guard environment
  3. to support active database duplication by taking image copies of the source database
  4. to support file restoration over the network in a Data Guard environment
  5. to support file recovery over the network in a Data Guard environment

Answer(s): B,D,E

Explanation:

* With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.
* RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about 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 are created.



Viewing page 4 of 55



Post your Comments and Discuss Oracle 1Z0-060 exam prep with other Community members:

1Z0-060 Exam Discussions & Posts