You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?

• A.Corrupted blocks, if any, are repaired.
• B.Checks are performed for physical corruptions.
• C.Checks are performed for logical corruptions.
• D.Checks are performed to confirm whether all database files exist in correct locations
• E.Backup sets containing both data files and archive logs are created.

Comment: *

Name: *

Email: *

Verification: *

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

• A.a General Purpose database template with default memory allocation
• B.a Data Warehouse database template, with the dedicated server mode option and AMM enabled
• C.a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
• D.a default database configuration

Comment: *

Name: *

Email: *

Verification: *

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

• A.Parallel compilation of only the stored PL/SQL code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel recompilation of any stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Sequential recompilation of Java code

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about extents?

• A.Blocks belonging to an extent can be spread across multiple data files.
• B.The blocks of a newly allocated extent, although free, may have been used before.
• C.Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
• D.Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Comment: *

Name: *

Email: *

Verification: *

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

• A.Optimizer statistics are collected automatically.
• B.Only timed operating system (OS) statistics and plan execution statistics are collected.
• C.Automatic Workload Repository (AWR) snapshots are not generated automatically.
• D.The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

Comment: *

Name: *

Email: *

Verification: *