CU - BCA -Sem VI - ADVANCED WEB DEVELOPMENT USING PHP

["... Here, we are using the $modelInstance->delete() method that will delete the post from database. 12.8 SUMMARY \uf0b7 you have learned about laravel inner join, left join, right join, advanced join, crosss join and as well as how to them with multiple conditions in laravel 8. \uf0b7 You have learned the major actions needed for any application, such as Create, Update, Read and Deleting data. Also known as CRUD. \uf0b7 With that knowledge, you can now improve the application to add more functionalities. 12.9 KEYWORDS \uf0b7 Optimizer \u2013 A component of the SQL system that estimates the optimum (i.e., fastest) method to access the database data requested is by particular SQL SELECT, UPDATE, or DELETE statement. \uf0b7 Outer Join \u2013 A join formed between two tables that in addition to including the rows from the two tables with matching join column values will also include the values from one table that do not have matching rows in the other. \uf0b7 Page Size \u2013 The size in bytes of a database page. \uf0b7 Page \u2013 The basic unit of database file input\/output. Database files may be organized into a set of fixed-sized pages containing data associated with one or more record occurrences (table rows). \uf0b7 Party \u2013 A party to an Agreement (between Raima and Customer) \uf0b7 PLC \u2013 Programmable Logic Controller. 12.10 LEARNING ACTIVITY 1. create laravel application with example 2. create a form to perform insertion and Updation in database 251","12.11 UNIT END QUESTIONS A. Descriptive Questions Short Questions 1. What is Configuration 2. What is connectivity 3. What is fetching 4. What is join statement Long Questions 1. How to fetch data from database in laravel 2. How to perform insertion form data in database 3. How to perform updation form data in database 4. How to perform joins in Laravel with example 5. Explain with example of getQueryLog () 6. How to create laravel application B. Multiple Choice Questions 1)Which of the following DBMSs do not have a native PHP extension? A) MySQL B) IBM DB\/2 C) PostgreSQL D) Microsoft SQL Server E) None of the above 2)In PHP in order to access MySQL database you will use: A) mysqlconnect() function B) mysql-connect() function C) mysql_connect() function D) sql_connect() function 3)Transactions are used to treat sets of SQL statements atomically. A) True B) False 4) SQL is not case sensitive. SELECT is the same as select. 252","A) True B) False 5) Which of the following is not an SQL aggregate function? A) AVG B) SUM C) MIN D) MAX E) CURRENT_DATE() Answer 1) E, 2) C, 3) A, 4) A, 5) E 12.12 REFERENCES Reference Books: - 1. Professional WordPress: Design and Development by Brad Williams Step-By-Step WordPress for Beginners: How to Build a Beautiful Website on Your Own Domain from Scratch by Mike Taylor 253"]