POST-TEST MODUL 3 CRUDE

…… is useful for conducting database operations or managing data in database.

• CRUDE

• CURDE

• Create

• Read

The command used to create the database, except?

• Table

• Procedure

• Index

• Delete

The syntax below is an example of the code create?

INSERT INTO user (name, phone,address) VALUES (‘$name’, ‘$phone’,‘$address’)

• True

• False

….. is command that used to display or show the contents of the table.

• Table

• Procedure

• Read

• Update

The syntax below is the sample code from?

SELECT*FROM user WHERE id=$id

• Delete

• Index

• Update

• Read

Extension defines a lightweight, consistent interface for accessing databases in PHP is definision of PDO?

• TRUE

• FALSE

Below are the benefits of PDO?

• Security

• Reliability

• Usability

• Reusability

Connecting DB is an example of CRUDE?

• TRUE

• FALSE

The syntax below is the sample code from?

$conn = new PDO (mysql:host=$servername;dbname=myDB”, $username,$password);

• Read

• CRUDE

• PDO Query

• Connecting DB

The syntax below is an example of the code PDO Query?

$sql = DELETE name, color, calories FROM fruit ORDER BY name’;$row = $conn->query($sql)

• TRUE

• FALSE