OCP-052考试题库汇总(7)-CUUG内部解答版

简介:   Which is true about invalid PL/SQL objects?  A)They are automatically recompiled against the new definition of a referenced object when they are called.

  Which is true about invalid PL/SQL objects?

  A)They are automatically recompiled against the new definition of a referenced object when they are called.

  B)They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.

  C)They are automatically recompiled against the new definition of a referenced object at the same time as the referenced object is modified.

  D)They can be manually recompiled only by using SQL commands.

  Answer: A

  赵:

  A 译:它们在被调用时根据引用对象的新定义自动重新编译。

  B 译:如果在 PL/SQL 对象中引用的表上执行 DDL,则必须手动重新编译它们才能使用它们。

目录
相关文章
OCP-052考试题库汇总(59)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
2844 0
OCP-052考试题库汇总(55)-CUUG内部解答版
Examine these facts about a database: 1.USER is the database default tablespace. 2.USER1, USER2, and USER3 have the CREATE SESSION privilege.
3073 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(49)-CUUG内部解答版
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
993 0
|
SQL
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8272 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(45)-CUUG内部解答版
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file.
1877 0
|
数据安全/隐私保护 关系型数据库 Oracle
OCP-052考试题库汇总(35)-CUUG内部解答版
Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.
723 0
OCP-052考试题库汇总(34)-CUUG内部解答版
Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵: 题译:哪里有一个 Exdp 操作跟踪? Master table 是一个临时 table,专门为 import pump 和 export pump 创建的,一旦完成就会自动被 drop。
619 0
OCP-052考试题库汇总(24)-CUUG内部解答版
Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent Answer...
429 0
|
数据库
OCP-052考试题库汇总(22)-CUUG内部解答版
Which four are true about the Archive (ARCn) processes? A)They might be used during instance recovery.
584 0
OCP-052考试题库汇总(20)-CUUG内部解答版
Which two are true about LGWR? A)LGWR always writes to the redo logs each time a COMMIT occurs. B)LGWR always writes to the redo logs each time a ROLLBACK occurs.
4745 0