Deck 3: PHP and MYSQL: Object Creation, Cookies, Sessions, and Database Operations

Question 1

If you create a _______function, PHP will automatically call this function when you create an object from a class.

A)__construct()
B)___destruct()
C)both a and b
D)none of these

Answer 1

__construct()

Question 2

A destructor is called when the object is destructed or the script is stopped or exited.

A)true
B)false
C)both a and b
D)none of these

Answer 2

true

Question 3

A cookie is a small file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, it will send the cookie too. With PHP, you can both create and retrieve cookie values.

A)true
B)false
C)both a and b
D)none of these

Answer 3

true

Question 4

A session is a way to store information (in variables) to be used across multiple pages.

A)true
B)false
C)both a and b
D)none of these

Question 5

Which one of the following databases has PHP supported almost since the beginning?

A)Oracle Database
B)SQL
C)SQL+
D)MySQL

Question 6

Which one of the following statements is used to create a table?

A)CREATE TABLE table_name (column_namecolumn_type);
B)CREATE table_name (column_typecolumn_name);
C). CREATE table_name (column_namecolumn_type);
D). CREATE TABLE table_name (column_typecolumn_name);

Question 7

Which method returns the error code generated from the execution of the last MySQL function?

A)errno()
B). errnumber()
C). errorno()
D)errornumber()

Question 8

If there is no error, then what will the error() method return?

A). TRUE
B). FALSE
C). Empty String
D). non of these

Question 9

Which one of the following statements should be used to include a file?

A). #include 'filename';
B)include 'filename';
C)include <filename>
D)none of these

Question 10

Which one of the following methods recuperates any memory consumed by a result set?

A)destroy()
B)remover()
C)alloc()
D)free()

Question 11

Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

A). connect_errno()
B)connect_error()
C)mysqli_connect_errno()
D). mysqli_connect_error()

Question 12

Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?

A)get_row()
B). fetch_row()
C). fetch()
D)row()

Question 13

Which one of the Following methods is responsible for sending the query to Database

A)query()
B)send_query( )
C)sendquery()
D)query_send()

Question 14

Which is the comment symbol in mysql?

A)&&
B)/*….*/
C)#
D)%

Question 15

A ________ consists of one or more tables.

A)database
B)command
C)Query
D)none of these

Question 16

________ is used to uniquely identify the rows in table.

A)primary key
B)Database
C)not null
D)none of these

Question 17

_____ returns the last error description for the most recent function call

A)Error no
B)Zero no
C)no error
D)none of these

Question 18

A _______ is a server that manages data for user.

A)Wamp
B)World
C)Excel
D)none of these

Question 19

RDBMS stands for __________.

A)Relation data base management
B)reletives data base management
C)Random data base management
D)none of these

Question 20

In PHP $Icon=mySQL_connect("localhost","root","") is used to ____ to the data base .

A)create
B)close
C)connect
D)none of these

Question 21

mysql_close() is use to ________database(wamp) in php .

A)create
B)close
C)connect
D)none of these

Question 22

______ is use to create the web page .

A)Word press
B)Lotus
C)Word star
D)none of these .

Question 23

die(mySQL_error()) is used to show _______ message .

A)error
B)Connect
C)create
D)none of these

Question 24

The long form of SQL is __________.

A)Structural query language
B)Structural question language
C)System Query Language
D)None of these

Question 25

the switch statement is used to perform different actions based on different conditions

A)true
B)false
C)both a and b
D)none of these