CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 70

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