052(三十）

146、

146.Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) 
backup and restore operations
A. Large Pool 
B. Redo Log Buffer 
C. Database Buffer Cache 
D. Program Global Area (PGA)

Answer: A

View Code

147、

147.You executed the following command to create a tablespace called SALES_DATA: 
SQL> CREATE TABLESPACE sales_data 
DATAFILE SIZE 100M 
SEGMENT SPACE MANAGEMENT AUTO; 
Which two statements are true about the SALES_DATA tablespace? (Choose two) 
A. The database automatically determines the extent-sizing policy for the tablespace. 
B. The segments are automatically shrunk when the contents are removed from them. 
C. The allocation of extents within the tablespace is managed through the dictionary tables. 
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks. 
E. The space utilization description of the data blocks in segments is managed through free lists.

Answer: AD

View Code

148、

148.In which of the scenario will the DBA perform recovery? (Choose all that apply.) 
A. The alert log file is corrupted 
B. A tablespace is accidentally dropped 
C. One of the redo log members is corrupted 
D. A database user terminates the session abnormally 
E. The hard disk on which the data files is stored is corrupted

Answer: BE

View Code

149、You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?
A. ORACLE_HOME/dbs 
B. ORACEL_HOME/rdbms 
C. /u01/app/oracle/admin/orcl/adump 
D. /u01/app/oracle/flash_recovery_area 
E. ORACLE_BASE/diag/rdbms/orcl/alert 
F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Answer: F

View Code

150、

150.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1. Shut down the instance. 
2. Execute the ALTER DATABASE ARCHIVELOG command. 
3. Start up the instance and mount the database. 
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 
5. Open the database. 
Which is the correct sequence of steps for accomplishing the task? 
A. 4, 1, 3, 2, 5 
B. 1, 3, 4, 5, 2 
C. 1, 3, 2, 5; 4 not required 
D. 4, 1, 5, 2; 3 not required  
E. 1, 3, 4, 5; 2 not required

Answer: C

View Code