多选题Which four are valid Oracle constraint types? （）ACASCADEBUNIQUECNONUNIQUEDCHECKEPRIMARY KEYFCONSTANTGNOT NULL
多选题
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? () 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?（）AALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;BALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;CALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;DALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;EALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;FALTER 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