This preview shows page 1. Sign up to view the full content.
Unformatted text preview: not be a temporarytablespace.
D.A newtablespacecan be a locally managedtablespace.
E.A newtablespacecan be a dictionary-managedtablespace.
F.A newtablespacecan use automatic segment space management.
Answer: B, D, E
Exhibit You work as a database administrator for Certkiller .com. While trying to access
Enterprise Manager Database Control by using a browser, you get an error. See
On further investigation, you find that the Oracle database 10g installation has just
finished and your colleague, Certkiller who installed the software, has not noted
down all the port numbers.
How do you determine the port number of the HTTP listener that is being used by
Enterprise Manager DatabaseConrol?
Actualtests.com - The Power of Knowing 1Z0-042
E.By using Operating Systemutlities
Which background process does Automatic Shared Memory Management use to
coordinate the sizing of memory components?
The Automatic Shared Memory Management feature uses a new background process
named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and
coordinates the sizing of the memory components. The SGA Memory Broker keeps track
of the sizes of the components and pending resize operations
REF.: Metalink Note:268197.1: New Background Processes In 10g
Consider the following scenario:
You have a directory, data, under the disk group tdgroup
A. You want to create an
alias for one of the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS '+tdgroupA/data/datafile.dbf'
Which task would be accomplished by the command?
A. The command drops the file +tdgroupA.231.45678
B. The command physically relocates the file to +tdgroupA/data and renames the file to
C. The command creates a copy of the +tdgroupA.231.45678 file an...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09