presales specialist oracle database 11g
DESCRIPTION
PreSales Specialist oracle database 11gTRANSCRIPT
-
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 Mark for Review
(1) Points
(Choose all correct answers)
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
-
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? Mark for Review
(1) Points
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? Mark for Review
(1) Points
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.
-
9. How do you identify a table for tracking with Total Recall? Mark for Review
(1) Points
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 Mark for Review
(1) Points
(Choose all correct answers)
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?
Mark for Review (1) Points
(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
-
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
(1) Points
(Choose all correct answers)
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? Mark for Review
(1) Points
REDO logs
UNDO data (*)
Flashback snapshots
System logs
-
Correct, UNDO data is the primary source for Total Recall.
18. Which of the following is not true of Total Recall? Mark for Review
(1) Points
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? Mark for Review
(1) Points
(Choose all correct answers)
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?
Mark for Review (1) Points
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 (*)
Correct, 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.
22. With Oracle Database 11g, you can make schema changes to an XML schema Mark for Review
(1) Points
(Choose all correct answers)
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 Mark for Review
(1) Points
(Choose all correct answers)
SF-API
FTP (*)
SQL (*)
WebDav (*)
Correct, you can access Secure Files through SQL, FTP or WebDav.
26.
Why would you want to
Mark for Review (1) Points
-
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? Mark for Review
(1) Points
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
(1) Points
(Choose all correct answers)
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 Mark for Review
(1) Points
(Choose all correct answers)
-
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
(1) Points
(Choose all correct answers)
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? Mark for Review
-
(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 Mark for Review
(1) Points
(Choose all correct answers)
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
Mark for Review (1) Points
(Choose all correct answers)
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
(1) Points
(Choose all correct answers)
Higher performance
Reduce storage (*)
Less memory usage
Lower maintenance (*)
Correct, 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.
38. What type of security is imposed on jobs in Oracle Scheduler? Mark for Review
(1) Points
(Choose all correct answers)
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
(1) Points
(Choose all correct answers)
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 Mark for Review
(1) Points
(Choose all correct answers)
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
Mark for Review (1) Points
Applications that use OCI (*)
Applications that use OLE DB
-
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? Mark for Review
(1) Points
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? Mark for Review
(1) Points
(Choose all correct answers)
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
-
scheduling jobs with Oracle Scheduler?
(Choose all correct answers)
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? Mark for Review
(1) Points
(Choose all correct answers)
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
(1) Points
(Choose all correct answers)
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? Mark for Review
(1) Points
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.
-
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.