单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）AA check constraint on the EMPLOYEE tableBA unique constraint on the EMPLOYEE table WORKDEPT columnCA foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableDA foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
单选题
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
A
A check constraint on the EMPLOYEE table
B
A unique constraint on the EMPLOYEE table WORKDEPT column
C
A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D
A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
参考解析
解析：
暂无解析
相关考题：
What type of extinguisher should be used for an electric fire? ________A.CO2B.FormC.WaterD.Water and Form
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.
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?() A.Define the column MAINID as NOT UPDATABLEB.Define the column MAINID as a PRIMARY KEYC.Define the column MAINID as a FOREIGN KEYD.Define an UPDATE trigger on table TABLEX
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?() A.CheckB.RangeC.ReferentialD.Informational
When selecting a Network Interface Card (NIC), which of the following factors need to be considered?() A. The type of application used on the networkB. The type of system bus used by the computersC. The type of memory installed in each computerD. The type of media used in the network topologyE. The type of protocols used in the networkF. The physical layout of the network hosts
What OSPF LSA is used to support MPLS-traffic Engineering ？（）A、External LSA （Type 5 ）B、Opaque LSA （Type 9 ）C、Opaque LSA （Type 10 ）D、Opaque LSA （Type 11 ）E、NSSA LSA （Type 7 ）
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command（）A、It fails if any existing row violates the constraint.B、It does not validate the existing data in the table.C、It enables the constraint to be enforced at the end of each transaction.D、It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A、A check constraint on the EMPLOYEE tableB、A unique constraint on the EMPLOYEE table WORKDEPT columnC、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
When selecting a Network Interface Card (NIC), which of the following factors need to be considered?（）A、The type of application used on the networkB、The type of system bus used by the computersC、The type of memory installed in each computerD、The type of media used in the network topologyE、The type of protocols used in the networkF、The physical layout of the network hosts
When configuring a Commerce Payments cassette for a merchant， what should be created for EACH account？（）A、A batch for each supported credit card typeB、A batch for each currency and credit card typeC、A batch for each cassette and currencyD、A brand for each supported credit card typeE、A brand for each currency and credit card type
What does the FREQ column show when running the tprof option? （）A、Total amount of Ticks used by all usersB、Total amount of Ticks used by all processesC、Total amount of Ticks used by a specific userD、Total amount of Ticks used by a specific type of process
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A、Define the column MAINID as NOT UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX
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.
You are the network administrator for your company. The network consists of a single Active Directory domain. All servers run Windows Server 2003. You need to update six high-visibility servers with critical updates by using Windows Server Update Services （WSUS）. You approve all of the updates.You need to ensure that the updates are applied within one hour. What should you do？（）A、On the WSUS server， type the gpupdate /force command at the command prompt.B、On the WSUS server， type the wuauclt /detectnow command at the command prompt.C、On each of the six servers， type the gpupdate /force command at the command prompt.D、On each of the six servers， type the wuauclt /detectnow command at the command prompt.
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）AUniqueBCheckCReferentialDInformational
多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）AIt fails if any existing row violates the constraint.BIt does not validate the existing data in the table.CIt enables the constraint to be enforced at the end of each transaction.DIt prevents insert， update， and delete operations on the table while the constraint is in the process of being enabled.
多选题You need to design the storage of the loan response message. Which actions or actions should you perform?（）AUse the xml data type to store the message.BUse a user-defined data type to store the message.CUse the nvarchar（max） data type to store the message.DUse a check constraint to validate that the correct tags are used.EUse an XML schema definition （XSD） to validate that the correct tags are used.FUse a foreign key constraint to validate that the correct tags are used.
单选题Examine the command： ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS； What does the command accomplish？（）ACreates an additional copy of the database online redo log files. BStores the primary key column values of each row involved in a DML operation in the online redo log files. CStores the primary key column values of each row involved in a DML operation in the supplemental log files. DStores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.
多选题When selecting a Network Interface Card (NIC), which of the following factors need to be considered?（）AThe type of application used on the networkBThe type of system bus used by the computersCThe type of memory installed in each computerDThe type of media used in the network topologyEThe type of protocols used in the networkFThe physical layout of the network hosts
单选题You are the network administrator for your company. The network consists of a single Active Directory domain. All servers run Windows Server 2003. You need to update six high-visibility servers with critical updates by using Windows Server Update Services （WSUS）. You approve all of the updates. You need to ensure that the updates are applied within one hour. What should you do？（）AOn the WSUS server， type the gpupdate /force command at the command prompt.BOn the WSUS server， type the wuauclt /detectnow command at the command prompt.COn each of the six servers， type the gpupdate /force command at the command prompt.DOn each of the six servers， type the wuauclt /detectnow command at the command prompt.
单选题What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）ACheckBRangeCReferentialDInformational
单选题What type of rotor is used in split-phase motors?（）ADramBSalient poleCSquirrel-cageDWound-rotor
单选题What OSPF LSA is used to support MPLS-traffic Engineering ？（）AExternal LSA （Type 5 ）BOpaque LSA （Type 9 ）COpaque LSA （Type 10 ）DOpaque LSA （Type 11 ）ENSSA LSA （Type 7 ）
单选题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.
单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）AA check constraint on the EMPLOYEE tableBA unique constraint on the EMPLOYEE table WORKDEPT columnCA foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableDA foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command（）AIt fails if any existing row violates the constraint.BIt does not validate the existing data in the table.CIt enables the constraint to be enforced at the end of each transaction.DIt prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled
单选题When configuring a Commerce Payments cassette for a merchant， what should be created for EACH account？（）AA batch for each supported credit card typeBA batch for each currency and credit card typeCA batch for each cassette and currencyDA brand for each supported credit card typeEA brand for each currency and credit card type