As a leading IT exam study material provider, CertBus not only provides you the 1Z0-040 exam questions and answers but also the most comprehensive knowledge of the whole 10g DBA 1Z0-040 Oracle database 10g:new features for adminsitrators certifications. We provide our users with the most accurate 1Z0-040 Oracle database 10g:new features for adminsitrators study material about the 10g DBA 1Z0-040 exam and the guarantee of pass. We assist you to get well prepared for 10g DBA 1Z0-040 certification which is regarded valuable the IT sector.

We CertBus has our own expert team. They selected and published the latest 1Z0-040 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-040.html

QUESTION NO:26

You want an ASM instance to manage the files of your database. To achieve this objective, you

specify the following parameters in the parameter file of the database.

INSTANCE_TYPE = RDBMS

LARGE_POOL_SIZE = 8MB

BD_BLOCK_SIZE = 4K

LOG_ARCHIVE_DEST = dgroupA

LOG_ARCHIVE_FORMAT = “$ORACLE_SID_%s_%t.%t”

DB_CREATE_FILE_DEST = dgroupA

COMPATIBLE = 10.1.0.2.0

CONTROL_FILES = dgroupA

Which parameter would be ignored while starting up the instance?

A. DB_BLOCK_SIZE

B. CONTROL_FILES

C. LARGE_POOL_SIZE

D. LOG_ARCHIVE_DEST

E. LOG_ARCHIVE_FORMAT

F. DB_CREATE_FILE_DEST

Answer: E

Explanation:

If you want ASM to be the default destination for creating database files, you must specify an

incomplete ASM filename in one or more of the following initialization parameters:

– DB_CREATE_FILE_DEST

– DB_CREATE_ONLINE_LOG_DEST_n

– DB_RECOVERY_FILE_DEST

-CONTROL_FILES

– LOG_ARCHIVE_DEST_n

– LOG_ARCHIVE_DEST

-STANDBY_ARCHIVE_DEST

Some additional initialization parameter considerations:

– LOG_ARCHIVE_FORMAT is ignored if a disk group is specified for

LOG_ARCHIVE_DEST (for example, LOG_ARCHIVE_DEST = dgroup1).

– DB_BLOCK_SIZE must be one of the standard block sizes (2K, 4K, 8K, 16K or 32K bytes).

– LARGE_POOL_SIZE must be set to at least 1 MB.

REF.: Oracle(r) 10g Administrator Guide, 12-39

QUESTION NO:24

You need to create a schedule that will run a job on the second Friday of each month. What

should the repeat interval of the schedule be set to?

A. FREQ= MONTHLY; BYDAY = 2FRI; B.

FREQ= MONTHLY; BYDAY = FRI2; C.

FREQ= MONTHLY; BYDAY = -2FRI; D.

FREQ= MONTHLY; BYDAY = FRI(2);

Answer: A

Explanation:

Examples of Calendaring Expressions The following examples illustrate simple repeat intervals.

For simplicity, it is assumed that there is no contribution to the evaluation results by the start date.

Run every Friday. (All three examples are equivalent.)

FREQ= DAILY; BYDAY = FRI;

FREQ= WEEKLY; BYDAY = FRI;

FREQ= YEARLY; BYDAY = FRI;

Run on the second Wednesday of each month.

FREQ= MONTHLY; BYDAY = 2WED;

REF.: Oracle(r) 10g Administrator Guide , 27-14

QUESTION NO:26

Which two initialization parameters would you set to enable Automatic Shared Memory Management?

(Choose two.)

A. set LOG_BUFFER to zero

B. set SHARED_POOL_SIZE to zero

C. set DB_CACHE_SIZE to a non-zero value

D. set STATISTICS_LEVEL to BASIC

E. set SGA_TARGET to a non-zero value

F. set STATISTICS_LEVEL to TYPICAL or ALL

Correct Answer: EF

QUESTION NO:110

Which command meets these two criteria? 1. Runs the backup at full speed. 2. Either f inishes the task in

the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the

allotted time.

A. RMANandgt; BACKUP AS COPY DURATION 3:00 MINIMIZE LOAD DATABASE;

B. RMANandgt; BACKUP AS COPY DURATION 3:00 MINIMIZE TIME DATABASE;

C. RMANandgt; BACKUP AS COPY DURATION 3:00 PARTIAL MINIMIZE LOAD DATABASE;

D. RMANandgt; BACKUP AS COPY DURATION 3:00 PARTIAL MINIMIZE TIME DATABASE;

Correct Answer: B

QUESTION NO:97

Which three statements regarding the column-level Virtual Database Policy (VPD) policy are true?

(Choose three. )

A. The column-level VPD policy can be applied only to tables.

B. The security policy is applied whenever the column is referenced in a query.

C. The column-level VPD policy can be applied to tables and views, but not to synonyms.

D. The security policy cannot be applied to data manipulation language (DML) statements.

E. The security policy is applied and statements are rewritten when they access security-relevant

columns.

Correct Answer: BCE

QUESTION NO:43

Which four policy rule categories are available in the Policy Framework? (Choose four.)

A. Objects

B. Storage

C. Security

D. Network

E. Configuration

Correct Answer: ABCE

QUESTION NO:118

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?

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.

Correct Answer: C

QUESTION NO:130

You want to retain the job entries for the last five days and purge all job entries from the job log that are

older than five days. Select the command that will enable you to do the job.

A. EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history =andgt; 5, which_log =andgt;\’JOB_LOG\’);

B. EXECUTE DBMS_SCHEDULER.PURGE_LOG();

C. EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history =andgt; 5, job_name =andgt; \’JOB_LOG\’);

D. EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history =andgt; 5, which_log =andgt;

\’WINDOW_LOG\’);

Correct Answer: A

QUESTION NO:66

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

A. Drop User

B. Privilege Grants

C. Tablespace Space Usage

D. Tablespace Reorganization

E. Resumable Session Suspended

F. Recovery Area Low On Free Space

G. SYSTEM Tablespace Size Increment

Correct Answer: CEF

QUESTION NO:54

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

(Choose two.)

A. views

B. fixed tables

C. heap tables

D. external tables

E. temporary tables

F. Index-Organized Tables (IOTs)

Correct Answer: CF

CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-040 exam successfully with our Oracle materials. CertBus Oracle database 10g:new features for adminsitrators exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle database 10g:new features for adminsitrators exam questions and answers are the most valid. CertBus exam Oracle database 10g:new features for adminsitrators exam dumps will help you to be the Oracle specialist, clear your 1Z0-040 exam and get the final success.

1Z0-040 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mb0hJN3dIdkIxTEU/view?usp=sharing

1Z0-040 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-040.html [100% Exam Pass Guaranteed]

Why select/choose CertBus?

Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.

Brand	Certbus	Testking	Pass4sure	Actualtests	Others
Price	$45.99	$124.99	$125.99	$189	$69.99-99.99
Up-to-Date Dumps
Free 365 Days Update
Real Questions
Printable PDF
Test Engine
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back
Secure Payment
Privacy Protection