ITPub博客

（57）Which background process of a database instance, using Automatic Storage Management（ASM）,connects as a foreground process into the ASM instance?A. ASMBB. PMONC. RBALD. SMON答案：（A）

（56）You discover that your Recycle Bin contains two tables with the same name, MY_TABLE.You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;What will be the result of executing this statemen...

（55）Following is the list of locations in random order where oranfstab can be placed.1./etc/mtab2.$ORACLE_HOME/dbs/oranfstab3./etc/oranfstabWhat is the sequence in which Direct NFS will search the locations?A. 1,2,3B. 3,2,1C. 2,3,1D. 1,3,2答案：（C）解析：...

（54）Evaluate the following function code:CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHERELIES_ON (EMPLOYEES)ISavgsal NUMBER(6);BEGINSELECT AVG(SALARY) INTO avgsal FROM EMPL...

（53）You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.B. The ZLIB compression algorithm consumes more CPU resourc...

（52）You have the following requirements in relation to the detection of block corruption for your database instance:Check for logical self-consistency of data blocks when modified in memory.Checksums are calculated before and after the block change.Checks are performed for the lost writ...

（51）To control the execution of a server process when it is receiving bad packets from a potentially malicious client,you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:SQL>ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;What is the significan...

（50）Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group?A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks i...

（49）Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE,you should first attempt to clear the log file.B. If the lost redo log group is CURRENT,you must clear the log file.C. If the lost redo log group is ACTIVE,you must res...

（48）View the Exhibit to examine the error obtained during the I/O calibration process.There are no data files on raw devices.What is the reason for this error?A. The DISK_ASYNCH_IO parameter is set to TRUE.B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.C. Another session runs th...

（47）You issue the following command on the RMAN prompt.REPORT NEED BACKUP DAYS 5;Which statement is true about executing this command?A. It will display a list of files that need incremental backupB. It will display a list of files that need backup after five daysC. It will disp...

（46）What happens when you run the SQL Tuning Advisor with limited scope?A. Access path analysis is not performed for SQL statements.B. SQL structure analysis is not performed for SQL statements.C. SQL Profile recommendations are not generated for SQL statements.D. Staleness and abse...

（45）What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?A. It improves resync operations.B. This feature enables much faster file opens.C. It improves performance as fewer extent pointers are needed in the shared pool.D. It improves p...

（44）You have a very large table that your users access frequently.Which of the following advisors will recommend any indexes to improve the performance of queries against this table?A. The Automatic Memory Manager(AMM)B. The SQL Tuning AdvisorC. The Segment AdvisorD. The SQL Acc...

（43）View the following SQL statements:--Transaction T1INSERT INTO hr.regions VALUES(5, 'Pole');COMMIT;--Transaction T2UPDATE hr.regions SET region_name = 'Poles' WHERE region_id = 5;COMMIT;...

（42）You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.What information is captured as part of this process?(Choose all that apply.)A. the SQL textB. the execution planC. the execution contextD. ...

（41）You have applications that have frequently executed queries,and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.What is the purpose of this configuration?A. to avoid round...

（40）Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255);SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN  :sql_stmt := 'SELECT COUNT(*) FROM customers WHERE cust_state_province=''CA'''; &...

（39）View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?A. Accept the recommended SQL profile.B. Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement....

（38）The SQL Tuning Advisor configuration has default settings in your database instance.Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?A. statistics recommendationsB. SQL Profile recommendationsC. Index...