网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）
A
The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
B
The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
C
The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
D
The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
参考答案
参考解析
解析：
暂无解析
更多 “单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）A The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.” 相关考题
考题
On a precedence diagram, the arrow between two boxes is called:A.An activity.B.A constraint.C.An event.D.The critical path.E.None of above.
考题
128 On a precedence diagram, the arrow between two boxes is called:A. An activity.B. A constraint. C. An event.D. The critical path.E. None of above
考题
Priming of the tides occurs ______.A.at times of new and full MoonB.when the Earth, Moon, and Sun are lying approximately on the same lineC.when the Moon is between first quarter and full and between third quarter and newD.when the Moon is between new and first quarter and between full and third quarter
考题
When configuring resource access policies in a Junos Pulse Access Control Service device, which entry is permitted when defining the specific resources?()
A. HostnameB. fully qualified domain nameC. IP addressD. address book entry
考题
设在SQL Server 2008某数据库中有表SC（Sn0，Cn0，Grade），其中Grade列的类型为int。若在查询成绩时，希望将成绩按“优”、“良”、“中”、“及格”和“不及格”形式显示，则下列Case函数中正确的是（ ）。A.Case GradeWhen Grade between 90 and 100 THEN Grade=ˊ优ˊWhen Grade between 80 and 89 THEN Grade=ˊ良ˊWhen Grade between 70 and 79 THEN Grade=ˊ由ˊWhen Grade between 60 and 69 THEN Grade=ˊ及格ˊElse Grade=ˊ不及格ˊEndB.Case GradeWhen Grade between 90 and 100 THEN ˊ优ˊWhen Grade between 80 and 89 THEN ˊ良ˊWhen Grade between 70 and 79 THENˊ中ˊWhen Grade between 60 and 69 THENˊ及格ˊElseˊ不及格ˊEndC.CaseWhen Grade between 90 and 100 THEN Grade=ˊ优ˊWhen Grade between 80 and 89 THEN Grade=ˊ良ˊWhen Grade between 70 and 79 THEN Grade=ˊ由ˊWhen Grade between 60 and 69 THEN Grade=ˊ及格ˊElse Grade=ˊ不及格ˊEndD.CaseWhen Grade between 90 and 100 THENˊ优ˊWhen Grade between 80 and 89 THEN ˊ良ˊWhen Grade between 70 and 79 THEN ˊ由ˊWhen Grade between 60 and 69 THEN ˊ及格ˊElseˊ不及格ˊEnd
考题
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?()
A.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
考题
Under certain circumstances, profits made on transactions between members of a group need to be eliminated from the consolidated financial statements under IFRS.Which of the following statements about intra-group profits in consolidated financial statements is/are correct?(i) The profit made by a parent on the sale of goods to a subsidiary is only realised when the subsidiary sells the goods to a third party(ii) Eliminating intra-group unrealised profits never affects non-controlling interests(iii) The profit element of goods supplied by the parent to an associate and held in year-end inventory must be eliminated in fullA.(i) onlyB.(i) and (ii)C.(ii) and (iii)D.(iii) only
考题
When is a first－hop redundancy protocol needed in the distribution layer?()
A. when HSRP is not supported by the designB. when multiple vendor devices need to be supportedC. when preempt tuning of the default gateway is neededD. when a robust method of backing up the default gateway is neededE. when the design implements Layer 2 between the access switch and the distribution switchF. when the design implements Layer 3 between the access switch and the distribution switch
考题
设SC表中记录成绩的列为：Grade，类型为int。若在查询成绩时，希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示，正确的Case函数是（）。A Case Grade When 90~100 THEN ’优’ When 80~89 THEN ’良’ When 70~79 THEN ’中’ When 60~69 THEN ’及格’ Else ’不及格’ EndB Case When Grade between 90 and 100 THEN Grade = ’优’ When Grade between 80 and 89 THEN Grade = ’良’ When Grade between 70 and 79 THEN Grade = ’中’ When Grade between 60 and 69 THEN Grade = ’及格’ Else Grade = ’不及格’ EndC Case When Grade between 90 and 100 THEN ’优’ When Grade between 80 and 89 THEN ’良’ When Grade between 70 and 79 THEN ’中’ When Grade between 60 and 69 THEN ’及格’ Else ’不及格’ EndDCase Grade When 90~100 THEN Grade = ’优’ When 80~89 THEN Grade = ’良’ When 70~79 THEN Grade = ’中’ When 60~69 THEN Grade = ’及格’ Else Grade = ’不及格’ End
考题
What are the three main types of networks that must be considered when defining a security policy？
考题
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
考题
When using the Call Subflow step, can variables be shared between the parent (calling) flow and the subflow?（）A、No. B、Yes. C、Yes, but they must be manually passed via input and output mapping. D、Yes, but they must be manually created in both flows and have the same name.
考题
When is a first-hop redundancy protocol needed in the distribution layer?（）A、when HSRP is not supported by the designB、when multiple vendor devices need to be supportedC、when preempt tuning of the default gateway is neededD、when a robust method of backing up the default gateway is neededE、when the design implements Layer 2 between the access switch and the distribution switchF、when the design implements Layer 3 between the access switch and the distribution switch
考题
When is a first-hop redundancy protocol needed in the distribution layer？（）A、 when the design implements Layer 2 between the access arid distribution blocksB、 when multiple vendor devices need to be supportedC、 when preempt tuning of the default gateway is neededD、 when a robust method of backing up the default gateway is neededE、 when the design implements Layer 2 between the access switch and the distribution blocksF、 when the design implements Layer 2 between the access and distribution blocks
考题
When defining resources for a concurrent resource group， which of the following is NOT supported？（） A、 Application Servers using diskB、 Definition of Multiple IP aliasesC、 Volume Groups using raw logical volumesD、 Volume Groups supporting concurrent access
考题
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
考题
You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）A、Ensure that the child column and the parent column have the same names.B、Ensure that the child table and the parent table have the same names.C、Ensure that the child column and the parent column have the same data types.D、Ensure that each row in the child table has a corresponding row in the parent table.E、Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
考题
问答题What are the three main types of networks that must be considered when defining a security policy？
考题
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A
The dependent materialized view should have a complete refresh performed after the online table redefinition process.B
Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C
Referential integrity constraints must be manually enabled after the online table redefinition process.D
The materialized log should be dropped before the online table redefinition process.
考题
单选题You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables. Which action would you take to delay the referential integrity checking until the end of thetransaction（）A
Set the constraint to deferred before starting the transaction.B
Alter the constraint to NOVALIDATE state before starting the transaction.C
Enable the resumable mode for the session before starting the transaction.D
Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
考题
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
考题
单选题When there are cordial relations between the two countries, we mean there exists a ______ relationship between them.A
friendlyB
hostileC
fertileD
complicated
考题
单选题When using the Call Subflow step, can variables be shared between the parent (calling) flow and the subflow?（）A
No. B
Yes. C
Yes, but they must be manually passed via input and output mapping. D
Yes, but they must be manually created in both flows and have the same name.
考题
单选题When is a first-hop redundancy protocol needed in the distribution layer？（）A
when the design implements Layer 2 between the access arid distribution blocksB
when multiple vendor devices need to be supportedC
when preempt tuning of the default gateway is neededD
when a robust method of backing up the default gateway is neededE
when the design implements Layer 2 between the access switch and the distribution blocksF
when the design implements Layer 2 between the access and distribution blocks
考题
单选题If a parent organization is not specified when registering a user， which organization will the user be a member of？（）A
Buyer OrganizationB
Default OrganizationC
No OrganizationD
Root OrganizationE
Seller Organization
考题
单选题When configuring resource access policies in a Junos Pulse Access Control Service device, which entry is permitted when defining the specific resources?（）A
HostnameB
fully qualified domain nameC
IP addressD
address book entry
考题
单选题设SC表中记录成绩的列为：Grade，类型为int。若在查询成绩时，希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示，正确的Case函数是（）。A
Case Grade When 90~100 THEN ’优’ When 80~89 THEN ’良’ When 70~79 THEN ’中’ When 60~69 THEN ’及格’ Else ’不及格’ EndB
Case When Grade between 90 and 100 THEN Grade = ’优’ When Grade between 80 and 89 THEN Grade = ’良’ When Grade between 70 and 79 THEN Grade = ’中’ When Grade between 60 and 69 THEN Grade = ’及格’ Else Grade = ’不及格’ EndC
Case When Grade between 90 and 100 THEN ’优’ When Grade between 80 and 89 THEN ’良’ When Grade between 70 and 79 THEN ’中’ When Grade between 60 and 69 THEN ’及格’ Else ’不及格’ EndD
Case Grade When 90~100 THEN Grade = ’优’ When 80~89 THEN Grade = ’良’ When 70~79 THEN Grade = ’中’ When 60~69 THEN Grade = ’及格’ Else Grade = ’不及格’ End
热门标签
最新试卷
