当前位置:1Z0-060题库

问题:

[多选] Which two statements are true when row archival management is enabled?()

A . The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
B . The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
C . The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D . The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
E . The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?() Page break before. 。 Page break after. 。 Page protect. 。 Keep with anchoring object.。 On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?() Only the ORD_CUSTOMER_IX1 index created.。 Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.。 Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.。 The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.。 Both the indexes are created and used by the optimizer for queries on the ORDERS table.。 Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.。 Which three SELECT statements displays 2000 in the format “$2,000.00”?() SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;。 SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;。 SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual。 Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance.  What would be your next step to improve performance? () Run the SQL Access Advisor.。 Run the Memory Advisor for the sga.。 Run the Memory Advisor for the pga.。 Run the Memory Advisor for the shared pool.。 Run the Memory Advisor for the buffer cache.。 纽曼的游戏特征的“三内说”认为,游戏的特征有() 内部控制。 内部真实。 内部自由。 内部灵活。 内部动机。 Which two statements are true when row archival management is enabled?()
参考答案:

  参考解析

本题暂无解析

在线 客服