网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two statements are true when row archival management is enabled?（）AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.BThe 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.CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.EThe 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.” 相关考题
考题
The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are correct?（）A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCNB. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
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.
考题
Which two statements are true about bandwidth guarantee？（）A、When congestion is present，the priority command doesn’t allow exceeding the allocated rateB、When congestion isn’t present，the priority command doesn’t allow exceeding the allocated rateC、When congestion is present，the priority command allows exceeding the allocated rateD、When congestion isn’t present，the priority command allows exceeding the allocated rate
考题
Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC
考题
When configuring more than one archival site, which statement is true?（）A、The system will first attempt the transfer using the URL configured lastB、The system will transfer the configuration to each archival siteC、The system will not transfer to a secondary site unless the previous site failsD、The system will transfer using secure copy protocl (SCP) before attempting FTP
考题
In Cisco Nexus 1000V deployments which two statements are true?（）A、Vmware provides the VNIC and driversB、Vmware provides the VNIC and Cisco provides the driversC、Cisco provides the switching and management of switchingD、Cisco provides the switching and Vmware provides the management of switching
考题
Which of the following statements are true？（） A、 The equals（） method determines if reference values refer to the same object.B、 The == operator determines if the contents and type of two separate objects match.C、 The equals（） method returns true only when the contents of two objects match.D、 The class File overrides equals（） to return true if the contents and type of two separate objects match.
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
考题
Identify two situations in which the block header grows in a data block. （）A、when row directories need more row entriesB、when there is row migration in the data blockC、when there is an increase in the PCTFREE value for the data blockD、when more transaction slots are required than are initially configured
考题
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
考题
Which two statements are true about record groups?（）A、They are stored in the database. B、They are stored in local Forms memory. C、The type is specified explicitly at design time. D、The type is implied by when and how it is created.
考题
Which two statements about Flashback Query are true？（）A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.
考题
多选题Which two statements about Flashback Query are true？（）AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transaction is overwritten.EThe database has to be opened with the resetlogs option after performing Flashback Query.
考题
单选题Evaluate the following statement： Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）A
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.B
They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.C
They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.D
The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
考题
多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.
考题
多选题Which two statements are true about the Oracle Enterprise Manager （OEM） ？（）AOEM can do management and monitoring across multiple WLS DomainsBOE is a unified solution for management and monitoring across entire architecture - Web Tier， App Tier DB TierCOEM is focused solely on Oracle solutions， cannot manage 3rd party productsDOEM includes tools to configure the operating system
考题
多选题Which two statements are true when when a Coherence cluster member is lost ？ （）ARemaining members recover by repartitioning the data across the remainig cluster members in parallel with normal request processingBSome latencies may be experienced due to higher priority of recoveryCIn flight operations may be lostDA system administrator must manually assist recovery of the lost data
考题
多选题Which two statements are TRUE regarding Coherence Indexes ？ （）Aindexes are maintained by cache entry ownesBan application should not suggest an index that another aplication had suggestedCindexes cannot be sortedDeach application using Coherence may suggest the same set of indexes when it starts
考题
多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
考题
多选题Which of the following statements are true？（）AThe equals（） method determines if reference values refer to the same object.BThe == operator determines if the contents and type of two separate objects match.CThe equals（） method returns true only when the contents of two objects match.DThe class File overrides equals（） to return true if the contents and type of two separate objects match.
考题
多选题Which two statements are true regarding an Automatic Storage Management （ASM） instance？（）AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
多选题Which two statements are true about record groups?（）AThey are stored in the database.BThey are stored in local Forms memory.CThe type is specified explicitly at design time.DThe type is implied by when and how it is created.
考题
多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried tableEThey can return a data type value different from the one that is referenced
考题
多选题Which two statements are true about L2TP tunnel switching?（）ARequires only one tunnel switching license.BRequires two licenses，one for inbound and one for outbound sessions.CEnabled automatically when the BSR is configured as an LAC and LNS.DAids in L2TP tunnel scaling
考题
多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
热门标签
最新试卷
