Which of the following statements about creating constraints is incorrect?
|
Q. Which two statements about creating constraints are true? (Choose two) Show
A. Constraint names must start with SYS_C. B. All constraints must be defined at the column level C. Constraints can be created after the table is created D. Constraints can be created at the same time the table is created E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view Answer: CD Which of the following statements about creating constraints is incorrect?
Which of the following statements about creating constraints is incorrect?
Which of the following is not true about creating constraints?Q 24 - Which of the following is not true about constraints? A - A NOT NULL constraint specifies that the column cannot have a null value.
Which statement about constraints is true?Answer: The correct answer is unique constraint column contains NULL and constraints will be disables if constraint column contains data. Explanation: Constraints are a query used in SQL.
Which of the following types of constraints will not allow null values?A NOT NULL constraint is a rule that prevents null values from being entered into one or more columns within a table. A unique constraint (also referred to as a unique key constraint) is a rule that forbids duplicate values in one or more columns within a table.
Which clause will allow you to delete a constraint?Use the DROP CONSTRAINT clause to destroy an existing constraint whose name you specify. This syntax fragment is part of the ALTER TABLE statement.
|
