ITPub博客

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

33.You want to perform the following operations for the DATA ASM disk group:-Verify the consistency of the disk.-Cross-check all the file extent maps and allocation tables for consistency. heck whether the alias metadata directory and file directory are linked correctly.-Check that ASM metadata d...

32.In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals Set the control file autobackup to "on"-Are maintaining image copies of the database filesYou have lost the server parameter tile (SPFILE) and the co...

28.You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default...

27.You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database.After regular monitoring of space usage in the flash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. ...

26.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242,...

708. You executed the following query:select oldest_flashback_scn, oldest_flashback_time from v$flashback_database_log;Considering that all the redo logs are available, what information can you derive from the output of the preceding query?A.The time when the last flashback operation in your data...

704. View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.What could be the reason?A.The first two updated were not explicitly committed.B.ALTER TABLE ca...

703. Given below are RMAN commands to enable ba ckup optimization and set the retention policy:The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday.View the Exhibit to examine the operations performed by using RMAN. Which two statements are true about th...

702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE).When you tried to start the database instance, you received the following error:Why did the instance fail to start?A.Because the PGA_AGGREGATE_TARGET parameter is not setB.Because the STATISTIC...

700. Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)A.It is a copy or a subset of the target database.B.It is opened in RESTRICT mode after a duplicating operation.C.It is created by using backups and archived redo log...