多选题Which four are true regarding the Workspace Manager in Oracle9i？ （）AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllo

题目
多选题
Which four are true regarding the Workspace Manager in Oracle9i？ （）
A

Automatically versions all tables.

B

Automatically installed with Oracle9i.

C

Merges changes with parent rows or discard changes.

D

Provides mechanism to identify and resolve conflicts.

E

Allows for version enabling tables by use of a packages procedure.

相似考题

1.Evaluate the following command:Which statement is true regarding the above command?()A. The LOB matically compressed.B. The LOB values are cached bvalues are autoy default in the buffer cache.C. The LOB values are automatically stored in encrypted mode.D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

2.Refer to the exhibit. Which two statement s are correct?()A. All the routes were redistributed into BGP from an IGPB. All the routes were originated by BGP with the network commandC. All six routes will be installed in the routing tableD. Four routes will be installed in the routing ta bleE. Two routes will be installed in the routing table

3.Which of the following is true regarding Label Distribution Protocol （LDP）？（）A、It is a label distribution protocol for MPLSB、It is a set of procedures and messages by which LSRs establish Label Switch Paths （LSPs） through a networkC、Tag distribution Protocol （TDP） was the basis for LDPD、All of the above are true

4.When making changes to a server, which of the following is the BEST way to troubleshoot a problem?()A. Perform root cause analysis and then test the theory to determine the cause.B. Make changes to the system and document everything once the problem is resolved.C. Make multiple changes to all affected areas to resolve all potential issues.D. Make a change and if the problem is not resolved, reverse the change.

更多“多选题Which four are true regarding the Workspace Manager in Oracle9i？ （）AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllo”相关问题

  • 第1题：

    Which of the following statements best describes Flashback Versions Query？（）  

    • A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
    • B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
    • C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
    • D、 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

    正确答案:D

  • 第2题：

    When making changes to a server， which of the following is the BEST way to troubleshoot a problem？（）

    • A、 Perform root cause analysis and then test the theory to determine the cause.
    • B、 Make changes to the system and document everything once the problem is resolved.
    • C、 Make multiple changes to all affected areas to resolve all potential issues.
    • D、 Make a change and if the problem is not resolved， reverse the change.

    正确答案:D

  • 第3题：

    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）

    • A、 Flashback Drop
    • B、 Flashback Query
    • C、 Flashback Transaction Query
    • D、 Flashback Versions Query
    • E、 Flashback Table

    正确答案:C

  • 第4题：

    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

    • A、 The audit trail is stored in an operating system file.
    • B、 Auditing is disabled for all privileges.
    • C、 The audit trail is stored in the database.
    • D、 Auditing is enabled for all privileges.
    • E、 Auditing is enabled for certain privileges related to database security.

    正确答案:C,E

  • 第5题：

    Which statement is true regarding the creation of nested plans using Resource Manager？（）

    • A、 Only one nested subplan is allowed.
    • B、 The plans can be nested up to four levels.
    • C、 Resource Manager does not support nested plans.
    • D、 Nested plans control only the degree of parallelism but not the CPU.
    • E、 Each nested plan gets a proportion of the CPU resources assigned to its parent group.

    正确答案:E

  • 第6题：

    Which four are true regarding the Workspace Manager in Oracle9i？ （）

    • A、Automatically versions all tables.
    • B、Automatically installed with Oracle9i.
    • C、Merges changes with parent rows or discard changes.
    • D、Provides mechanism to identify and resolve conflicts.
    • E、Allows for version enabling tables by use of a packages procedure.

    正确答案:B,C,D,E

  • 第7题：

    多选题
    Which four are true regarding the Workspace Manager in Oracle9i？ （）
    A

    Automatically versions all tables.

    B

    Automatically installed with Oracle9i.

    C

    Merges changes with parent rows or discard changes.

    D

    Provides mechanism to identify and resolve conflicts.

    E

    Allows for version enabling tables by use of a packages procedure.


    正确答案： D,C
    解析： 暂无解析

  • 第8题：

    单选题
    Which of the following statements best describes Flashback Versions Query？（）
    A

     Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

    B

     Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.

    C

     Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

    D

     Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
    A

    The audit trail is stored in an operating system file.

    B

    Auditing is disabled for all privileges.

    C

    The audit trail is stored in the database.

    D

    Auditing is enabled for all privileges.

    E

    Auditing is enabled for certain privileges related to database security.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are correct regarding the Flashback Versions Query feature？（）
    A

    You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.

    B

    You can use this feature to identify the versions of V$ views.

    C

    You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.

    D

    You can use this feature for a table only if row movement is enabled for the table.

    E

    You can use this feature to identify the versions of external and fixed tables.


    正确答案： A,C
    解析： 暂无解析

  • 第12题：

    单选题
    Evaluate the following command: Which statement is true regarding the above command?（）
    A

    The LOB matically compressed.

    B

    The LOB values are cached bvalues are autoy default in the buffer cache.

    C

    The LOB values are automatically stored in encrypted mode.

    D

    All LOB data that is identical in two or more rows in a LOB column share the same data blocks.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  

    • A、 The VERSIONS BETWEEN clause may be used in DML statements.
    • B、 The VERSIONS BETWEEN clause may be used in DDL statements.
    • C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
    • D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

    正确答案:C

  • 第14题：

    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）

    • A、RMAN only
    • B、Flashback Table only
    • C、Flashback Versions Query only
    • D、Flashback Database and Flashback Transaction Query
    • E、Flashback Versions Query and Flashback Transaction Query

    正确答案:E

  • 第15题：

    Which two statements are correct regarding the Flashback Versions Query feature？（）

    • A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
    • B、 You can use this feature to identify the versions of V$ views.
    • C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
    • D、 You can use this feature for a table only if row movement is enabled for the table.
    • E、 You can use this feature to identify the versions of external and fixed tables.

    正确答案:A,C

  • 第16题：

    Which statement is true regarding the COALESCE function?（）

    • A、It can have a maximum of five expressions in a list 
    • B、It returns the highest NOT NULL value in the list for all rows 
    • C、It requires that all expressions in the list must be of the same data type 
    • D、It requires that at least one of the expressions in the list must have a NOT NULL value

    正确答案:C

  • 第17题：

    Which statement is true regarding Flashback Version Query？ （）

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第18题：

    Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）

    • A、 XID
    • B、 VERSIONS_PK
    • C、 VERSIONS_XID
    • D、 VERSIONS_UNIQUE

    正确答案:C

  • 第19题：

    单选题
    Which statement is true regarding Flashback Version Query？（）
    A

     It returns versions of rows only within a transaction.

    B

     It can be used in subqueries contained only in a SELECT statement.

    C

     It will return an error if the undo retention time is less than the lower bound time or SCN specified.

    D

     It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement is true regarding the COALESCE function?（）
    A

    It can have a maximum of five expressions in a list 

    B

    It returns the highest NOT NULL value in the list for all rows 

    C

    It requires that all expressions in the list must be of the same data type 

    D

    It requires that at least one of the expressions in the list must have a NOT NULL value


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    Consider each of the choices separately and select all that apply.　 If a father of four children carries the Huntington’s mutation, which of these is true?
    A

    Two of the four children may inherit the mutation.

    B

    Two of the four children may have the disease.

    C

    Two of the four children may end up disease free.


    正确答案： A,C
    解析：
    根据“If one parent carries the mutation, each offspring has a 50-50 chance of inheriting the mutated gene”可知，本题选A、B、C三项。

  • 第22题：

    单选题
    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）
    A

     Flashback Drop

    B

     Flashback Query

    C

     Flashback Transaction Query

    D

     Flashback Versions Query

    E

     Flashback Table


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Which statement is true regarding the creation of nested plans using Resource Manager？（）
    A

     Only one nested subplan is allowed.

    B

     The plans can be nested up to four levels.

    C

     Resource Manager does not support nested plans.

    D

     Nested plans control only the degree of parallelism but not the CPU.

    E

     Each nested plan gets a proportion of the CPU resources assigned to its parent group.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）
    A

     XID

    B

     VERSIONS_PK

    C

     VERSIONS_XID

    D

     VERSIONS_UNIQUE


    正确答案： C
    解析： 暂无解析

相关内容