1z0-040 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: New Features for Administrators", page: 5

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-040: Oracle Database 10g: New Features for Administrators

#41. 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?

Show comments for this question (1)
Add comments
Link to this question

#42. 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.)

Show comments for this question (1)
Add comments
Link to this question

#43. 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?

Show comments for this question (0)
Add comments
Link to this question

#44. 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 ‘/u1/data/temp1.dbf’ SIZE 10M 
 TABLESPACE GROUP ‘ ‘;

Which statement regarding the above command is correct?

Show comments for this question (0)
Add comments
Link to this question

#45. Which entity enables Oracle Data Pump to restart a stopped job?

Show comments for this question (1)
Add comments
Link to this question

#46. You need to transport tablespaces between platforms with different endians. Which two steps are required in addition to the regular steps needed for transporting tablespaces? (Choose two.)

Show comments for this question (1)
Add comments
Link to this question

#47. You used the following command to perform backup:
RMAN> BACKUP AS COPY DURATION 4:00 PARTIAL MINIMIZE LOAD DATABASE;
Which recommendation regarding the above command is true?

Show comments for this question (0)
Add comments
Link to this question

#48. Identify the three predefined server-generated alerts. (Choose three.)

Show comments for this question (1)
Add comments
Link to this question

#49. You modified the optimizer statistics of a table by using the DBMS_STATS.GATHER_TABLE_STATS procedure. You realized that the newly generated statistics have created suboptimal execution plans for that particular table. What would you do to revert to the previous set of statistics as soon as possible?

Show comments for this question (0)
Add comments
Link to this question

#50. On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

Show comments for this question (0)
Add comments
Link to this question

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [20]

gen. 0.079

Server date 05:57 02-12-2008

Oracle 1z0-040

Forum

Start online exam simulation

Master braindump

User braindumps