exam questions

Exam 1z0-060 All Questions

View all questions & answers for the 1z0-060 exam

Exam 1z0-060 topic 1 question 9 discussion

Actual exam question from Oracle's 1z0-060
Question #: 9
Topic #: 1
[All 1z0-060 Questions]

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 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
Show Suggested Answer Hide Answer
Suggested Answer: BCF 🗳️
* 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 userseither 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.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...