Download - Teste Oracle Database Sales Q&A
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
1.
Online application upgrades allows Marcar para Revisão
(1) Pontos
Multiple editions of PL/SQL code operating on the same
data
Online upgrades in a production environment
Avoidance of downtime for application upgrades
All answers are correct (*)
Incorrect, online application upgrades allows multiple
editions of PL/SQL code operating on the same data, online
upgrades in a production environment and avoidance of
downtime for application upgrades.
2.
Which types of composite partitioning are supported by Oracle
11g? Marcar para Revisão
(1) Pontos
Range-list
List-range
List-list
All answers are correct (*)
List-hash
Correct, Oracle 11g supports range-list, list-range, list-list
and list-hash composite partitioning.
3.
Jobs in Oracle Scheduler can have Marcar para Revisão
(1) Pontos
Time restrictions
Time and dependency restrictions
Dependency restrictions
All answers are correct (*)
Incorrect, jobs in Oracle Scheduler can have time, depency
or time and dependency restrictions.
4.
True or false - the Result Cache can cache the results of PL/SQL
functions. Marcar para Revisão
(1) Pontos
Verdadeiro (*)
Falso
Correct, the Result Cache can cache the results of PL/SQL
functions.
5.
Can Oracle be installed silently as part of an application
installation? Marcar para Revisão
(1) Pontos
Verdadeiro (*)
Falso
Correct, Oracle can be installed silently, without requiring
user intervention.
Página 1 de 6
Parte inferior do formulário
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
6. By upgrading to Oracle Database 11g, you can save money Marcar para Revisão
(1) Pontos
Oracle 11g does not save anyone money
For your customers
For you
For you and your customers (*)
Correct, by upgrading to Oracle Database 11g you can
save money for both you and your customers.
7. Enterprise Manager Support Workbench can Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Collect and package all relevant diagnostic data relating to
an incident (*)
Manually run health checks to collect diagnostic data (*)
Give you a detailed view of problems and incidents (*)
Prescribe solutions based on the support environment
Incorrect, Enterprise Manager Support Workbench 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.
8. True or false - interval partitioning requires manual creation of
all partitions. Marcar para Revisão
(1) Pontos
Verdadeiro
Falso (*)
Correct, interval partitioning automatically creates
partitions at specified intervals.
9. Oracle Database 11g can deliver savings in which areas? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Server costs (*)
Storage costs (*)
Support costs (*)
License costs
Correct, Oracle Database 11g can deliver savings in server
costs, storage costs and support costs.
10.
Which of the following Oracle Database 11g features do not
contribute to enhanced security? Marcar para Revisão
(1) Pontos
Oracle Flashback Archive
Oracle Advanced Compression (*)
Oracle Audit Vault
Oracle Database Vault
Oracle Advanced Security Option
Incorrect, Oracle Advanced Compression does not
contribute to enhanced security.
Página 2 de 6
Parte inferior do formulário
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
11.
How can you create a database upgrades? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
From metadata in an external dump
From an existing database for structure only (*)
From an existing template (*)
From an existing database for structure and data (*)
Incorrect, 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.
In Oracle Database 11g Release 2, Active Data Guard can now
be used to Marcar para Revisão
(1) Pontos
Distribute parallel servers for a query
Implement Hardware Assisted Resilient Data (HARD)
protection
Repair bad blocks with good copies from standby server
(*)
Divide a partitioned table between the active and standby
servers
Incorrect, in Oracle Database 11g Release 2, Active Data
Guard can now be used to repair bad blocks with good
copies from standby server.
13.
Which of the following conditions are most suited for
performance gains by using the SQL Result Cache? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Queries that return a lot of data
Queries that are frequently repeated (*)
Queries that take a long time to run (*)
Queries that use hints
Inorrect, queries that are frequently repeated and that
take a long time to run are good candidates for
performance gains with SQL Result Cache.
14.
When is Oracle Database 10g R2 slated to go on Extended
Support? Marcar para Revisão
(1) Pontos
July, 2010 (*)
July, 2011
January, 2012
July, 2013
Never
Incorrect, Oracle Database 10g R2 slated to go on
Extended Support in July of 2010.
15.
Which of the following features of Oracle Database 11g
contribute to reduced storage costs? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
ASM (*)
Compression (*)
Parallel execution of queries
Exadata
Implementing an ILM strategy with partitioning (*)
Inorrect, ASM, compression and the implementation of an
ILM strategy all contribute to reduced storage costs with
Oracle Database 11g.
Página 3 de 6
Parte inferior do formulário
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
16.
Why would an ISV want to package Oracle as part of their
application? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
They want to ship a single product DVD with all required
software (*)
Their field engineers sometimes do not have detailed
knowledge of Oracle. (*)
They want each database to be exactly the same on
installation (*)
They want to save money.
Incorrect, an ISV might want a packaged install of the
Oracle database to ship a single product DVD with all
required software, to create identical databases for all
installations, or because their own field engineers do not
have a detailed knowledge of Oracle.
17.
How can Oracle Database 11g reduce perceived risk for your
customers? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
By making it easier to find new hires familiar with the
release (*)
By promoting that your solution is up to date (*)
By giving longer lead times for standard support (*)
By increasing your coolness factor
Incorrect, Oracle Database 11g reduce perceived risk for
your customers by making it easier to attract new hires,
by promoting your solution as up to date and by giving
longer lead times for standard support.
18.
Which of the following is not true of Total Recall? Marcar para Revisão
(1) Pontos
Leverages flashback technology
Stores historical data in the database
Protects historical data from changes
Requires application changes to use (*)
All answers are incorrect
Correct, Total Recall does not require application changes
to use.
19.
By using Oracle Scheduler, an administrator can Marcar para Revisão
(1) Pontos
Create jobs that can be run at different times
Create jobs that can operate on different objects
Create jobs that can be restarted
Create jobs that have a maximum run time
All answers are correct (*)
Correct, with Oracle Scheduler, you can create jobs that
can be run at different times, on different objects, can be
restarted and that are limited in the amount of run time
they can use.
20.
What factors does Oracle Scheduler use to prioritize jobs? Marcar para Revisão
(1) Pontos
Schedule of job
Job classes (*)
Ovreall CPU load
Resource requirements of job
Incorrect, Oracle Scheduler uses job classes to prioritize
jobs.
Página 4 de 6
Parte inferior do formulário
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
21.
Why would your customers be interested in upgrading to 11g? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
To lower risks (*)
To pay increased maintenance fees
To increase the value they get from your solutions (*)
To lower costs (*)
Incorrect, your customers would be interested in
upgrading to Oracle Database 11g to lower risks and costs
and to take advantage of increased value from your
solutions.
22.
In which of the following scenarios would you use SQL
Performance Analyzer? Marcar para Revisão
(1) Pontos
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 (*)
Incorrect, you would use SQL Performance 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.
23.
With Oracle Total Recall, you must track historical changes for
the entire database. Marcar para Revisão
(1) Pontos
Verdadeiro
Falso (*)
Incorrect, Total Recall can be assigned on specific tables.
24.
True or false - Oracle 11g supports cube-organized
materialized views with Oracle OLAP. Marcar para Revisão
(1) Pontos
Verdadeiro (*)
Falso
Correct, Oracle 11g supports cube-organized materialized
views with Oracle OLAP.
25.
When does Health Monitor in Enterprise Manager run? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Automatically after a critical incident (*)
Automatically every hour
With every database backup
According to a schedule you can set up with Enterprise
Manager
Manually (*)
Correct, Health Monitor runs automatically after a critical
incident or can be run manually.
Página 5 de 6
Parte inferior do formulário
Teste: Oracle Database 11g Sales Specialist Assessment
Avalie as respostas, o feedback e a pontuação das perguntas abaixo. Um asterisco (*) indica
resposta correta.
Parte superior do formulário
Get Specialized! This 30-question assessment is the final step towards becoming an Oracle
Database 11g Sales Specialist.
Be Recognized! Pass the test, score 80% or more, and get your OPN Specialist Certificate!
Database 11g Sales
(Responder a todas as perguntas desta seção)
26.
With Advanced Compression, when are blocks compressed? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
In batch for INSERTs and UPDATEs (*)
When data is loaded (*)
When data is UPDATEd
When data is INSERTed
Incorrect, with Advanced Compression, blocks are
compressed when data is loaded, or in batch when rows
are INSERTed or UPDATEd.
27.
Why does columnar compression frequently result in greater
data compression? Marcar para Revisão
(1) Pontos
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
All answers are incorrect
Correct, columnar compression frequently results in
greater data compression because columns typically have
more repeating characters, meaning greater compression
opportunities.
28.
An Automated Degree of Parallelism decides Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
The number of parallel server sets used for a statement
Whether to spin up more parallel servers
Whether a statement is executed in parallel (*)
The degree of parallelism for a statement (*)
Incorrect, an Automated Degree of Parallelism decides
whether a statement is executed in parallel and the
degree of parallelism for a statement.
29.
What does Sustaining Support include? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Tech support (*)
Upgrades (*)
Fixes
New upgrade scripts
Incorrect, Sustaining Support includes upgrades and tech
support.
30.
Compared to monolithic servers of equivalent power, a RAC
database is Marcar para Revisão
(1) Pontos
Less expensive than the monolithic server. (*)
More expensive than the monolithic server.
An equivalent expense to the monolithic server.
Correct, a RAC database is less expensive than a
monolithic server of the same power.
Página 6 de 6
Parte inferior do formulário
9.
What is the
best way to
leverage the
added
functionality
in Oracle
Database
11g?
Marcar para Revisão
(1) Pontos
All of the answers are correct.
To lower maintenance costs for your customer
To create additional value in your solutions (*)
To educate your customer on the benefits of the functionality
Incorrect, the additional functionality in
Oracle Database 11g is best used to create
additional value in your solutions.
Correct, Oracle Database 11g reduce
perceived risk for your customers by
making it easier to attract new hires, by
promoting your solution as up to date and
by giving longer lead times for standard
support.
12.
Reference partitioning has which of the following
advantages over standard partitioning? Marcar para Revisão
(1) Pontos
(Escolher todas as respostas corretas)
Reduce storage (*)
Higher performance
Lower maintenance (*)
Less memory usage
Incorrect, reference partitions require less
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.
28. What does
Sustaining Marcar para Revisão
(1) Pontos
Support
include?
(Escolher
todas as
respostas
corretas)
Fixes
Upgrades
(*)
New
upgrade
scripts
Tech
support (*)
Incorrect,
Sustaining
Support
includes
upgrades
and tech
support.