Tuesday

Latest 1Z0-040 Dumps : Oracle Database 10g Dumps

Name of the exam-- Oracle Database 10g: New Features for Administrator

Total number of questions in latest 1zo-040 dumps is around 250, some new question added.

Dumps Download link given below

Some Question from Dumps:



QUESTION 1

You imposed a column-level Virtual Private Database (VPD) policy as follows:
BEGIN
DBMS_RLS.ADD_POLICY (object_schema=> 'scott',
object_name => 'employees',
policy_name => 'hr_policy',
function_schema => 'pol_hr',
policy_function => 'hrpol',
sec_relevant_clos => 'salary,commission_pct');
END;

Which statement regarding hr_policy is true?
A. The policy applies only to the INDEX statement and note to any other statements
B. The policy applies only to the SELECT statement and not to any other statements.
C. The policy applies to SELECT, INSERT, UPDATE, DELETE, and INDEX statements.
D. The policy applies to SELECT, INSERT, UPDATE and DELETE statements; it does not apply to INDEX statements.

Answer: D

Explanation:

DBMS_RLS.ADD_POLICY (
object_schema IN VARCHAR2 NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
function_schema IN VARCHAR2 NULL,
policy_function IN VARCHAR2,
statement_types IN VARCHAR2 NULL,
update_check IN BOOLEAN FALSE,
enable IN BOOLEAN TRUE,
static_policy IN BOOLEAN FALSE);
statement_types is the statement types to which the policy applies. It can be any combination of SELECT,INSERT, UPDATE, and DELETE. The default is to apply to all of these types.
The policy not applies on the INDEX statements.

QUESTION 2

You are using SQL Tuning Advisor (STA) to tune SQL workload in your database. Which four types of recommendations do you get from Automatic Tuning Optimizer (ATO) via the STA? (Choose four.)

A. recommendation to create indexes
B. recommendation to use stored outlines
C. recommendation to create a SQL profile
D. recommendation to gather relevant statistics
E. recommendation to denormalize the schema
F. recommendation to restructure SQL statements

Answer: ACDF

Explanation/Reference:

For the A answer see the point n°3.
For the C answer see the point n°2.
Oracle 10g allows the optimizer to run in tuning mode where it can gather additional information and make recommendations about how specific statements can be tuned further. This process may take several minutes for a single statement so it is intended to be used on high-load resource-intensive statements.

In tuning mode the optimizer performs the following analysis:

1. Statistics Analysis - The optimizer recommends the gathering of statistics on objects with missing or stale statistics. Additional statistics for these objects are stored in an SQL profile.

2. SQL Profiling - The optimizer may be able to improve performance by gathering additional statistics and altering session specific parameters such as the
OPTIMIZER_MODE. If such improvements are possible the information is stored in an SQL profile. If accepted this information can then used by the optimizer when running in normal mode. Unlike a stored outline which fixes the execution plan, an SQL profile may still be of benefit when the contents of the table alter drastically. Even so, it's sensible to update profiles periodically. The SQL profiling is not performed when the tuning optimizer is run in limited mode. The SQL profile doesn't recommend to create a SQL profile.

3. Access Path Analysis - The optimizer investigates the effect of new or modified indexes on the access path.It's index recommendations relate to a specific statement so where necessary it will also suggest the use of the SQL Access Advisor to check the impact of these indexes on a representative SQL workload.

4. SQL Structure Analysis - The optimizer suggests alternatives for SQL statements that contain structures that may impact on performance. The implementation of these suggestions requires human intervention to check their validity.
Access Path Analysis - The optimizer investigates the effect of new or modified indexes on the access path. It's index recommendations relate to a specific statement so where necessary it will also suggest the use of the SQL Access Advisor to check the impact of these indexes on a representative SQL workload. Not E: Denormalizing would not be useful.

QUESTION 3

You executed the following command:
RMAN> RECOVER COPY OF DATAFILE
'/U01/app/oracle/oradata/orcl/users01.dbf';

Which statement regarding the above command is correct?

A. The '/u01/app/oracle/ordata/orcl/users01.dbf' data file is recovered from the image copy.
B. The '/u01/app/oracle/ordata/orcl/users01.dbf' data file is recovered from the last incremental backup.
C. Image copies of the '/u01/app/oracle/ordata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
D. Image copies of the '/u01/app/oracle/ordata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.

Answer: C

Explanation/Reference:

In Oracle10g, you can now recover datafile copies by applying changed blocks from a change tracking file to the datafile image copy. This is an important feature as it will significantly speed up datafile recovery times. It is done in 2 stages:

1. Use an RMAN command to update the datafile image copy with changed blocks:
RMAN> recover copy of datafile <old_datafile_name>;
2. Apply any archived redo logs to fine-tune the datafile to the exact point-in-time or SCN.
REF.: Oracle(r) Database 10g : New Features for Oracle 8i DBAs, 18-19

QUESTION 4

You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE
'/ul/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ' ' ;

Which statement regarding the above command is correct?

A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.
E. It will throw an error with message 'specified group is not available'.
F. It will create a new group with a system-generated name and add the tablespace TEMP1 to it.

Answer: C

Explanation/Reference:

Note: The answer C is not exact, because the command not only "not add the tablespace TEMP1 to any group", but it will delete the TEMPORARY tablespace from the his group, if it exists.
Specify an empty string (' ') will remove tablespace from the tablespace_group_name tablespace group.

Latest 1Z0-040 Dumps DOWNLOAD LINK


No comments:

Post a Comment