WEB-DEV

Question 1

The PHP MySQL connect function is used to connect to a_________

Answer 1

MySQL database server.

Question 2

It has the following syntax.

Answer 2

<?php;
$con = mysql connect ($db_server_name, $db_username, $db);
?>

Question 3

Is the database connection resource variable.

Answer 3

“$con”

Question 4

Is the function for php database connection

Answer 4

“mysql _connect (…)”

Question 5

Is the name or IP address of the server hosting Mysql server.

Answer 5

“$server_name”

Question 6

Is a valid user name in MySQL server.

Answer 6

“$username”

Question 7

Is a valid associated with a user name in MySQL server.

Answer 7

”$”

Question 8

The ________ function is used to select a database

Answer 8

mysqli_select_db

Question 9

It has the following syntax.

Answer 9

<?php
mysqli_select_db ($con, $database_name);
?>

Question 10

Is the database selection function that returns either true or false

Answer 10

“mysqli_select_db (…)”

Question 11

Is the name of the database

Answer 11

“$database_name”

Question 12

Is optional, it is used to pass in the server connection link

Answer 12

“$link_identifier”

Question 13

MySQLi CREATE DATABASE

Answer 13

TINGIN KA NALANG SA MODULE (MODULE 7)

Question 14

Is a field attribute and it is being used because we do not want this Field to be NULL.

Answer 14

NOT NULL

Question 15

Tells MySQLi to go ahead and add the next available number to the id field.

Answer 15

AUTO_INCREMENT

Question 16

Is used to define a column as______
You can use multiple columns separated by comma to define a ________

Answer 16

PRIMARY KEY

Question 17

MySQLi _______ statement is used to insert data into MySQLi table.

Answer 17

INSERT INTO

Question 18

Below the syntax of INSERT INTO command

Answer 18

INSERT INTO table_name

Question 19

Statement is used to fetch data from the one or more tables.

Answer 19

MySQLi Select record

Question 20

We can retrieve records of all Fields or specified Fields.

Answer 20

MySQLi SELECT

Question 21

Statement is used to update existing records in a table.

Answer 21

MySQLi UPDATE RECORD

Question 22

Statement is used to delete existing records in a table.

Answer 22

MySQLi DELETE RECORD

Question 23

Statement is used to sort the results -set in ascending or descending order.

Answer 23

MySQLi ORDER By

Question 24

Statement is used with aggregate function as COUNT , MAX , MIN, SUM etc to group the result-set by one or more columns…

Answer 24

MySQLi GROUP By

Question 25

Clause is often used with the GROUP BY clause to filter groups based on a specified Condition.

Answer 25

MySQLi HAVING

Question 26

Condition allows wildcard to be used in the WHERE clause of a SELECT, INSERT UPDATE, or DELETE statement.

Answer 26

MySQLi LIKE

Question 27

This allows you to perform pattern matching.

Answer 27

MySQLi LIKE

Question 28

Allows you to match any string of any length ( including zero length )

Answer 28

%

Question 29

Allows you to match on a single character

Answer 29

-

Question 30

Optional. It allows you to test for literal instances of a wildcard character such as % or _.

Answer 30

escape _character

Question 31

If you do not provide the escape _character, MySQLi that ______ is the escape_character.

Answer 31

”"

Question 32

What is PHP

Answer 32

Hypertext preprocessor