IT6314 Web Application Development 1
(Final Q1, Q2 & Final Exam)
Question 1
Question text
Question 2
Question text
Question 3
Question text
This is Employee table.
Select * from employee where employee_id>1009;
Which of the following employee_id will be displayed?
Question 4
Question text
Question 5
Question text
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 1
Question text
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Question 6
Question text
Assuming the table and fields below exists, what is wrong with the following mysql query example: mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber) VALUES ('Robert', 'Smith')");
Question 7
Question text
Question 8
Question text
Which of the following fields are displayed as output?
Question 9
Question text
Question 10
Question text
Question 1
Question text
In the given query which of the keyword has to be inserted ?
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Select ID, name, dept name, sal * 1.1
where instructor;
Question 6
Question 7
Question text
Question 8
Question text
The "I" in MySQLi stands for
Question 9
Question text
Question 10
Question text
Question 1
Question text
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 1
Question text
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 1
Question text
Question 2
Question text
Question 3
Question text
In the given query which of the keyword has to be inserted ?
Question 4
Question text
Question 5
Question text
Question 6
Question text
mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber)
VALUES ('Robert', 'Smith', '123-983-2929')");
Question 7
Question text
Which of the following statements contains an error?
Question 8
Question text
The "I" in MySQLi stands for
Question 9
Question text
Question 10
Question text
Select ________ dept_name
from instructor;
Question 1
Question text
Question 2
Question text
SELECT pub_name,LENGTH(pub_name)
FROM publisher
WHERE LENGTH(pub_name)>=20;
Question 3
Question text
Question 4
Question text
Question 5
Question text
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 1
Question text
SELECT vend_name, prod_name, prod_price, vendors.vend_id, products.vend_id
FROM vendors INNER JOINS products
ON vendors.vend_id = products.vend_id;
Question 2
Question text
Question 3
Question 4
Question text
Question 5
Question text
Question 6
Question text
SELECT *
FROM author
WHERE auth_name LIKE 'W%';
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 1
Question text
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Determine the exact output of the code:
for($val=1; $val<=100; $val+=2) {
$tem[] = $val*=2;
}
echo min($tem);
Feedback
Your answer is correct.
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 11
Question text
Question 12
Question text
Question 13
Question text
Question 14
Question text
Question 15
Question text
Question 16
Question text
Question 17
Question text
Question 18
Question text
Question 19
Question text
Question 20
Question text
Question 21
Question text
Question 22
Question text
Question 23
Question text
Question 24
Question text
Question 25
Question text
Question 26
Question text
Question 27
Question text
Question 28
Question text
Question 29
Question text
Question 30
Question text
Question 31
Question text
Question 32
Question text
Question 33
Question text
What is the correct method to use in Javascript Sorting Arrays?
Question 34
Question text
Question 35
Question text
Question 36
Question text
Question 37
Question text
Question 38
Question text
Question 39
Question text
Question 40
Question text
Question 41
Question text
Question 42
Question text
Question 43
Question text
Question 44
Question text
Question 45
Question text
Question 46
Question text
Question 47
Question text
Question 48
Question text
Question 49
Question text
Question 50
Question text
Question 1
Question text
Determine the exact output of the code $str = "The quick brown fox jumps over the the lazy dog"; echo strpos($str, 'fox');
Question 2
Question text
Question 3
Question text
Question 4
Question text
Question 5
Question text
Question 6
Question text
Question 7
Question text
Question 8
Question text
Question 9
Question text
Question 10
Question text
Question 11
Question text
It is placed within the code of a loop to cause the program to stop the loop statement.
Feedback
Your answer is correct.
Question 12
Question text
Question 13
Question text
Determine the exact output of the code:
for($val=1; $val<=100; $val+=2) {
$tem[] = $val*=2;
}
echo max($tem);
Feedback
Your answer is correct.
Question 14
Question text
Question 15
Question text
Question 16
Question text
Question 17
Question text
$num = 3.14;
echo floor($num);
Question 18
Question text
Question 19
Question text
Question 20
Question text
In PHP you can use both single quotes ( ' ' ) and double quotes ( " " ) for strings: