MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
PHP
Databases Handling
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Q.1
Which of the methods are used to manage result sets using both associative and indexed arrays?
get_array() and get_row()
get_array() and get_column()
fetch_array() and fetch_row()
fetch_array() and fetch_column()
Q.2
The (|/) tells the server to match ___________
nothing
forward slash
backward slash
either nothing or a forward slash
Q.3
([w-]+) will match ___________
one word characters
one or more word characters
one or more word characters and/or hypens
one or more word characters and hypens
Q.4
Which one of the following statements instantiates the mysqli class?
mysqli = new mysqli()
$mysqli = new mysqli()
$mysqli->new.mysqli()
mysqli->new.mysqli()
Q.5
Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?
num_rows()
affected_rows()
changed_rows()
new_rows()
Q.6
Which one of the following statements can be used to select the database?
$mysqli=select_db(‘databasename’);
mysqli=select_db(‘databasename’);
mysqli->select_db(‘databasename’);
$mysqli->select_db(‘databasename’);
Q.7
Which one of the following methods can be used to diagnose and display information about a MySQL connection error?
connect_errno()
connect_error()
mysqli_connect_errno()
mysqli_connect_error()
Q.8
Which method returns the error code generated from the execution of the last MySQL function?
errno()
errnumber()
errorno()
errornumber()
Q.9
If there is no error, then what will the error() method return?
TRUE
FALSE
Empty String
0
Q.10
You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.
$_GET[‘url’].
$_SET[‘url’].
$_GET[‘admin’].
$_SET[‘admin’].
Q.11
To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________
index.php
index.ini
admin.php
.htaccess
Q.12
Your confirmation form submits your choice, via the _______ method, to ________
GET index.php
GET admin.php
POST index.php
POST admin.php
Q.13
When a user confirms that he wishes to delete an entry, that entry’s URL is passed to a function which removes the entry from the __________
index.php
function.inc.php
database
admin.php
Q.14
Which of the following DBMSs do not have a native PHP extension?
MySQL
IBM DB/2
PostgreSQL
Microsoft SQL Server
None of the above
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page