Oracle Specialist Assessment Paper

Test: Oracle Database 11g PreSales Specialist Assessment

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

- If the new schema does not invalidate existing objects
- in place, without any data movement

With Advanced Diagnostic Repository
- All log files are stored in the same file structure
- Log files use an XML format

Can Oracle be installed silently as part of an application installation?
- True

Which of the following objects have editions?
- Pl/Sql objects, views en synonyms

Which of the following statements are true about crossedition triggers?
- Antwoord niet bekend

Which of the following options can be used for scheduling jobs with Oracle Scheduler?
- Time, Outcome of other jobs, Events

In which of the following scenarios would you use SQl Performance Analyzer?
- All answers are correct

What factors does Oracle Scheduler use to prioritize jobs?
- Job classes

What type of security is imposed on jobs in Oracle Scheduler?
- Database security
- access to individual objects

In Oracle Database 11g release 2, streams have been enhanced with
- faster transformations
- an API that uses external apps access

Which of the following types of engineering are not possible with Sql Developer Data Modeling?
- One to many logical-relational

True or false - internal partitioning requires manual creation of all partitions
- False

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

What is the primary source for data in the Flashback Data Archive?
- UNDO data

Which of the following types of modeling are possible with SQL developer data modeler?
- Multi-dimensional, Physical, and relational

- True or false: Oracle 11g supports cube-organized materialized views with Oralce OLAP
- True

With Oracle 11g Release 2, you can now audit performance
- Either Online