网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which dependent object will get invalidated even if it is not affected by the table edefinition？（）
A
packages
B
triggers
C
synonyms
D
views
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which dependent object will get invalidated even if it is not affected by the table edefinition？（）A packagesB triggersC synonymsD views” 相关考题
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
考题
View the Exhibit for the object interdependency diagram.How does this impact the status of the dependent objects?()
A. All dependent objects remain valid.B. Only the procedure and function become invalid and must be recompiled.C. Only the view becomes invalid and gets automatically revalidated the next time it is used.D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
考题
Whichdependentobjectwillgetinvalidatedevenifitisnotaffectedbythetableedefinition?()
A.packagesB.triggersC.synonymsD.views
考题
Which statement is true about import and export routing policies?()
A.Import policies concern routes received and determine which routes get put into the routing table.B.Export policies concern routes received and determine which routes get put into the routing table.C.Export policies are applied before the routing table.D.Import polices are applied after the routing table.
考题
When configuring an interface using SMIT and Further Configuration with an IP address and netmask， which of the following outcomes indicates how the routing tables will be affected？（）A、A subnet route is automatically addedB、A default route is automatically addedC、All other routes are automatically addedD、The routing table is not affected
考题
Which statement is true about import and export routing policies?（）A、Import policies concern routes received and determine which routes get put into the routing table.B、Export policies concern routes received and determine which routes get put into the routing table.C、Export policies are applied before the routing table.D、Import polices are applied after the routing table.
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)A、All the related indexes and views are automatically droppedB、The flashback drop feature can recover only the table structureC、Only the related indexes are dropped whereas views are invalidatedD、The flashback drop feature can recover both the table structure and its data
考题
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDER table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDER table are disabled.D、The dependent referential integrity constraints in the ORDER table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.
考题
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）A、Use a flashback query to retrieve the rows that were deletedB、Useconventialincremental export and then import the affected objectC、Shutdown the database inNORMALmode and restart the database instanceD、Use DBMS_META package to reconstruct the object using undo segmentsE、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataF、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.A、user tablesB、view segmentC、table segmentD、data dictionaryE、object segmentF、performance tables
考题
You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain
考题
Which two statements are true about simple views？（）A、Views can be created as read only.B、Views are data segments like tables.C、Views can be created on the basis of more than one table.D、Data manipulation language （DML） operations cannot be performed on views.
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data
考题
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDERS table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDERS table are disabled.D、The dependent referential integrity constraints in the ORDERS table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
Which dependent object will get invalidated even if it is not affected by the table edefinition？（）A、 packagesB、 triggersC、 synonymsD、 views
考题
Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A、 An SCN is never used to perform a Flashback Table recovery.B、 If a significant number of changes have been made to the table， row movement must be enabled.C、 The tablespace must be offline before performing a Flashback Table recovery.D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
考题
单选题Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A
An SCN is never used to perform a Flashback Table recovery.B
If a significant number of changes have been made to the table， row movement must be enabled.C
The tablespace must be offline before performing a Flashback Table recovery.D
Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
考题
多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
单选题Which dependent object will get invalidated even if it is not affected by the table edefinition？（）A
packagesB
triggersC
synonymsD
views
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDER table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDER table are disabled.DThe dependent referential integrity constraints in the ORDER table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.
考题
多选题For a given Servlet Response response， which retrieves an object for writing binary data？ （）Aresponse.get writer （）Bresponse.get Output Stream （）Cresponse.getOutput Writer（）Dresponse.get Writer （）.get Output Stream （）Eresponse.get Writer （Writer.OUTPUT_BINARY）
考题
多选题For a given Servlet Response response， which two retrieve an object for writing text data？ （）Aresponse.get Writer （）Bresponse.get Output Stream （）Cresponse.get Output Writer （）Dresponse.get Writer （）.get Output Stream（）Eresponse.get Writer （Writer.OUTPUT_TEXT）
考题
多选题Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.
考题
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
考题
单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）A
the DBNEWID utilityB
the ANALYZE commandC
the RMAN LIST commandD
the RMAN REPORT commandE
the RMAN CROSSCHECK commandF
the RMAN BLOCKRECOVER command
考题
单选题When configuring an interface using SMIT and Further Configuration with an IP address and netmask， which of the following outcomes indicates how the routing tables will be affected？（）A
A subnet route is automatically addedB
A default route is automatically addedC
All other routes are automatically addedD
The routing table is not affected
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题Which statement is true about import and export routing policies?（）A
Import policies concern routes received and determine which routes get put into the routing table.B
Export policies concern routes received and determine which routes get put into the routing table.C
Export policies are applied before the routing table.D
Import polices are applied after the routing table.
热门标签
最新试卷