ITPub博客

107.Which components are needed for successful and most efficient recovery. A. The backup RB3 and the current online redo log filesB. the backup RB2 and the archived redo log files after the log sequence number 15622C. Backup R81 and the archived redo log hies after the log sequence numbe...

82.Identify the three predefined server-generated alerts. (Choose three.)A. Drop UserB. Tablespace Space UsageC. Resumable Session SuspendedD. Recovery Area Low On Free SpaceE. SYSTEM Tablespace Size IncrementAnswer: BCD参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/monitoring.h...

81.Evaluate the following command and its output:SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACELMTEMP                  250609664     &nbs...

80.Which two statements regarding a SQL profile are true? (Choose two.)A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command....

79.You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above command is correct?A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.B. The '/u01/app/oracle/oradata/orcl...

74.Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.Which two activities would you perform to mai...

73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)A. You are backing up to tape and your tape device performs its own compression.B. You are making image copies, and you have not enabled tablespace compressi...

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, 2Answer: C参考：http://docs.oracle.com/cd/E1...

54.Evaluate the following function code:CREATE FUNCTION get_dept_avg(dept_id NUMBER)RETURN NUMBERRESULT_CACHE RELIES_ON(EMPLOYEES)IS    avgsal NUMBER(6);BEGIN    SELECT AVG(SALARY)INTO avgsal      FROM EMPLOYEES     ...

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 the I/O cali...

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 absence of statist...

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 performance by ...

43.View the following SQL statements:Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');COMMIT;Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;You want to back o...

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. the execution f...

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 trips to ...

37.During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation? A. The installation terminates with an error.B. The installa...

551.Which command will result in a trace file being created with the create controlfile command contained in it? A. alter database backup controlfile;B. alter database backup controlfile to trace;C. alter database controlfile backup;D. alter database controlfile backup to '/ora01/orac...

465.NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:a. Default settingb. Client environment variablec. Explicit ALTER SESSION statementd. Inside SQL functione. Server initializatio...

372.Which command do you use to generate a report of database incarnations?A. list incarnation of databaseB. report incarnation of databaseC. list database incarnationD. database incarnation listE. report database incarnationAnswer: ARMAN> list incarnation of databa...

34.Examine the following RMAN command:BACKUP DATABASETAG TESTDBKEEP UNTIL 'SYSDATE+1'RESTORE POINT TESTDB06;Which two statements are true regarding the backup taken by using the above RMAN command?(Choose two.)A. Only data files and the control file are backed up.B. Archived redo logs are bac...