单选题Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）ADefine a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.BDefine a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).CDefine column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.DDefine column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
单选题
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
A
Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B
Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C
Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D
Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
参考解析
解析：
暂无解析
相关考题：
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?() A.UniqueB.CheckC.ReferentialD.Informational
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?() A.Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.B.Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).C.Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.D.Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）A.After a ROLLBACK is issuedB.After the sequence is alteredC.After the sequence is droppedD.After the current session ends
Which of the following scenarios are likely reasons for an EtherChannel to fail？（）A、Mismatched EtherChannel protocolB、Mismatched EtherChannel port selectionC、Mismatched EtherChannel distribution algorithmD、Mismatched trunk modeE、Mismatched native VLANF、Mismatched link speed
Which of following is used to periodically multicast by DIS on a LAN to ensure IS-IS link state databaseaccuracy？（）A、LSPB、PSNPC、ISHD、CSNPE、IIH
which one of the following is an @fuction that Lonnie can use to return the value from a specific field?（）A、 @value B、 @getfield C、 @GetItemVale D、 @getfieldvalue
In order to ensure best read performance， which of the following indicates how large an application’s read buffer size should be if the filesystem to be read is striped across N disks using LVM striping？（）A、 N times the stripe unit sizeB、 N times the VMM minfree parameterC、 The same value as that of the VMM maxfree parameterD、 The same value as that of the VMM maxrndwrt parameter
Which of the following is the BEST reason to label servers within the server room？（）A、 To ensure server documentation is kept up to dateB、 To ensure administrators avoid duplicate server namesC、 To ensure server power requirements are metD、 To ensure the servers can be identified quickly and easily
Which of the following applications is MOST likely to require QoS to ensure proper functionality?（）A、HTTPB、VoIPC、SNMPv3D、Peer to peer
Which of the following is the MOST important reason for referencing the HCL？（）A、 To ensure that all hardware being used has previously been testedB、 To ensure that all hardware being used has the latest firmwareC、 To ensure that all hardware being used is the most energy efficientD、 To ensure that all hardware being used can be upgraded in the future
Which of the following network protocols is needed to ensure that users can type in a FQDN instead of the IP address？（）A、DNSB、FTPC、WINSD、IMAP4
Which of the following backup methods should be used nightly to ensure backups capture all necessary data in the LEAST amount of time?（）A、DailyB、IncrementalC、NormalD、Differential
Which of the following network protocols is used to ensure consistent time across network devices on the domain?（）A、NTPB、FTPC、RTPD、IGMP
Which of the following "no options" controls the maximum value of mbufs？（）A、mtuB、sb_maxC、thewallD、tcp_sendspace
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）A、After a ROLLBACK is issuedB、After the sequence is alteredC、After the sequence is droppedD、After the current session ends
Which of the following should be used to ensure that all packets are received by every connecteddevice?（）A、HubB、RouterC、SwitchD、Firewall
单选题Which of the following "no options" controls the maximum value of mbufs？（）AmtuBsb_maxCthewallDtcp_sendspace
单选题which one of the following is an @fuction that Lonnie can use to return the value from a specific field?（）A @value B @getfield C @GetItemVale D @getfieldvalue
单选题Which of the following is the BEST reason to label servers within the server room？（）A To ensure server documentation is kept up to dateB To ensure administrators avoid duplicate server namesC To ensure server power requirements are metD To ensure the servers can be identified quickly and easily
单选题In order to ensure best read performance， which of the following indicates how large an application’s read buffer size should be if the filesystem to be read is striped across N disks using LVM striping？（）A N times the stripe unit sizeB N times the VMM minfree parameterC The same value as that of the VMM maxfree parameterD The same value as that of the VMM maxrndwrt parameter
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）AUniqueBCheckCReferentialDInformational
多选题Assume session is an HttpSession， and is not referenced anywhere else in ServletA. Which two changes， taken together， ensure that value is equal to “Hello” on line 23？ （）AABBCCDDEE
单选题Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）AThe next value will be 0 and the sequence will never use the values 101 to 105.BThe next value will be 101 to ensure uniqueness between existing and newly generated sequence values.CPreviously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.DThe next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
多选题Which of the following scenarios are likely reasons for an EtherChannel to fail？（）AMismatched EtherChannel protocolBMismatched EtherChannel port selectionCMismatched EtherChannel distribution algorithmDMismatched trunk modeEMismatched native VLANFMismatched link speed
单选题Which of the following is the MOST important reason for referencing the HCL？（）A To ensure that all hardware being used has previously been testedB To ensure that all hardware being used has the latest firmwareC To ensure that all hardware being used is the most energy efficientD To ensure that all hardware being used can be upgraded in the future
单选题lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）Ause a defaule formula of 1 Buse @elements and add 1 to the total Cuse the @count function instead of @elements Duse @texttotime to ensure that all strings arte converted to date-time values