READ Free Dumps For Oracle- 1z0-060
| Question ID 20760 | Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
|
| Option A | Reduced logical I/O
|
| Option B | Reduced virtual memory utilization
|
| Option C | Improved parallel Execution performance
|
| Option D | Improved Serial Execution performance
|
| Option E | Reduced physical I/O
Real 7
Oracle 1z0-060 Exam
|
| Option F | Reduced CPU utilization
|
| Correct Answer | B,C,F |
Explanation 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.
| Question ID 20761 | 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 disrupt ion to availability is required.
Which three statements are true about this requirement?
|
| Option A | The partitions can be moved online to new tablespaces.
|
| Option B | Global indexes must be rebuilt manually after moving the partitions.
|
| Option C | The partitions can be compressed in the same tablespaces.
|
| Option D | The partitions can be compressed in the new tablespaces.
|
| Option E | Local indexes must be rebuilt manually after moving the partitions.
Real 8
Oracle 1z0-060 Exam
|
| Correct Answer | 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. 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 UPDATE INDEXES when you move the table.