Oracleは世界の先頭に立つ情報管理ソフトウェアの開発企業です、その複雑なリレーショナルデータベース製品のため名声を聞きます、Oracleデータベース製品は財産のランキングの上で前1000軒の会社に採用されました。たくさん大規模のウェブサイトもOracleシステムを使用しました。Oracleのリレーショナルデータベースは世界が最初にSQL言語のデータベースを支持するのデータベースである。
1z0-146の問題集、みんなと分かち合います
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
4.Which two statements are true about SecureFile LOB options? (Choose two.)
A.The COMPRESSION HIGH option can be enabled only for CLOBs.
B.The COMPRESSION HIGH option can be enabled for all internal LOBs.
C.The DECRYPT option can be used to remove encryption only if the LOB column is empty.
D.The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain
data.
Answer:B D
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
9.Which two statements correctly describe the features of SecureFiles? (Choose two.)
A.Compression does not entail table or index compression and vice-versa.
B.Encryption stores the encryption keys for the LOB columns inside the database.
C.Encryption stores the encryption keys for the LOB columns outside the database.
D.Compression stores identical data occurring two or more times in the same LOB column as a single
copy for the table.
Answer:A C
http://www.killtest.jp/9iInternetApplicationDeveloper/1Z0-146.asp