Machine Learning Tutorials, Courses and Certifications
Course Name:- Keys and Constraints in MySQL
Keys and Constraints in MySQL Cognitive Class Final Exam Answers:-
Question 1. What can you use a primary key in a table for?
- Enforce uniqueness of table rows
- Define rows in the table
- Define columns in the table
- None of the above statements
Quesstion 2. In MySQL database, which feature enables a unique number to be generated automatically when a new record is inserted into a table?
- Identity feature
- Auto-increment feature
- Both of the mentioned features
- None of the above
Question 3. What do you create that automatically creates an index?
- Primary key
- Table
- Foreign key
- None of the above
Question 4. You created a new table in your MySQL database and later decide that you want to ensure that one of the fields always contains a value. What should you do?
- Turn on the Primary key option for the field.
- Turn off the NULL option for the field.
- There is no need to change anything in your table definition to make this happen.
- None of the above.
Question 5. When comparing primary keys to foreign keys, which of the following statements only describe foreign keys?
- Are related to a unique primary key.
- Are always indexed.
- Must be unique within the table.
- None of the above
