分類: Oracle

Oracle 1Z0-042 考題5.20發生更新

Killtest題庫網1Z0-042考題發生更新，考題由原來的136題變為148題，考試版本為V9.02。
Killtest 題庫網保證你一次性通過1Z0-042考試，否則全額退款。
我們還免費提供1Z0-042的DEMO下載：PDF 電子檔案DEMO版本

部份1Z0-042考題如下：
1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)
A. average row size
B. last analyzed date
C. size of table in bytes
D. size of table in database blocks
E. number of free blocks in the free list
F. number of extents present in the table
Answer: ABD
2. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and uncommitted data.
Answer: AD
3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of yourdatabase. Which type of script does the backup scheduler generate?
A. SQL script
B. PL/SQL script
C. Operating System (OS) script
D. Enterprise Manager (EM) script
E. Recovery Manager (RMAN) script
Answer: E

oracle批量插入測試數據的方法

oracle怎樣批量插入測試數據
        壹、Test Windos方式

　　declare

　　maxrecords constant int:=100000;

　　i int :=1;

　　begin

　　for i in 1..maxrecords loop

　　insert into test2

　　(id, name)

　　values

　　(test2_seq.nextval, to_char(9999+i));

　　end loop;

　　dbms_output.put_line(’ 成功錄入數據!’);

　　commit;

　　end;

　　二、從已有表中往入另壹張表導數據

　　create or replace procedure TestProc is

　　begin

　　for c in(select id, name from test2) loop

　　insert into test

　　(id,

　　name)

　　values

　　(test_seq.nextval, c.name);

　　end loop;

　　end TestProc;

The introduction about newest 1z0-146 Dump

Oracle-1z0-146-dumpOracle is the one of Ten International Certifications. The Data Deal maybe the main tend of Oracle Certification Systems. The link about SUN and Oracle Certification is the strongest on the IT Certification Systems. 1Z0-146 exam is one of oracle exam codes. As follows is some of  the newest  Oracle 1z0-146 Q&A by Killtest dump website, wish useful for your Oracle 1z0-146 exam.

1.Which two types of metadata can be retrieved by using the various procedures in the
DBMS_METADATA PL/SQL package? (Choose two.)
A.report of invalidated objects in a schema
B.report of statistics of an object in the database
C.DDL for all object grants on a table in the database
D.data definition language (DDL) for all objects in a schema
Answer:C D
2.The database instance was recently started up. Examine the following parameter settings for the
database instance: NAME TYPE VALUE —————————————————————————………
result_cache_max_result integer 5 result_cache_max_size big integer 0 result_cache_mode string
MANUAL result_cache_remote_expiration integer 0 ……… You reset the value for the
result_cache_max_size parameter by issuing the following command: SQL> ALTER SYSTEM SET
result_cache_max_size = 1056k SCOPE = BOTH; System altered. Which statement is true in this
scenario?
A.1056 KB is allocated for the result cache and the result cache is enabled.
B.1056 KB is allocated for the result cache, but the result cache is disabled.
C.The results for only the queries that have the RESULT_CACHE hint are cached.
D.The results for all the queries except those having the NO_RESULT_CACHE hint are cached.
Answer:B 
7.Which statement describes the purpose of the plshprof command?
A.It produces HTML output from raw profiler output.
B.It produces HTML output from profiler tables in the database.
C.It populates profiler tables in the database from raw profiler output.
D.It produces raw profiler output on the most recently run applications.
Answer:A