网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which syntax turns an existing constraint on? （）
A
ALTER TABLE table_name ENABLE constraint_name;
B
ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
C
ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
D
ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which syntax turns an existing constraint on? （）A ALTER TABLE table_name ENABLE constraint_name;B ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;” 相关考题
考题
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 syntax turns an existing constraint on? ()
A. ALTER TABLE table_name ENABLE constraint_name;B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
考题
Which one of the following studies the internal structure of words， and the rules by which words are ( ) formed？ A.Morphology
B.Syntax
C.Phonology
D.Semantics
考题
Which syntax turns an existing constraint on?（）A、ALTER TABLE table_name ENABLE constraint_name;B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;C、ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;D、ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;E、ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
考题
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
考题
A technician has just installed an upgraded graphics card. The computers power turns off before itfinishes booting. Which of the following is the cause of the problem? （）A、The monitor cannot display the increased resolution that is a feature of the new graphics card.B、The power supply does not provide enough wattage to power the new graphics card.C、The new graphics card is incompatible with the existing processor.D、The computer does not have enough RAM to support the new graphics card.
考题
Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
考题
Which two statements are true about the primary key constraint in a table？ （）A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
考题
Which of the following is not a valid calendaring syntax element?（）A、FREQB、BYHOURC、RUNDATED、INTERVALE、BYMINUTE
考题
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（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
多选题Which four are valid Oracle constraint types? （）ACASCADEBUNIQUECNONUNIQUEDCHECKEPRIMARY KEYFCONSTANTGNOT NULL
考题
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A
The PRIMARY KEY is created along with a new index.B
The PRIMARY KEY is created and it would use an existing unique index.C
The PRIMARY KEY would be created in a disabled state because it is using an existing index.D
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
考题
多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue 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 checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题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 is most suitable for the cultivation of linguistic competence? _____A
Sentence makingB
Cue card dialogueC
Simulated dialogueD
Learning syntax
考题
单选题Which of the following is not a valid calendaring syntax element?（）A
FREQB
BYHOURC
RUNDATED
INTERVALE
BYMINUTE
考题
多选题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.
考题
多选题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 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 of the following is not a valid calendaring syntax element？（）A
FREQB
BYHOURC
RUNDATED
INTERVALE
BYMINUTE
考题
多选题Which two statements are true about the primary key constraint in a table？ （）AIt is not possible to disable the primary key constraint.BIt is possible to have more than one primary key constraint in a single table.CThe primary key constraint can be referred by only one foreign key constraint.DThe primary key constraint can be imposed by combining more than one column.EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
考题
单选题Which constraint can be defines only at the column level? （）A
UNIQUEB
NOT NULLC
CHECKD
PRIMARY KEYE
FOREIGN KEY
考题
单选题Which syntax turns an existing constraint on?（）A
ALTER TABLE table_name ENABLE constraint_name;B
ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;C
ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;D
ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;E
ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
考题
多选题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
考题
单选题Which of the following is most suitable for the cultivation of linguistic competence? _____A
Sentence makingB
Cue-card dialogueC
Simulated dialogueD
Learning syntax
热门标签
最新试卷
