网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
多选题
Which four are valid Oracle constraint types? （）
A

CASCADE

B

UNIQUE

C

NONUNIQUE

D

CHECK

E

PRIMARY KEY

F

CONSTANT

G

NOT NULL

参考答案

参考解析
解析： 暂无解析
更多 “多选题Which four are valid Oracle constraint types? （）ACASCADEBUNIQUECNONUNIQUEDCHECKEPRIMARY KEYFCONSTANTGNOT NULL” 相关考题
考题 Which four are valid Oracle constraint types? () A. CASCADEB. UNIQUEC. NONUNIQUED. CHECKE. PRIMARY KEYF. CONSTANTG. NOT NULL
查看答案
考题 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 constraint types can be used to ensure the value of an INTEGER column references only positive values?（）A、UniqueB、CheckC、ReferentialD、Informational
查看答案
考题 Which three message types are valid PIMv2 message types？（）A、RegisterB、Register-StopC、Join/PruneD、RejectE、Register-PruneF、Register-Join
查看答案
考题 Which two statements are true about constraints? （）A、The UNIQUE constraint does not permit a null value for the column.B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.D、The NOT NULL constraint ensures that null values are not permitted for the column.
查看答案
考题 You executed the following code：   SQL CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）A、 journal tableB、 clustered tableC、 mapping tableD、 partitioned table
查看答案
考题 Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）A、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;B、ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;C、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;D、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;E、ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;F、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
查看答案
考题 You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?（）A、Design a trigger that verifies that the first names and surnames are not empty strings.B、Design a check constraint that verifies that the first names and surnames are not empty strings.C、Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.D、Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.E、Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.F、Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
查看答案
考题 多选题Which modifiers and return types would be valid in the declaration of a working main（） method for a Java standalone application？（）AprivateBfinalCstaticDintEabstract
查看答案
考题 多选题Which three menu item types are valid in a menu module?（）AMagicBPlainCCheckDList itemEDivider
查看答案
考题 多选题Which two are valid IS-IS PDU types？（）Abroadcast hellosBLevel 1 LAN hellosCPoint-to-point hellosDLevel 2 point-to-point hellos
查看答案
考题 多选题Which three message types are valid PIMv2 message types？（）ARegisterBRegister-StopCJoin/PruneDRejectERegister-PruneFRegister-Join
查看答案
考题 多选题You need to create a column that allows you to createa unique constraint. Which two column definitions should you choose?（）Anvarchar（100） NULLBnvarchar（max） NOT NULLCnvarchar（100） NOT NULLDnvarchar（100） SPARSE NULL
查看答案
考题 多选题Which of the following are valid program types for a lightweight job？（）APLSQL_BLOCKBEXECUTABLECJAVA_STORED_PROCEDUREDSTORED_PROCEDUREEEXTERNAL
查看答案
考题 多选题Which four service offerings are included in Oracle Public Cloud?（）ADatabase ServiceBData ServiceCJava ServiceDSecurity ServiceE.NET ServiceFSOA Service
查看答案
考题 多选题You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?（）ADesign a trigger that verifies that the first names and surnames are not empty strings.BDesign a check constraint that verifies that the first names and surnames are not empty strings.CDesign a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.DDesign a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.EDesign a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.FDesign a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
查看答案
考题 多选题Which two statements are true about constraints? （）AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.DThe NOT NULL constraint ensures that null values are not permitted for the column.
查看答案
考题 多选题Which three TLV types are valid in an IS-IS Hello PDU?（）ATLV 10 AuthenticationBTLV 1 Area AddressesCTLV 211 Graceful RestartDTLV 137 Dynamic Hostname ResolutionETLV 14 ABRs
查看答案
考题 多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
查看答案
考题 多选题Which four types of objects can be thrown using the throw statement？（）AErrorBEventCObjectDExceptionEThrowableFRuntimeException
查看答案
考题 多选题Which of the following three port types are valid Spanning Tree port types？（Choose the best threeanswers.）（）ADesignated portBNonswitch portCSwitch portDNonroot portENondesignated portFRoot port
查看答案
考题 多选题Which two are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
查看答案
考题 多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
查看答案
考题 多选题Which of the following are valid program types for a lightweight job?（）APLSQL_BLOCK PLSQLBEXECUTABLECJAVA_STORED_PROCEDUREDSTORED_PROCEDUREEEXTERNAL
查看答案
考题 单选题Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）A ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;B ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;C ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;D ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;E ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;F ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
查看答案
考题 多选题Which four types of object can be thrown using the throw statement？（）AErrorBEventCObjectDExceptionEThrowableFRuntime Exception
查看答案
考题 单选题You executed the following code：   SQL CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）A  journal tableB  clustered tableC  mapping tableD  partitioned table
查看答案
热门标签
最新试卷