Post Test Modul 4 APSI

System that is used when it wants to display the results of reports from a data analysis in the form of tabular, graphs and calculation results?

• REPORT

• SELECT

• CREATE

• DATABASE

An extract from the database which results can be directly printed through the printer media or (a)   to the monitor screen.

In MySQL, we can easily add numbers using the (a)   command (column) but in some cases, this command can not be used.

FILL THE BLANK

$conn = new PDO ("mysql:host=..............", $username, $password);

• $servername, $dbname

• $dbname; $servername

• $servername, dbname

• $servername; dbname

To return a result set as an array indexed by column name using?

• $sql = 'SELECT name, color, calories FROM fruit ORDER BY name'

• $row ->setFetchMode(PDO: :FETCH_ASSOC);

• $row = $pdo->query($sql)

• $conn = new PDO (“mysql:host=$servername; dbname”, $username,

  $password);

Connections to the database are made with?

(a)  

Construct a statement and execute it by using the query() method of PDO object...

• CREATE

• UPDATE

• SELECT

• INSERT

In making a report there are seven ways can be used?

• TRUE

• FALSE

The following is the list of differences between PDO and MySQL, except ....

• Database independence

• Set fetch mode for the PDOStatement object

• Object-orientation

• Connections to the database are made with a Data Source Name or DSN.

The following is a list of software used for APSI, except...

• Microsoft Office

• Draw.io

• XAPPM

• Adobe XD