PreSales Specialist oracle database 11g

(1)

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Get Specialized! This 50-question assessment is the final step towards becoming an Oracle Database 11g PreSales Specialist. Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!

Database 11g PreSales

(Answer all questions in this section)

1. With SQL Performance Analyzer, you can

Mark for Review (1) Points (Choose all correct answers)

Capture production SQL workloads (*) Run SQL queries in a test environment (*)

Compare performance of SQL workloads between two environments (*) Suggest indexes and partitioning strategies to improve performance

Correct, with SQL Performance Analyzer, you can capture production SQL workloads, run SQL queries in a test environment and compare the performance of SQL workloads between two environments.

2. With SQL Developer, developers can

Mark for Review

(1) Points

Copy schemas Compare schemas Parse SQL trace files Model data

All answers are correct (*)

Correct, with SQL Developer, developers can copy and compare schemas, parse SQL trace files and model data.

3. You can view the output from a run of Health Monitor

Through the Advanced Diagnostic Repository command line interface (*) Through Enterprise Manager Support Workbench (*)

Through SQL*Plus (*) From command line prompts

Correct, you can view the output of a Health Monitor run through SQL*Plus, the Enterprise Manager Support Workbench or through the Advanced Diagnostic Repository command line interface.

4. Which of the following statements about PL/SQL compilation is true?

Mark for Review (1) Points

You should use compiled PL/SQL code while developing and debugging the code Compiling PL/SQL code provides the best improvement for code that includes a lot of SQL statements

(2)

Anonymous blocks of PL/SQL code benefit from compilation. You can perform mass recompilations of PL/SQL code. (*)

Correct, you can perform mass re-compilations of PL/SQL code. 5. Data Pump can compress which of the following in Oracle Database 11g?

Meta-data only Data only Log files

Meta-data and Data (*) Meta-data, Data and Log files

Correct, Data Pump can compress data and meta-data in Oracle Database 11g. 6. Why does columnar compression frequently result in greater data compression?

Because columnar compression requires less CPU, so it can be done more frequently

Because columns inherently take up less space than tables

Because columns typically have more repeating characters, meaning greater compression opportunities (*)

Because columnar compression applies across tables

Correct, columnar compression frequently results in greater data compression because columns typically have more repeating characters, meaning greater compression opportunities.

7. Which of the following is not true of the native PL/SQL compilation in Oracle 11g

Release 1? Mark for Review

(1) Points

You need to set one parameter to enable this compilation You need a C compiler to perform the compilation (*) Compilation is faster than C compilation

Tests have shown the compiled PL/SQL code is faster than C code in some benchmarks

Correct, you do not need any additional software to compile PL/SQL. 8. In Oracle 11g Release 2, you can use your Real Application Clusters more flexibly

through the use of Mark for Review

(1) Points Server pools (*) Infiniband Cache fusion ASM Multi-core CPUs

Correct, in Oracle Database 11g, you can use RAC more flexibly through the use of server pools.

(3)

9. How do you identify a table for tracking with Total Recall?

By creating it with the FLASHBACK ARCHIVE keyword

By setting FLASHBACK ARCHIVE on for the tablespace in which the table resides

By using an ALTER TABLE . . . FLASHBACK ARCHIVE statement (*) By setting FLASHBACK_ARCHIVE = TRUE in the initialization file

Correct, you identify a table for tracking with Total Recall by using an ALTER TABLE . . . FLASHBACK ARCHIVE statement.

10. In Oracle Database 11g Release 2, Recovery Manager (RMAN) is able to

Recover dropped tablespaces (*) Backup to Amazon Simple Storage (*)

Specify different compression levels for backups (*) Automatically adjust backup speeds

Correct, in Oracle Database 11g Release 2, Recovery Manager (RMAN) is able to recover dropped tablespaces, backup to Amazon Simple Storage and specify

differen compression levels for backups.

11. How can you create a database template?

(Choose all correct answers)

From an existing database for structure and data (*) From an existing template (*)

From an existing database for structure only (*) From external metadata

Correct, you can build a database template from an existing template or from an existing database, which can be limited to the structure of the existing database or the structure and the data.

12. Which of the following conditions are best for using the SQL Result Cache?

Mark for Review

(1) Points (Choose all correct answers)

Queries that are frequently repeated (*) Queries that use PL/SQL collection methods. Queries that take a long time to run (*) Queries that return a lot of data

Correct, queries that are frequently repeated and that take a long time to run are good candidates for

(4)

performance gains with SQL Result Cache. 13. True or false - With Oracle 11g, you can copy an ASM file to the file system.

Mark for Review

(1) Points True (*)

False

Correct, with Oracle 11g, you can copy an ASM file to the file system.

14. True or false - you can drop or modify a column in a table that is being

tracked for Total Recall Mark for Review

(1) Points True

False (*)

Incorrect, you cannot drop or modify a column that is being tracked by Total Recall.

15. Can you collect information about incidents from information in the Advanced

Diagnostic Repository? Mark for Review

Yes, by creating a package based on the incident ID (*) Yes, based on a time range (*)

Yes, with SQL reports

Yes, based on a problem ID (*)

Correct, you can collect information about incidents by creating a package based on the incident ID, based on a problem ID or based on a time range 16. True or false - the Result Cache can cache the results of PL/SQL functions.

Mark for Review

(1) Points

True (*) False

Correct, the Result Cache can cache the results of PL/SQL functions.

17. What is the primary source for data in the Flashback Data Archive?

REDO logs UNDO data (*) Flashback snapshots System logs

(5)

Correct, UNDO data is the primary source for Total Recall.

18. Which of the following is not true of Total Recall?

Leverages flashback technology Stores historical data in the database Protects historical data from changes Requires application changes to use (*)

Correct, Total Recall does not require application changes to use.

19. Can you run the Net Configuration Assistant in silent mode?

Mark for Review (1) Points True (*)

False

Correct, you can run the Net Configuration Assistant in silent mode.

20. Which of the following enhancements are in Oracle Database 11g Release 2?

Precompiler support for in-memory database (*) The introduction of Database Vault

OCI Client-side Result Cache (*) REF cursor pre-fetching (*)

Incorrect, Oracle Database 11g Release 2 includes Precompiler support for in-memory database, OCI Client-side Result Cache and REF cursor pre-fetching. 21. In which of the following scenarios would you use SQL Performance Analyzer?

Testing impact of database upgrade Testing impact of new indexes Testing impact of new statistics

Determining the effect on performance of changes in a new version before rolling them out to end users

All answers are correct (*)

(6)

Analyzer to test the impact of a database upgrade, to test the impact of new indexes, to test the impact of new statistics or to determine the performance effect of changes before rolling out a new version to end users.

22. With Oracle Database 11g, you can make schema changes to an XML

schema Mark for Review

If the new schema does not invalidate existing objects (*) With ALTER XML statements

By copying XML data to the new schema In place, without any data movement (*)

Correct, with Oracle Database 11g you can change XML schemas in place, without any data movement, if the new schema does not invalidate existing objects.

23. With columnar compression, where is the data decompressed?

Mark for Review

(1) Points

Client-side memory In the storage server SGA

PGA (*)

Correct, with columnar compression, the data is decompressed in the PGA.

24. True or false - in Oracle Database 11g, Release 1, you can specify that a

Data Defintion Language statement waits on any blocking locks. Mark for Review (1) Points True (*)

False

Correct, you can specify that a DDL statement waits on locks in Oracle Database 11g Release 1. 25. You can access SecureFiles through

SF-API FTP (*) SQL (*) WebDav (*)

Correct, you can access Secure Files through SQL, FTP or WebDav.

26. Why would you want to

(7)

use an invisible index?

To collect histogram statistics for the index

To allow the index to be updated properly, but not used for queries (*) To save space in the database

To provide better query performance

Correct, an invisible index is maintained by the database but not considered by the optimizer. 27. Which of the following is not true of the PL/SQL Hierarchical Profiler?

Accounts for the resources spent by each subprogram call Requires special source code to implement (*)

Displays time spent in sub program

Displays time spent in subprogram and descendant subprograms

Correct, the PL/SQL Hierarchical Profiler accounts for the resources spent by each subprogram call and displays time spent in the call and dependent calls. 28. Which of the following types of engineering are not possible with SQL Developer

Data Modeling? Mark for Review

(1) Points

One-to-many relational logical One-to-one logical-relational modeling One-to-one relational-logical

One-to-many logical-relational (*)

Correct, one-to-many logical-relational engineering is not possible with SQL Developer Data Modeling. 29. Which of the following statements are true about crossedition triggers?

Mark for Review

Forward crossedition triggers are issued by pre-upgrade editions (*) Reverse crossedition triggers are issued by pre-upgrade editions Forward crossedition triggers are issued by post-upgrade editions Reverse crossedition triggers are issued by post-upgrade editions (*) Forward and reverse crossedition triggers are issued by either edition

Correct, forward crossedition triggers are issued by pre-upgrade editions and reverse crossedition triggers are issued by post-upgrade editions.

30. Enterprise Manager Support Workbench can

(8)

Diagnose problems and suggest repairs without having to go to support Give you a detailed view of problems and incidents (*)

Manually run health checks to collect diagnostic data (*)

Collect and package all relevant diagnostic data relating to an incident (*)

Correct, Enterprise Manager can give you a detailed view of problems and incidents, collect and package all relevant diagnostic data relating to an incident or manually run health checks to collect diagnostic data. 31. True or false - In Oracle Database 11g, Release 2, ASM Cluster File System (ACFS) supports file system files.

Mark for Review

(1) Points

True (*) False

Correct, Oracle Database 11g, Release 2, ASM Cluster File System (ACFS) supports file system files. 32. True or false - the same SQL statement can have two different results stored

in the Result Cache? Mark for Review

(1) Points True (*)

False

Correct, an SQL statement that used bind variables could have multiple results based on the value of the bind variables.

33. Why would a developer want to take advantage of the OCI Result Cache?

Mark for Review

To avoid having to develop their own client caching mechanism (*) To eliminate round trips to the server (*)

To use a client cache that works transparently with RAC (*) To reduce memory requirements on clients.

Correct, a developer would use the OCI Client Cache to avoid having to develop their own caching code, to improve performance by eliminating round trips to the server, and to have a client cache that works with RAC.

34. What factors does Oracle Scheduler use to prioritize jobs?

(9)

(1) Points

Schedule of job Overall CPU load Job classes (*)

Resource requirements of job

Correct, Oracle Scheduler uses job classes to prioritize jobs.

35. Oracle Database 11g Release 2 includes

Maximum Availability Advisor (*) Segment Advisor

Compression Advisor (*) Block Size Advisor

Incorrect, Oracle Database 11g Release 2 includes Compression Advisor and Maximum Availability Advisor. 36. In Oracle Database 11g Release 2, Streams has been enhanced with

More compression options Faster transformations (*)

An API that allows external apps access (*) Reduced memory footprint

Correct, in Oracle Database 11g Release 2, Streams has been enhanced with faster transformations and an API that allows external apps access.

37. Reference partitioning has which of the following advantages over standard

partitioning? Mark for Review

Higher performance Reduce storage (*) Less memory usage Lower maintenance (*)

(10)

maintenance, since they are maintained with their parent partition, and less storage, since they do not require the presence of the partition key in the child. 38. What type of security is imposed on jobs in Oracle Scheduler?

Access to individual Scheduler objects (*) SYSDBA role

Database security (*) SYS role

Correct, job security is based on overall database security as well as access to individual Scheduler objects.

39. The Database File System

Mark for Review

Stores files in a separate tablespace

Uses Java procedures to implement functionality Uses SecureFiles to store files (*)

Allows file system calls to be passed to the Database File System (*)

Correct, the Database File System allows file system calls to be passed to the Database File System and uses Secure Files to store files.

40. Jobs in Oracle Scheduler can have

Time restrictions (*) Dependency restrictions (*)

Time and dependency restrictions (*) No restrictions

Correct, jobs in Oracle Scheduler can have time, depency or time and dependency restrictions. 41. The Basic version of the Oracle Instant Client can support

Applications that use OCI (*) Applications that use OLE DB

(11)

SQL*Plus

All answers are correct

Incorrect, the Basic version of Oracle Instant Client can support applications that use OCI.

42. True or false - In Oracle Database 11g Release 2, the in-memory database

works with Active Data Guard. Mark for Review

(1) Points True (*)

False

Correct, in Oracle Database 11g Release 2, the in-memory database works with Active Data Guard. 43. True or false - you have to load the output of the PL/SQL Hierarchical Profiler

into database tables to analyze it. Mark for Review

(1) Points True

False (*)

Correct, you do not have to load the output into database tables to analyze it; you can analyze from the command prompt.

44. Oracle Scheduler uses which Oracle technology to prioritize jobs?

The optimizer

Resource Manager (*) Security roles

The amount of memory in the SGA

Correct, Oracle Scheduler uses Resource Manager to prioritize jobs.

45. With Advanced Compression, when are blocks compressed?

When data is INSERTed When data is loaded (*)

In batch for INSERTs and UPDATEs (*) When data is UPDATEd

Correct, with Advanced Compression, blocks are compressed when data is loaded, or in batch when rows are INSERTed or UPDATEd.

46. Which of the following options can be used for

Mark for Review

(1) Points

(12)

scheduling jobs with Oracle Scheduler?

Time (*)

Outcome of other jobs (*) Events (*)

Size of target tables

Correct, the Oracle Scheduler can schedule jobs based on a time, the outcome of other jobs or a particular event.

47. Which of the following objects can have editions?

Tables Synonyms (*) PL/SQL units (*) Views (*)

Correct, synonyms, views and PL/SQL units can be editioned.

48. Which of these database(s) can SQL Developer Data Modeler both import

from and export to? Mark for Review

Oracle (*) SQL Server (*) DB2 (*) UDB (*) Teradata

Correct, SQL Developer Data Modeler both import from and export to Oracle, SQL Server, DB2 and UDB.

49. Which of the following cannot be run by Oracle Scheduler?

PL/SQL block OS script

PL/SQL or Java procedure Executable

They can all be jobs. (*)

Correct, you can run a PL/SQL block, PL/SQL or Java procedures, a script or executables.

(13)

50. Can Oracle be installed silently as part of an application installation?

Mark for Review (1) Points True (*)

False

Correct, Oracle can be installed silently, without requiring user intervention.