Real Application Testing SPA:1. What is the use of RAT? Or Benefit of RAT?A) The RAT Option enables you to perform real world testing of Oracle Database.2. How to implement RAT?A) By capturing production workloads and accessing the impact of System changes before production deployment, Oracle RAT minimizes the risk of instabilities associated with changes.3. What is the use of SPA?A) SPA provides the ability to identify and measure the impact of changes on individual SQL Statements.4. What are main components RAT? Or what are under RAT?A) SPA and DB Replay.5. SPA mainly used by ------------A) DBAs, QAs and Application Developers.6. SQL Performance Analyzer analyses performance differences.A) True.7. SPA Offers fine-grained performance analyses on particular Individual SQLA) True8. SPA integrated with(Ans: a and c)a) SQL Tuning adviser(STA)b) SQL Access Advisor(SAA)c) SQL Plan Management(SPM)d) SQL Developer9. Why SQL Tuning Advisor and SQL Plan Management integrated withA) To Tune Regressions.10. SQL Performance Analyzer (SPA) is used for.(Ans: a, d, e, f)a) Schema Changesb) Database Migrationc) Export Statisticsd) Statics Gatheringe) OS Changesf) Hardware Changes11. SPA is used for performance testing for the database parameter change.A) True12. Find the Order of the steps for SPA from the below.(Order: a,f,e,b,d,c,g)a) Captureb) Make Changesc) Compare Resultsd) Build After Changee) Before Changef) Transport the SQLg) Tune regression13. STS includes --------------------------A) SQL Text, Bind Variables, Execution Plans and Execution Statistics.14. How to capture SQL work load?A) Using STS(SQL Tuning Set)15. We can use Data pump for transporting from Production to Test?A) True16. DB Links to create connections from Production to test System.A). True17. SQL Performance Data. (Ans: 1 and 4)1. Execution Plans2. Table Data3. Index Data4. Execution Statistics5. Parameters Data18. What are the steps required to ensure that the new performance is acceptable.1. Before Change2. Make Changes3. Build After Changes4. Compare Results from 1 and 35. Tune regressed SQL.19. You have to detect the following in compare report.(Ans: 3,4 and 6)1) SQL Query2) Parameter Value3) Improvements4) Regressions5) DML Statements6) Unchanged20. What is the recommended Option to tune regressed statements?1) SQL Tuning Advisor21. Analyses results can be used for SQL Plan Management baseline.A) True22. How to access SPA?A) OEM and PL/SQL Package(DBMS_SQLPA)23. What is navigation of SPA in OEM?A) Software and Support tab24. What is the name of the package for performance analyzer execution?A) DBMS_SQLTUNE.CREATE_TUNING_TASK25. Database Upgrade testing from 1. Collect SQL workload from production(9i Database)2. Transport workload to test box(10g Version)(Note: make sure analysis report based on 9i)

DB Replay:1. Why use DB Replay?1. Hardware or Software changes/Upgrades2. To identify full impact of changes before going live3. Test with real world production workload.2. What is DB replay?A) Database Replay makes it possible to do realistic testing(OR) Re-create actual production database workload in the test environment.3. What are the high level steps for DB Replay.1. Capture the workload in Production2. Replay the captured workload in the Test box.3. Analyze the report4. Identify regressions if any before making changes to the production system.4. What is preprocessing the workload?A. The workload capture data is preprocessed and this activity is required for the replay of the captured workload.5. What are the steps required before replay?A. Restore the replay database on test system to match the capture databaseB. Make Changes(Ex. 11g upgrade)C. Copy the Preprocessed workload recording to the test system.6. What are the supported changes for DB Replay?A) Database upgrades, PatchesB) Schema , ParametersC) RAC Nodes, InterconnectD) OS platforms, OS upgradesE) CPU, MemoryF) Storage.7. What are Supported workloads?A) All SQLB) Full LOB FunctionalityC) Local TransactionsD) Logins and LogoffsE) Session SwitchingF) Limited PL/SQL RPCs8. What are the considerations for capture?A) Sufficient disk space for workload capture.B) SYSDBA Or SYSOPER Privileges C) Can filter workload9. How many ways are there to restore the database for replay?A) Physical Restore(RMan)B) Logical RestoreC) Flashback Technology.10. How much percentage Performance impact while doing CaptureA) 4.5%11. What is the memory overhead?A) 64 KB per session(10 Users)12. What are replay considerations?1. Preprocess capture workload2. Restore the database13. What is think time Option?1. THINK_TIME_SCALE is a parameter that adjusts the think time to modify the captured.14. How many types of workload replay filters1.) Inclusion Filter2.) Exclusion Filter15. What are the PL/SQL procedures available for workload replay filter under the package?(DBMS_WORKLOAD_REPLAY)1. Add Filter(To define Filter)2. CREATE_FILTER_SET(Setting Replay Filters)3. USE_FILTER_SET(Use the filter)16. What are the contents in DB Replay analysis?A) We can find data divergence, Error Divergence and Performance reports17. What kind of information under data divergence?A) No. of rows compared for each call18. What are contents for the Error Divergence?A) New Errors, Mutated Errors and Errors that have disappeared.19. What types of reports are what are the reports at the time of replay analysis.A) Capture and Replay reportB) ADDM Report(Recommendation Report)C) ASH Report for SKEW Analysis(Sessions Performance)D) AWR Report(Performance Report)20. What are the PL?SQL packages for DB Replay?1). DBMS_WORKLOAD_CAPTURE2). DBMS_WORKLOAD_REPLAY21. What is WRC?A) Workload Replay Client(WRC is a utility to calibrate Replay Clients)DATA Masking(Security):1. What are advanced data masking features1. Condition based masking2. Compound masking

2. What is Condition based Masking?A) It masks sensitive data in a given column with different mask formats, based on specified conditions.3. What is compound masking?A) It supports masking a set of related columns in a table as a group.