多选题Which two statements are correct regarding the Oracle Flashback Drop feature? ()ARecycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.BYou can flash back a dropped table provided row movement has been enabled on the table.CIf you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.DWhen you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.EWhen a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.FIf you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

多选题
Which two statements are correct regarding the Oracle Flashback Drop feature? ()
A

Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.

B

You can flash back a dropped table provided row movement has been enabled on the table.

C

If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.

D

When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.

E

When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.

F

If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.


参考解析

解析: 暂无解析

相关考题:

Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA.ⅠonlyB.Ⅱ onlyC.Ⅰ and ⅡD.none of the above

Which two statements are true regarding hot patching? () A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works only in a single database instance environment.

Identify three correct statements regarding Oracle E-Business Suite.() (Choose three.) A.It can run entirely on the Internet.B.A minimum of two modules needs to be implemented for an organization.C.It is engineered to work as an integrated system on a single IT infrastructure.D.It supports multi-directional flows of business information within an organization.

Which two statements are correct regarding MPLS LSP establishment methods?() (Choose two.) A. LDP uses Down Stream On Demand.B. RSVP uses Down Stream On Demand.C. LDP uses Down Stream Unsolicited.D. RSVP uses Down Stream Unsolicited.

Which two statements regarding JUNOS architecture are correct?() A.The Routing Engine handles all exception traffic.B.The Routing Engine synchronizes the route table with the PFEC.The Routing Engine is hot-pluggable.D.The Routing Engine controls the PFE

Choose the two correct statements regarding Oracle WebLogic Server()A、 a server instance can be associated with multiple machinesB、 a machine can be associated with multiple server instance C、 a server instance can be associated with only a single machine D、 a machine can be associated with only one server instance

Which two of these statements regarding RSTP are correct? ()A、RSTP cannot operate with PVST+.B、RSTP defines new port roles.C、RSTP defines no new port states.D、RSTP is a proprietary implementation of IEEE 802.1D STP.E、RSTP is compatible with the original IEEE 802.1D STP.

Which two statements regarding SNMP monitoring of a UCS system are correct?()A、SNMP v3 is supportedB、includes same MIBs as the Cisco Nexus7000C、does not provides MIBs downstream of the fabric interconnectD、includes same MIBs as the Cisco Nexus2000

Which two statements regarding JUNOS architecture are correct?()A、The Routing Engine handles all exception traffic.B、The Routing Engine synchronizes the route table with the PFEC、The Routing Engine is hot-pluggable.D、The Routing Engine controls the PFE

You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()A、mydb is a service name.B、test.us.oracle.com is a database name.C、1521 is the listener port number.D、mydb is a host name.E、test.us.oracle.com is a net service name.F、hr is a username.G、test.us.oracle.com is an instance name.

多选题Which two statements are true regarding hot patching?()AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all platforms.EIt works only in a single database instance environment.

多选题Which two statements are correct regarding MPLS LSP establishment methods?() (Choose two.)ALDP uses Down Stream On Demand.BRSVP uses Down Stream On Demand.CLDP uses Down Stream Unsolicited.DRSVP uses Down Stream Unsolicited.

多选题Which two statements regarding the Flashback Table feature are correct?()AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.

多选题Identify three correct statements regarding Oracle E-Business Suite.() (Choose three.)AIt can run entirely on the Internet.BA minimum of two modules needs to be implemented for an organization.CIt is engineered to work as an integrated system on a single IT infrastructure.DIt supports multi-directional flows of business information within an organization.

多选题Which two statements are correct regarding the default protocol preference values? ()ARIP is preferred over OSPF external routesBDirect, local and static routes have the same preference valueCOSPF's preference value is lower than BGPDOSPF has a single preference value for both internal and external routes

多选题Which two statements are correct regarding default protocol preference values?()ARIP is preferred over OSPF external routes.BDirect, local, and static routes have the same preference value.COSPF's preference value is lower than BGP.DOSPF has a single preference value for both internal and external routes.

多选题Which two statements regarding traceroute on JUNOS devices are correct?()ATraceroute transmits ICMP echo-request packets.BTraceroute transmits UDP packets.CTraceroute receives ICMP echo-reply packets.DTraceroute receives ICMP port-unreachable packets.

多选题Which two statements are true regarding ownership of shared entities? ()(Choose two.)ACustomers is owned by Oracle Human Resources whereas Locations is owned by Oracle Receivables.BItems is owned by Oracle Purchasing whereas Locations is owned by Oracle Receivables.CSales Force is owned by Oracle Order Management whereas Employees is owned by Oracle Human Resources.DSet of books is owned by Oracle General Ledger whereas Locations is owned by Oracle Human Resources.ESuppliers is owned by Oracle Purchasing whereas Units of Measure is owned by Oracle Inventory.

多选题Choose the two correct statements regarding Oracle WebLogic Server()Aa server instance can be associated with multiple machinesBa machine can be associated with multiple server instanceCa server instance can be associated with only a single machineDa machine can be associated with only one server instance

多选题You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.