______states that primary keys should not be null:

Related MCQs

• A                  is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
• With SQL, how can you return the number of not null records in the “Persons” table?
• Which of the following is true regarding Null Value?
• Inorder to simplify the null value confusion in the rank function we can specify
• ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
• View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
• If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called