网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题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.EAllows for version enabling tables by use of a packages procedure.” 相关考题
考题
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.
考题
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.
考题
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
考题
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
考题
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.
考题
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.
考题
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.
考题
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 onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
考题
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 DropB、 Flashback QueryC、 Flashback Transaction QueryD、 Flashback Versions QueryE、 Flashback Table
考题
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.
考题
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.
考题
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
考题
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.
考题
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.
考题
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.
考题
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A、 XIDB、 VERSIONS_PKC、 VERSIONS_XIDD、 VERSIONS_UNIQUE
考题
多选题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.EAllows for version enabling tables by use of a packages procedure.
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
考题
多选题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?ATwo of the four children may inherit the mutation.BTwo of the four children may have the disease.CTwo of the four children may end up disease free.
考题
单选题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.
考题
单选题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 DropB
Flashback QueryC
Flashback Transaction QueryD
Flashback Versions QueryE
Flashback Table
考题
多选题Which two statements are correct regarding the Flashback Versions Query feature？（）AYou can use this feature to identify the committed versions of the rows， but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.CYou 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.DYou can use this feature for a table only if row movement is enabled for the table.EYou can use this feature to identify the versions of external and fixed tables.
考题
单选题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.
考题
单选题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.
考题
单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A
XIDB
VERSIONS_PKC
VERSIONS_XIDD
VERSIONS_UNIQUE
热门标签
最新试卷
