[S3_S4-SUMMATIVE] APP DEVELOPMENT

are mechanism for storing data in the remote browser and thus tracking or identifying return users.

Group of answer choices

Session

Cookies

Remote

Variable

Cookies

get the number of affected rows by the last SELECT, INSERT, UPDATE, REPLACE or DELETE query.

Correct

Your Answer:

affected_mysql_rows()

mysql_affected_rows()

rows_affected()

affected_row()

an associative array of variables passed to the current script via HTTP Cookies

Group of answer choices

$_ENV

$_SESSION

$_REQUEST

$_COOKIE

$_COOKIE

what is P in PCRE

Group of answer choices

Popular

Present

Percl

Program

Percl

Regular Expression Meta characters symbol for exactly two of 'a'

Group of answer choices

a+2

a(2)

a*2

a{2}

a{2}

What is R in PCRE

Group of answer choices

Regular

Rest

Robust

Relay

Regular

Is the process of breaking tables into multiple related tables to reduce redundant information.

Group of answer choices

Normalization

Primary key

Foreign key

Primary table

Normalization

Command to show database

Group of answer choices

VIEW

SHOW

SHOWDB

VIEWDB

SHOW

mysql_rows() get the number of affected rows by the last SELECT, INSERT, UPDATE, REPLACE or DELETE query.

Group of answer choices

True

False

False

SQL command that will get the sum of a specified field

Group of answer choices

SUM

ADD

SUMMATION

PLUS

SUM

Use to read a specified set of characters in a file

Group of answer choices

cread()

fread()

sread()

readf()

fread()

Syntax to Retrieves the contents of one cell from a MYSQL result set

Group of answer choices

mysql_fetch(($result_query, row, field)

mysql_result($result_query, row, field)

mysql_query(($result_query, row, field)

mysql_fetch_array(($result_query, row, field)

mysql_result($result_query, row, field)

In creating a file, If the file already exists, its contents won't be disturbed

Group of answer choices

False

True

True

Syntax for opening a file

Group of answer choices

openf("file","mode")

fileopen("file","mode")

openfile("file","mode")

fopen("file","mode")

fopen("file","mode")

Complete the syntax: mysql_result(_____,row,field)

Group of answer choices

$result_query

$result

$query_result

$query

$result_query

attempts to create an empty file.

Group of answer choices

empty()

touch()

attempt()

create()

touch()

To save permanently the uploaded file, use the move_uploaded_file() function. This function returns TRUE on success, or FALSE on failure.

Group of answer choices

True

False

True

use to read a file per character

Group of answer choices

fgetc()

getfc()

charget()

fcahrget()

fgetc()

Syntax to open a file for writing

Group of answer choices

fopen("test.txt","w")

fileopen("test.txt","w")

openfile("test.txt","w")

openf("test.txt","w")

fopen("test.txt","w")

$query = mysql_query("SELECT MAX(tuition) FROM tblinfo");

$fetch = mysql_fetch_array($query);

Echo $fetch[0];

Check the code if valid or invalid

Group of answer choices

Valid

Invalid

Valid

Use to tell the last line of a file

Group of answer choices

endoffile()

feof()

lastfile()

lastline()

feof()

mysql_num_rows() is only valid for statements like SELECT or SHOW that return an actual result set.

Group of answer choices

True

False

True

Syntax to open a file for appending

Group of answer choices

fopen("test.txt","a")

openf("test.txt","a")

openfile("test.txt","a")

fileopen("test.txt","a")

fopen("test.txt","a")

Checking the file status if executable

Group of answer choices

check_executable()

is_execute()

check_execute()

is_executable()

is_executable()

Complete the syntax:$_FILES["file"][______]

Group of answer choices

type

size

name

index

index

Complete the syntax: mysql_result($result_query,_____,field)

Group of answer choices

Column

Row

Type

Name

Row

$query = mysql_query("SELECT MIN(tuition) FROM tblinfo");

$fetch = mysql_result($query,0);

Echo $fetch

Check the code if valid or invalid

Group of answer choices

Invalid

Valid

Valid

complete the syntax: move_upload_file(file, ________);

Group of answer choices

name

new location

size

type

new location

Complete the syntax:$_FILES[____]["index"]

Group of answer choices

size

file

name

type

file

Syntax to read a line from a file

Group of answer choices

lgets("$file",1024)

getsf("$file",1024)

fgets("$file",1024)

getsl("$file",1024)

fgets("$file",1024)

Syntax for removing an existing file

Group of answer choices

unlink("myfile.txt")

drop("myfile.txt")

delete("myfile.txt")

remove("myfile.txt")

unlink("myfile.txt")

$query = mysql_query("SELECT MIN(tuition) FROM tblinfo");

$fetch = mysql_fetch_array($query);

Echo $fetch[0];

Check the code if valid or invalid

Group of answer choices

Valid

Invalid

Valid

Checking for file existence

Group of answer choices

file_check()

exists_file()

file_exists()

check_file()

file_exists()

Syntax to tell the last line of a file

Group of answer choices

lastfile("$file")

feof("$file")

endoffile("$file")

lastline("$file")

feof("$file")

Function to save permanently the uploaded file

Group of answer choices

save_uploaded_file()

move_uploaded_file()

save_file()

upload_file()

move_uploaded_file()

Checking the file status if writable

Group of answer choices

is_writable()

check_writable()

is_write()

check_write()

is_writable()

Before removing or deleting files you need to indicate the extension file name of the file

Group of answer choices

True

False

True

Retrieves the contents of one cell from a MYSQL result set

Group of answer choices

mysql_result()

mysql_query()

mysql_fetch_array()

mysql_fetch()

mysql_result()

retrieves the number of rows from a result set.

Group of answer choices

mysql_rows()

mysql_number_rows()

mysql_rows_num()

mysql_num_rows()

mysql_num_rows()

Use to read a line from a file

Group of answer choices

getsl()

getsf()

fgets()

lgets()

fgets()

A function used to remove an existing file

Group of answer choices

remove()

drop()

delete()

unlink()

unlink

other command for fwrite()

Group of answer choices

fputs()

fileput()

putfile()

putsf()

fputs()

$query = mysql_query("SELECT MAX(tuition) FROM tblinfo");

$fetch = mysql_fetch_array($query);

Echo $fetch ["MAX(tuition)"];

Check the code if valid or invalid

Group of answer choices

Invalid

Valid

Valid

The name of the temporary copy of the file stored on the server

Group of answer choices

name_temp

tempo_name

tmp_name

name_temporary

tmp_name

Complete the syntax: move_upload_file(____, new location) ;

Group of answer choices

Type

Size

File

location

File

function accepts a file resource and a string, and then writes the string to the file

Group of answer choices

writef()

fwrite()

writefile()

filewrite()

fwrite()

$query = mysql_query("SELECT MIN(tuition) FROM tblinfo");

$fetch = mysql_fetch_array($query);

Echo $fetch ["MIN(tuition)"];

Check the code if valid or invalid

Group of answer choices

Invalid

Valid

Valid

Complete the syntax: mysql_result($result_query,row,______)

Group of answer choices

Location

Field

Query

Type

Field

checking if it is a directory

Group of answer choices

is_dir()

is_directory()

check_directory()

check_dir()

is_dir()

syntax for accepting a file resource and a string, and then writes the string to the file

Group of answer choices

filewrite("$file","text")

writefile("$file","text")

fwrite("$file","text")

writef("$file","text")

fwrite("$file","text")

array you can upload files from a client computer to the remote server.

Group of answer choices

$_UFILE

$_FILEUP

$_FILES

$_UPFILE

$_FILES

Syntax to read a file per character

Group of answer choices

charget("$file")

fgetc("$file")

fcahrget("$file")

getfc("$file")

fgetc("$file")

used to close a file

Group of answer choices

closef()

closefile()

fclose()

fileclose()

fclose()

$query = mysql_query("SELECT name FROM tblinfo");

$fetch = mysql_result($query, 2);

In this code it will get the name of what row?

Group of answer choices

1st

4th

3rd

2nd

3rd

Checking if it is a file

Group of answer choices

check_file()

file_valid()

is_file()

file_check()

is_file()

is used to open a file for reading, writing or appending content

Group of answer choices

openf()

openfile()

fileopen()

fopen()

fopen()

Determining the file size

Group of answer choices

is_filesize()

filesize()

check_filesize()

filesize_check()

filesize()

The result resource that is being evaluated. This result comes from a call to mysql_query().

Group of answer choices

Table

$result_query

Field

Row

$result_query

mysql_result() retrieves the contents of one cell from a MySQL result set

Group of answer choices

False

True

True

The name or offset of the field being retrieved.

Group of answer choices

Field

Row

Table

$result_query

Field

Syntax for attempts to create an empty file

Group of answer choices

empty("$file")

attempt("$file")

touch("$file")

create("$file")

touch("$file")

The row number from the result that's being retrieved. Row numbers start at 0.

Group of answer choices

Row

$result_query

Field

Table

Row

get the number of affected rows by the last SELECT, INSERT, UPDATE, REPLACE or DELETE query.

Group of answer choices

mysql_affected()

mysql_rows_affected()

mysql_rows()

mysql_affected_rows()

mysql_affected_rows()

$query = mysql_query("SELECT MAX(tuition) FROM tblinfo");

$fetch = mysql_result($query,0);

Echo $fetch

Check the code if valid or invalid

Group of answer choices

Invalid

Valid

Valid

Syntax to read a specified set of character in a file

Group of answer choices

readf("$file",1)

cread("$file",1)

sread("$file",1)

fread("$file",1)

fread("$file",1)

Syntax to open a file for reading

Group of answer choices

fopen("test.txt","r")

fileopen("test.txt","r")

openfile("test.txt","r")

openf("test.txt","r")

fopen("test.txt","r")

SQL command to view all records in the table

Group of answer choices

SELECT * FROM

SET * FROM

CHECK * FROM

VIEW * FROM

SELECT * FROM

Command to create a table for the database

Group of answer choices

CREATE DATABASE TABLE

DATABASE CREATE TABLE

CREATE TABLE

TABLE CREATE

CREATE TABLE

Syntax for dropping a column

Group of answer choices

PLUS TABLE tblname DROP

ADD TABLE tblname DROP

ALTER TABLE tblname DROP field

MODIFY TABLE tblname DROP

ALTER TABLE tblname DROP field

Regular Expression Meta characters Symbol for group elements

Group of answer choices

[]

{}

""

()

()

the session_destroy() statement does not affect the variables set on the current page

Group of answer choices

True

False

True

Regular Expression pattern modifier for ignore case

Group of answer choices

C

c

i

ic

i

Regular Expression Meta characters Symbol for mark the end of a string

Group of answer choices

&

$

^

*

$

PCRE function starts with

Group of answer choices

pcre_

prc_

prec_

preg_

preg_

Regular Expression Meta characters symbol for any non alpha numeric characters

Group of answer choices

\E

\W

\R

\X

\W

Regular Expression Meta characters symbol for any white-space character

Group of answer choices

\s

\S

\W

\w

\s

Check the code if it is valid or invalid

Group of answer choices

Invalid

Valid

Valid

Regular Expression Meta characters Symbol for matches any single character

Group of answer choices

"

.

'

:

.(dot)

Regular Expression Meta characters Symbol for Boolean OR

Group of answer choices

\

/

?

|

|

$_POST is an associative array of variables passed to the current script via this method

Group of answer choices

HTML POST

XHTML POST

HTTP POST

XML POST

HTTP POST

Regular Expression Meta characters symbol for any alpha numeric character plus underscore. Equals to [A-Za-z0-9_]

Group of answer choices

\r

\w

\e

\x

\w

Regular Expression Meta characters Symbol for zero or more of 'a'

Group of answer choices

a-

a/

a*

a+

a*

an associative array variables passed to the current script via the URL parameters.

Group of answer choices

$_SET

$_POST

$_GET

$_SERVER

$_GET

Regular Expression Meta characters symbol for any non white-space character

Group of answer choices

\w

\s

\S

\W

\S

were used to efficiently search for patterns in a given text.

Group of answer choices

Double Operation

Regular Expression

Double Expression

Regular Operation

Regular Expression

Regular Expression Meta characters Symbol for item range (a,b or c)

Group of answer choices

'abc'

(abc)

[abc]

{abc}

[abc]

What is E in PCRE

Group of answer choices

Expression

Environment

Entity

Enter

Expression

Function used to close the session

Group of answer choices

destroy_session()

session_close()

session_destroy()

close_session()

session_destroy()

Syntax for inserting a value to your table

Group of answer choices

INSERT VALUES (value1, value2, value3, ....);

INSERT INTO

VALUES (value1, value2, value3, ....);

INSERT HERE

VALUES (value1, value2, value3, ....);

INSERT THIS

VALUES (value1, value2, value3, ....);

INSERT INTO VALUES (value1, value2, value3, ....);

MySQL prompts means waiting for the next line of multiple line command

Group of answer choices

->

\>

/>

=>

->

MySQL prompts means waiting for next line, waiting for completion of a comment that began with /*.

Group of answer choices

/*-

/*=

/*:

/*>

/*>

Field data types Storage value of TIME

Group of answer choices

4 Bytes

Varies

1 Byte

Number of bytes specified

4 Bytes

Syntax to display the structure of the table

Group of answer choices

DISPLAY tblname

STRUCTURE tblname

SUMMARY tblname

DESCRIBE tblname

DESCRIBE tblname

He wrote a very lightweight database engine called mSQL

Group of answer choices

David Hughes

David Huges

David Heus

David Hugs

David Hughes

Entries were created by the web server

Group of answer choices

$_SERVER

$_SET

$_GET

$_POST

$_SERVER

Regular Expression Meta characters Symbol for mark the start of a string

Group of answer choices

$

^

&

*

^

PCRE means Perl Compatible Regular Expression

Group of answer choices

False

True

False

Regular Expression Meta characters symbol for any digits equal to [0-9]

Group of answer choices

\d

\D

\N

\n

\d

Go to the MySQL path

Group of answer choices

C:\xampp\mysql\bin\mysql -s root

C:\xampp\mysql\bin\mysql -v root

C:\xampp\mysql\bin\mysql -x root

C:\xampp\mysql\bin\mysql -u root

C:\xampp\mysql\bin\mysql -u root

What is Q in SQL?

Group of answer choices

Queue

Quite

Query

Quantum

Query