Page 22 - Open Soource Technologies 304.indd
P. 22

Unit 1: My SQL



               6.  My SQL is a key part of LAMP (Linux, Apache, My SQL, PHP/Perl/Python)          Notes
                 (a)  True                       (b)  False

            1.7 Review Questions


               1.  What are the system requirements to install My SQL?
               2.  Write steps to Installing My SQL on Mac OS X.
               3.  Explain Authentication Process.

               4.  What is Two-Step Authentication Process?
               5.  What if I tell my Internet service provider to stop running My SQL as root, and it won’t?
               6.  What are common problems My SQL connection?
               7.  Explain Basic Security Guidelines.

               8.  Explain directory listing of My SQL applications.
               9.  What is the difference between SQL and SQL Server?

              10.  What are the advantages and disadvantages of primary key and foreign key in SQL?
            Answers for Self Assessment Questions
               1.  (a)    2.  (d)       3.  (b)      4.  (b)        5.  (d)     6.  (a)

            1.8 Further Reading




                          Teach Yourself PHP, My SQL & Apache, By Meloni, Pearson Education.




                          http://www.dev.My SQL.com/

































                                             LOVELY PROFESSIONAL UNIVERSITY                                    17
   17   18   19   20   21   22   23   24   25   26   27