QUESTION 81
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)

A.    A maximum of 3 GB can be allocated to shared pool.
B.    The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C.    A total of 14 GB memory will be allocated to the automatically tuned memory components.
D.    Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE.
E.    Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters.
F.    Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB.

Answer: BE

QUESTION 82
Which statement correctly describes the change tracking writer (CTWR) background process?

A.    It keeps track of changes in the background processes.
B.    It records the system change number (SCN) in the control file.
C.    It writes audit records for user changes to the change tracking file.
D.    It records any changes to the listened configuration in the listener.ora file.
E.    It records any changes to the database parameters in the change tracking file.
F.    It records the physical location of all the changes that are made to the database in the change tracking file.

Answer: F

QUESTION 83
You work as a database administrator at certkiller.com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? (Choose three.)

A.    CPU usage
B.    degree of parallelism
C.    number of open cursors
D.    number of sorts performed
E.    idle time for blocking sessions
F.    number of disk I/O operations performed
G.    number of memory I/O operations performed

Answer: ABE

QUESTION 84
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

A.    The EVENT parameter was not set.
B.    The SQL_TRACE parameter is set to FALSE.
C.    The Enterprise Manager Grid Control is not used.
D.    The STATISTICS_LEVEL parameter is set to BASIC.
E.    The TIMED_STATISTICS parameter is set to FALSE.

Answer: D

QUESTION 85
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:
RAMN>REPORT NEED BACKUP days 3; What would be the output of this command?

A.    a list of files that require a backup within three days
B.    a list of files that have not been backed up for three days
C.    a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D.    a list of files for which a backup has already been performed and may need a backup after three days

Answer: B

QUESTION 86
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m.onwards.
The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery:
RMAN> RUN {
2> SET UNIT SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESTLOGS;
7> };
With reference to this scenario, which statement is true?

A.    RMAN recovers up to log sequence 230, but not including 230.
B.    RMAN returns an error because the log sequence number mentioned in the command should be 229.
C.    RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D.    RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

Answer: A

QUESTION 87
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:
RMAN> RESTORE CONTROLFILE;
Which two operations do you need to perform after restoring the control file from backup? (Choose two.)

A.    shut down and restart the instance
B.    add new temp files to the temporary tablespaces after recovery
C.    perform a media recovery and open the database with the RESETLOGS option
D.    perform a media recovery and bring the database to NOARCHIVELOG mode

Answer: BC

QUESTION 88
While designing your database, you have created the EMPLOYEES table as an index-organized (IOT). You want to create a bitmap index on the JOD_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?

A.    A primary key must have been created.
B.    A mapping table must have been created.
C.    An overflow tablespace must have been specified.
D.    The PCTTHRESHOLD option must have been specified.

Answer: B

QUESTION 89
View the Exhibit.
One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m.You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?
Exhibit:

A.    You must recover all data files to the required system change number (SCN).
B.    You must recover all data files, except those that are offline, to the required SCN.
C.    You must recover all data files belonging to the USERS tablespace to the required SCN.
D.    You cannot recover all data files because segment space management is performed manually for the undo tablespace.

Answer: B

QUESTION 90
You work as a database administrator at certkiller.com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?

A.    mount the new disk group in the ASM instance
B.    restart the ASM instance and the production database instance
C.    register the new disk groups in the production database instance
D.    restart the ASM instance without restarting the production database instance
E.    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

Answer: A

Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost