QUESTION 11
Following are the parameters and their values set in your database instance:
SGA_TARGET=8GB
SGA_MAX_SIZE=10GB
DB_KEEP_CACHE_SIZE=1GB
You executed the following command to increase SGA_TARGET:
SQL> ALTER SYSTEM SET SGA_TARGET=9GB;
Which three memory components would grow by the command above? (Choose three.)
A. large pool
B. shared pool
C. multiple block size caches
D. keep pool of database buffer cache
E. default pool of database buffer cache
Answer: ABE
QUESTION 12
You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.
Which advisory component would you refer to, in order to determine that required size of the database buffer cache?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
Answer: A
QUESTION 13
View the Exhibit.
In your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk. What action would you take to minimize the waits?
Exhibit:
A. start the log writer slave processes
B. increase the number of redo log files
C. increase the size of the redo log buffer
D. place the redo log files on the different disks
E. increase the number of log writer processes
Answer: D
QUESTION 14
One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?
A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed
Answer: B
QUESTION 15
You have set some of the initialization parameters as:
DB_BLOCK_SIZE = 8KB
SGA_MAX_SIZE = 2GB
SGA_TARGET = 0
SHARED_POOL_SIZE = 120MB
DB_CACHE_SIZE = 896MB
STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110 MB
Which two statements are correct? (Choose two.)
A. You cannot set a value for the DB_8K_CACHE_SIZE parameter.
B. If you increase the size of the large pool to 120 MB, then the memory allocated to the shared pool will be reduced to 110 MB.
C. If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB, then memory cannot be taken from the shared pool, even if the shared pool has free space available.
D. If an application attempts to allocate more than 120 MB from the shared pool and free space is available in the buffer pool, then the free space from the buffer pool is allocated to the shared pool.
Answer: AC
QUESTION 16
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A. a list of all those files that have been deleted in the last two days
B. a list of all those files that have been recovered within the last two days
C. a list of all the expired backups and copies
D. a list of backups and copies that are outside the range covered by the current retention policy
Answer: D
QUESTION 17
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group
Answer: E
QUESTION 18
View the Exhibit.
You executed the following command to perform a backup of the USERS tablespace:
RMAN> BACKUP TABLESPACE USERS;
Which three types of files are backed up? (Choose three.)
Exhibit:
A. all the data files belonging to the USERS tablespace
B. password file
C. online redo log files
D. the current control file
E. archived redo log files
F. the current server parameter file
G. data files belonging to the USERS tablespace and all the default tablespaces
Answer: ADF
QUESTION 19
In which two conditions are resumable statements suspended? (Choose two.)
A. when a user exceeds the space quota
B. when a user session is terminated
C. when a table that is being accessed by the current transaction is not found
D. when a user manually suspends the statement
E. when the maximum extents of a segment is reached
Answer: AE
QUESTION 20
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID).
In which two sources would you find the DBID? (Choose two.)
A. the alert log file
B. the server parameter file
C. the formatted name of a control file autobackup
D. an RMAN session log file
E. the trace file
Answer: CD
Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost