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