CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 71

It is VERY important to consider that altering tables can require a bit of time for very large tables, and that while the table is locked, other users and processes cannot operate. Consequently, this kind of modification should not be done during peak operating hours in a production operation( as a student in a lab exercise, working on your own database, you may do this at any time) but ideally in hours during which the business does not normally operate. In cases where round-the-clock, high availability of a database is required, other approaches may be required. Addressing this problem in a high-availability, high-demand environment is an advanced topic, study of which is outside the scope of this course. Use the outline below to construct your script. Show all commands in your answer sheet along with the output of the commands.
lock table customers write; set foreign _ key _ checks = 0;
– Replace this comment with your ALTER TABLE command to add the auto _ increment feature to the PK field
set foreign _ key _ checks = 1; unlock tables; – statements to insert two rows into the table – verify auto _ increment with a select statement

It is VERY important to consider that altering tables can require a bit of time for very large tables, and that while the table is locked, other users and processes cannot operate. Consequently, this kind of modification should not be done during peak operating hours in a production operation( as a student in a lab exercise, working on your own database, you may do this at any time) but ideally in hours during which the business does not normally operate. In cases where round-the-clock, high availability of a database is required, other approaches may be required. Addressing this problem in a high-availability, high-demand environment is an advanced topic, study of which is outside the scope of this course. Use the outline below to construct your script. Show all commands in your answer sheet along with the output of the commands.

lock table customers write; set foreign _ key _ checks = 0;

– Replace this comment with your ALTER TABLE command to add the auto _ increment feature to the PK field

set foreign _ key _ checks = 1; unlock tables; – statements to insert two rows into the table – verify auto _ increment with a select statement