ICT3612- Assignment-02

University of South Africa ICT3612- Assignment-02 YEAR 2022 Chapter 19 -23 COMPLETION1.________________ provides an object-oriented approach to working with a variety of database servers.ANS:PDOPHP Data Objects2.When you use a prepared SQL statement with PDO, you need to ________________ the parameters tovariable values before you can run the statement.ANS: bind3.After you run a prepared SQL statement with PDO, you can use the ________________ method of thePDOStatement object to get an array that corresponds with the rows in the result set.ANS: fetchAll4.When you use exception error mode, PHP throws a/an ________________ object when a PDO error occurs.ANS: PDOException5.When you use the procedural interface of mysqli, you use ________________ to perform the database operations.ANS: functions6.To execute a dynamic INSERT statement, you use the ________________ method of the PDO object that connects to the database.ANS: exec 7.To execute a dynamic SELECT statement, you use the ________________ method of the PDO object. ANS: queryMULTIPLE CHOICE1.One disadvantage of using mysqli is that ’t provide an objectoriented ’t provide for prepared