Quiz 1 Set 2

Download Report

Transcript Quiz 1 Set 2

Quiz 1 (5%)
Relax
Quiz 1 (5%)
• Good news
– Group quiz
– Group member must less or equal to 5 members
• I give you 1 minute to write your group members’ name.
– You can discuss (quietly)
• Bad news
– It is a close book quiz, if Mr Azlan notice that you
open your book, he will give 0 to you and all group
member.
– Each slide/question has a timer (15 seconds)
– Once the slide change, can’t turn back
– Cannot record the presentation using
handphone/digital camera etc
– So, answer quickly
Instruction
• 22 questions (short answer) = 22 marks
• That’s all.
• Any question?
- Ask Mr Azlan right now
- Don’t forget to write “SET 2” on topright corner of your answer sheet
- One group submit one answer sheet
only
Ok time’s up. Mr Azlan, sit on
your chair, keep quiet.
Let them think and discuss among
themselves. Students, are you
ready?
Question 1
There is 1 table field in the table (Yes/No)
Question 2
There is 1 table only in the azlanydb (Yes/No)
Question 3
The table is call login (Yes/No)
Question 4
To insert a data, user need to click Insert tab. (Yes/No)
Question 5
How many characters can be entered in username?
Question 6
How many tables field in login?
Question 7
What is the name of the text field and password field?
Question 8
What is the word that will appear on the button when the insert1.html is
open using the browser?
Question 9
Fill in the blank. What is the answer?
$link = _________ (“localhost”,”root”,””);
Question 10
What is the username?
$link = _________ (“localhost”,”root”,””);
Question 11
Fill in the blank. What is the answer?
$db = _________ (“azlanydb”,$link);
Round 1 finished
Take your breath deeply…
Relax…
Ready for round 2
Question 12
Is there any error? (Just answer Yes/No)
SQL statement
select all from login;
Question 13
Is there any error? (Just answer Yes/No)
<?php
$query = “delete from login”;
$result = mysql_query($query);
?>
Question 14
Is there any error? (Just answer Yes/No)
SQL statement.
update login set username=azlan;
Question 15
Is there any error? (Just answer Yes/No)
<?php
echo “Azlan”;
?>
Question 16
Is there any error? (Just answer Yes/No)
$azlan = “azlan”;
<?php
echo $azlan;
?>
Question 17
Is there any error? (Just answer Yes/No)
<?php
$azlan = “azlan”;
echo $azlan;
?>
Question 18
Is there any error? (Just answer Yes/No)
<?php
$azlan = “azlan”;
echo “$azlan”;
?>
Question 19
Is there any error? (Just answer Yes/No)
<?php
$name = “Azlan;
echo “Hello”.$name;
?>
Question 20
Is there any error? (Just answer Yes/No)
<?php
$name = “Azlan”;
echo “Hello” $name;
?>
Question 21
What is the MySQL statement to view all
MySQL database?
Question 22
What is the PHP function used to select the
MySQL database?
The end
Please submit your answer