网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
DDL和DML分别代表什么?
参考答案
更多 “DDL和DML分别代表什么?” 相关考题
考题
Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?()
A.GlobalindexesarerebuiltautomaticallyattheendoftheDDLoperationtherebyavoidingproblemswiththeUNUSABLEstatus.B.YoudonothavetosearchforinvalidglobalindexesaftertheDDLcommandcompletesandrebuildthemindividually.C.GlobalindexesaremaintainedduringtheoperationoftheDDLcommandandthereforecanbeusedbyanyconcurrentquery.D.Globalindexesremainintactandavailableforusebydatamanipulationlanguage(DML)statementsevenforsessionsthathavenotenabledtheskippingofunusableindexes.
考题
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.
考题
You need to ensure that database schema changes in branch offices result in the proper notifications. What should you do?()A、Install Notification Services on all branch office servers, and configure Notification Services to use a local notifications database.B、Specify that all SQL Server log files must be archived and sent by e-mail to the main office. C、Implement DML triggers that use Database Mail to send an e-mail message about the DML activity.D、Implement DDL triggers that use Database Mail to send an e-mail message about the DDL activity.
考题
You need to implement an auditing strategy that will fulfill the company’s business requirements.What should you do?()A、Use C2 auditing.B、Use DML triggers.C、Use DDL triggers.D、Use event notifications.
考题
多选题What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?()AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.BYou do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.CGlobal indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.DGlobal indexes remain intact and available for use by data manipulation language (DML) statements even for sessions that have not enabled the skipping of unusable indexes.
考题
多选题Which two client requests are captured during database replay Capture?()AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations
考题
单选题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.
热门标签
最新试卷