Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
FA5
| Question | Answer |
|---|---|
| Session are mechanism for storing data on the server itself. Group of answer choices True False | True |
| Regular Expression also known as regex or regexpr Group of answer choices False True | False |
| $_SERVER is an array containing information such as headers, paths, and script locations. Group of answer choices True False | True |
| Regular Expression Meta characters symbol for any non white-space character Group of answer choices \W \w \S \s | \S |
| Regular Expression pattern modifier for pattern is treated as UTF-8 Group of answer choices t U T u | u |
| Regular Expression Meta characters symbol for any digits equal to [0-9] Group of answer choices \d \n \N \D | \d |
| PCRE means Perl Compatible Regular Expression Group of answer choices False True | False |
| Regular Expression is also known as Group of answer choices regex regp rex regx | regex |
| Cookies are mechanism for storing data in the remote browser and thus tracking or identifying return users. Group of answer choices True False | True |
| <form action=”<?php echo $_SERVER[‘PHP_SELF’] ?>” method=”post”></form> Check the code if it is valid or invalid Group of answer choices Valid Invalid | Valid |
| users can refuse to accepts cookies. Group of answer choices False True | True |
| Which of the following code will delete cookies Group of answer choices setcookie(“name1”,”value1”,time()-60); settingcookie((“name1”,”value1” ”,time()-60); cookieset((“name1”,”value1” ”,time()-60); | setcookie(“name1”,”value1”,time()-60); |
| Regular Expression pattern modifier for multiline mode Group of answer choices ML ml M m | m |
| Syntax for setting a cookie Group of answer choices settingcookie() setcookie() cookiesetting() cookieset() | setcookie() |
| What is E in PCRE Group of answer choices Expression Environment Entity Enter | Expression |
| PCRE function starts with Group of answer choices pcre_ prec_ preg_ prc_ | preg_ |
| are mechanism for storing data on the server itself. Group of answer choices Timer Server Session Data | Session |
| Regular Expression Meta characters Symbol for Zero or one ‘a’ character. Equals to a(0,1) Group of answer choices /a ?a a/ a? | a? |
| Performs a regular expression match Group of answer choices prec_match() pcre_match() prc_match() preg_match() | preg_match() |
| Regular Expression Meta characters symbol for any non alpha numeric characters Group of answer choices \R \E \X \W | \W |
| an associative array variables passed to the current script via the URL parameters. Group of answer choices $_GET $_SERVER $_SET $_POST | $_GET |
| Regular Expression Meta characters symbol for exactly two of ‘a’ Group of answer choices a*2 a{2} a+2 a(2) | a{2} |
| Regular Expression Meta characters symbol for between five to ten of ‘a’ Group of answer choices a+5,10 a{5,10} a*5,10 a(5,10) | a{5,10} |
| Regular Expression Meta characters symbol for any non-digits equal to [^0-9] Group of answer choices \d \n \D \N | \D |
| Which of the following will show cookies after 1 minute Group of answer choices settingcookie((“name1”,”value1” ”,time()+60); cookieset((“name1”,”value1” ”,time()+60); setcookie(“name1”,”value1”,time()+60); | setcookie(“name1”,”value1”,time()+60); |
| What is C in PCRE Group of answer choices Computed Computer Compatible Collaborate | Compatible |
| Regular Expression Meta characters Symbol for item range (a,b or c) Group of answer choices {abc} [abc] (abc) ‘abc’ | [abc] |
| Function used to open a session Group of answer choices session_start() session_open() start_session() open_session() | session_start() |
| what is P in PCRE Group of answer choices Present Percl Program Popular | Percl |
| Session is more secure than cookies and can store much more information. Group of answer choices True False | True |
| $_SERVER is an entries created by the Group of answer choices Web server Matrix server Computer server Application server | Web server |
| an associative array of variables passed to the current script via the HTTP method. Group of answer choices $_POST $_SERVER $_SET $_GET | $_POST |
| an associative array of variables passed to the current script via the environment method Group of answer choices $_SESSION $_REQUEST $_ENV $_COOKIE | $_ENV ???? |
| Preg_match() function performs a regular expression match Group of answer choices False True | True |
| Regular Expression Meta characters Symbol for white-space character Group of answer choices \w \c \s \a | \s |
| Regular expression example that will match the word hello Group of answer choices {hello} ‘/hello/’ +hello+ [hello] | ‘/hello/’ |
| You can include time in cookies Group of answer choices True False | True |
| an associative array containing session variables available to the script Group of answer choices $_COOKIE $_ENV $_REQUEST $_SESSION | $_SESSION |
| the session_destroy() statement does not affect the variables set on the current page Group of answer choices True False | True |
| Regular Expression Meta characters Symbol for not in range (every character except a,b or c) Group of answer choices (^abc) ‘^abc’ [^abc] {^abc} | [^abc] |
| Regular Expression Meta characters symbol for any alpha numeric character plus underscore. Equals to [A-Za-z0-9_] Group of answer choices \x \r \w \e | \w |
| $_REQUEST is an associative array that by default contains the contents except Group of answer choices $_COOKIE $_SESSION $_GET $_POST | $_SESSION |
| $_ENV is an associative array containing session variables available to the script Group of answer choices True False | False |
| Regular Expression Meta characters Symbol for Boolean OR Group of answer choices | ? \ / | | |
| Syntax to set Cookies Group of answer choices cookieset((“name1”,”value1”); cookiesetting((“name1”,”value1”); setcookie(“name1”,”value1”); settingcookie((“name1”,”value1”); | setcookie(“name1”,”value1”); |
| Function used to close the session Group of answer choices session_destroy() close_session() session_close() destroy_session() | session_destroy() |
| Entries were created by the web server Group of answer choices $_POST $_SERVER $_GET $_SET | $_SERVER |
| $_GET is an associative array variables passed to the current script via Group of answer choices URL HTTP DIRECTORY LOCATION | URL |
| Cookies are small amount of information containing Group of answer choices value=variable value=string string=value variable=value | variable=value |
| Regular Expression Meta characters symbol for up to five of ‘a’ Group of answer choices a{,5} a*5 a+5 a(5) | a{,5} |
| Use to unset session variables Group of answer choices unset() unsession() uset() usession() | unset() |
| an associative array that by default contains the contents of $_GET, $_POST, and $_COOKIE Group of answer choices $_ENV $_COOKIE $_REQUEST $_SESSION | $_REQUEST |
| Regular Expression Meta characters Symbol for group elements Group of answer choices “” () {} [] | () |
| an associative array of variables passed to the current script via HTTP Cookies Group of answer choices $_ENV $_SESSION $_REQUEST $_COOKIE | $_COOKIE |
| were used to efficiently search for patterns in a given text. Group of answer choices Double Operation Regular Expression Regular Operation Double Expression | Regular Expression |
| $_POST is an associative array of variables passed to the current script via this method Group of answer choices XML POST HTTP POST XHTML POST HTML POST | HTTP POST |
| Regular Expression Meta characters Symbol for mark the start of a string Group of answer choices & ^ * $ | ^ |
| Syntax to display cookies Group of answer choices print_r($_COOKIE) show($_COOKIE) view($_COOKIE) display($_COOKIE) | print_r($_COOKIE) |
| Regular Expression pattern modifier for ignore case Group of answer choices c C i ic | i |
| PCRE function starts with prg_ Group of answer choices True False | False |
| <form action=”<?php echo $_SERVER[‘PHP_SELF’] ?>” method=”get”></form> 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 “ : . ‘ | . |
| Regular Expression Meta characters Symbol for mark the end of a string Group of answer choices $ ^ & * | $ |
| managing cookies can be done using function Group of answer choices settingcookie() setcookie() cookieset() cookiesetting() | setcookie() |
| $_SESSION is an associative array of variables passed to the current script via the environment method Group of answer choices True False | False |
| Regular Expression Meta characters Symbol for zero or more of ‘a’ Group of answer choices a- a+ a* a/ | a* |
| session_start() is always set at the end of each web page Group of answer choices True False | False |
| Sample name of a session $_SESSION[‘myname’]; Check the code if it is Valid or Invalid Group of answer choices Valid Invalid | Valid |
| Regular Expression Meta characters Symbol for one or more of ‘a’ Group of answer choices a$ a+ a* a^ | a+ |
| are mechanism for storing data in the remote browser and thus tracking or identifying return users. Group of answer choices Remote Cookies Session Variable | Cookies |
| contains the filename of the currently executing script. Group of answer choices PHP_MINE PHP_SELF SELF_PHP MY_PHP | PHP_SELF |
| Syntax to unset session variables Group of answer choices uset($_SESSION[‘varname’]) unset($_SESSION[‘varname’]) usession($_SESSION[‘varname’]) unsession($_SESSION[‘varname’]) | unset($_SESSION[‘varname’]) |
| What is R in PCRE Group of answer choices Robust Regular Relay Rest | Regular |
| Regular Expression Meta characters symbol for any white-space character Group of answer choices \s \w \W \S | \s |
| $_COOKIE is an associative array of variables passed to the current script via Group of answer choices HTML XML XHTML HTTP | HTTP |
| Syntax to unset session variables Group of answer choices unset($_SESSION[‘varname’]) uset($_SESSION[‘varname’]) usession($_SESSION[‘varname’]) unsession($_SESSION[‘varname’]) | unset($_SESSION[‘varname’]) |
| session_destroy() gets rid of all the session variable information that’s stored in the session file Group of answer choices True False | True |
| session_start() is always set at the end of each web page Group of answer choices False True | False |
| <form action=”<?php echo $_SERVER[‘PHP_SELF’] ?>” method=”get”></form> Check the code if it is valid or invalid Group of answer choices Valid Invalid | Valid |
| ______________________________________________________ | ____________________________________________________ |
| Syntax for creating a database Group of answer choices DATABASE <dbname> CREATE; CREATE <dbname> CREATE; CREATE DATABASE <dbname>; DATABASE CREATE <dbname>; | CREATE DATABASE <dbname>; |
| Command to display the list of table Group of answer choices tables SHOW SHOW tables SHOW DATABASE tables DATABASE SHOW tables | SHOW tables |
| Syntax for showing database Group of answer choices DATABASE SHOW <dbname>; SHOW DATABASE <dbname>; SHOW <dbname>; <dbname> SHOW; | SHOW <dbname>; ????????? |
| Command to use database Group of answer choices USE USEDB DBUSE THISDB | USE |
| Command in MySQL to quit Group of answer choices \quit \q -quit -q | \q |
| INSERT INTO tblinfo (id,name) VALUES (1003,’Henry’); Check the SQL command if valid or invalid Group of answer choices Invalid Valid | Valid |
| He wrote a very lightweight database engine called mSQL Group of answer choices David Hugs David Huges David Hughes David Heus | David Hughes |
| MySQL prompts means waiting for next line, waiting for completion of a string that began with single quote(‘’’) Group of answer choices ‘> S> “> Q> | ‘> |
| According to the article of Ian Gilfillan in 2004, the following are the claimed features of MySQL except Group of answer choices High cost High scalability High performance High availability | High cost |
| Command to display the SQL version Group of answer choices Select version(); Get version(); View version()l See version(); | Select version(); |
| SQL database improvement was done by a Swedish programmer Group of answer choices Molly Widenius Monty Wilnius Monty Widenius Molly Wilnius | Monty Widenius |
| Open-sourced commercial products Group of answer choices MySQL InterBase PostgreSQL QueryBase | QueryBase ??? |
| Command for inserting a value to your table Group of answer choices INSERT INSERT HERE INSERT THIS INSERT INTO | INSERT INTO |
| Syntax for using database Group of answer choices DATABASE USE <dbname>; USE DATABASE <dbname>; <dbname> USE; USE <dbname>; | USE <dbname>; |
| Command to add new column Group of answer choices ADD MODIFY CHANGE SET | ADD |
| is an array containing information such as headers, paths, and script locations. Group of answer choices $_GET $_SET $_POST $_SERVER | $_SERVER |
| What is R in PCRE Group of answer choices Robust Rest Relay Regular | Regular |
| Syntax for inserting values in a specific column Group of answer choices INSERT VALUES <table name> (column name) VALUES (value); INSERT TO <table name> (column name) VALUES (value); INSERT INTO <table name> (column name) VALUES (value); | INSERT INTO <table name> (column name) VALUES (value); |
| Command in MySQL to display today’s date and time Group of answer choices Select date() Select time() Select date_time() Select now() | Select now() |
| Syntax for deleting a column Group of answer choices DROP FROM <table name> WHERE <column name> = <value>; DELETE FROM <table name> WHERE <column name> = <value>; REMOVE FROM <table name> WHERE <column name> = <value>; | DROP FROM <table name> WHERE <column name> = <value>; ?? |
| Field data types Storage value of DOUBLE Group of answer choices Varies 1 Byte 4 Bytes Number of bytes specified | Varies ?? |
| Field data types Storage value of CHAR Group of answer choices Varies 4 Bytes 1 Byte Number of bytes specified | Number of bytes specified ?? |
| Command in MySQL to display the current user Group of answer choices View user(); Set user(); Select user(); Get user(); | Select user(); |
| Field data types Storage value of DATE Group of answer choices Number of bytes specified 1 Byte Varies 4 Bytes | 4 Bytes ?? |
| Command in MySQL to reconnect to the server Group of answer choices \g \r \s \c | \r |
| What is L in DML? Group of answer choices Latency Logic Location Language | Language |
| Either as outgrowths of earlier academic research Group of answer choices PostgreSQL InterBase MySQL QueryBase | PostgreSQL |
| Syntax to change field names Group of answer choices MODIFY TABLE tblname CHANGE field char(1) PLUS TABLE tblname CHANGE field char(1) ADD TABLE tblname CHANGE field char(1) ALTER TABLE tblname CHANGE field char(1) | ALTER TABLE tblname CHANGE field char(1) |
| Syntax for updating the records Group of answer choices UPDATE <table name> SET <column name> = <value> WHERE <column name> = <value>; RETRIEVE <table name> SET <column name> = <value> WHERE <column name> = <value>; | UPDATE <table name> SET <column name> = <value> WHERE <column name> = <value>; |
| Send comment to mysql server Group of answer choices \g \c \m \s | \g ?? |
| What is S ins SQL? Group of answer choices Structured Start Single System | Structured |
| is the time that a user spends at your Web site. Group of answer choices Data Timer Server Session | Session |
| $_REQUEST is an associative array that by default contains the contents except Group of answer choices $_GET $_POST $_SESSION $_COOKIE | $_SESSION |
| Sample name of a session $_SESSION[myvalue]; Check the code if it is Valid or Invalid Group of answer choices Valid Invalid | Invalid |
| Type of Field data types that range of Fixed length string between 0 to 255 characters Group of answer choices TIME VARCHAR CHAR DATE | CHAR |
| Command to create a database Group of answer choices BEGIN START CREATE MAKE | CREATE |
| Type of Field data types that has a small number with a floating decimal point. Group of answer choices INT DOUBLE FLOAT BOOL | FLOAT |
| Syntax to display the structure of the table Group of answer choices STRUCTURE tblname SUMMARY tblname DESCRIBE tblname DISPLAY tblname | DESCRIBE tblname |
| One important aspect of database management is its querying capability. Group of answer choices False True | True |
| Stores information across multiple related tables. Group of answer choices Table relation Database relation Relational table Relational Database | Relational Database |
| MySQL prompts means waiting for the next line of multiple line command Group of answer choices /> -> \> => | -> |
| Which of the following is not Command help in MySQL Group of answer choices ? Gethelp \? \h | Gethelp |
| Field data types Storage value of TIME Group of answer choices Number of bytes specified 1 Byte Varies 4 Bytes | Varies |
| Command in MySQL to display the current date Group of answer choices View current_date(); Get current_date(); Select urrent_date(); Set current_date(); | Select urrent_date(); |
| To open a console go to the command window start/run then type Group of answer choices Set Command Begin Start | Command |
| Is a structured set of instructions and criteria for retrieving, adding, modifying, and deleting database information. Group of answer choices Structured Foreign key Normalization Query | Query |
| Command getting status from the server Group of answer choices \g \s Stat Getstat | \s |
| are the individual categories of information stored in a record. Group of answer choices Tables Names Database Fields | Fields |
| MySQL prompts means waiting for next line, waiting for completion of a comment that began with /*. Group of answer choices /*- /*= /*> /*: | /*- |
| Command to change field names Group of answer choices MODIFY SET ADD CHANGE | CHANGE |
| MySQL prompts means waiting for next line, waiting for completion of a string that began in double quote(‘’’) Group of answer choices “> ‘> S> Q> | “> |
| Type of Field data types that -2147483648 to 2147483647 Group of answer choices DOUBLE FLOAT BOOL INT | INT |
| Field data types Storage value of BOOL Group of answer choices 1 Byte 4 Bytes Varies Number of bytes specified | 1 Byte |
| Is a field in a related table that refers to the primary key in a primary table. Group of answer choices Foreign key Normalization Primary table Primary key | Foreign key |
| Type of Field data types that range of Variable length string between 1 to 65,535 characters Group of answer choices CHAR TIME VARCHAR DATE | VARCHAR |
| Developments of lightweight storage tools for websites Group of answer choices PostgreSQL InterBase QueryBase MySQL | MySQL |
| mSQL was distributed as shareware Group of answer choices False True | True |
| You can insert a values in a specific column Group of answer choices True False | True |
| Command to view your table Group of answer choices CHECK VIEW SELECT SET | SELECT |
| Command for deleting a column Group of answer choices DELETE DROP REMOVE CROSSOUT | DROP (pero mali sa canvas) |
| Syntax for creating a table Group of answer choices CREATE TABLE tblname(id int(5) primary key not null auto_increment,name char(25)); TABLE CREATE tblname(id int(5) primary key not null auto_increment,name char(25)); | CREATE TABLE tblname(id int(5) primary key not null auto_increment,name char(25)); |
| Syntax for inserting a value to your table Group of answer choices INSERT INTO <table name> VALUES (value1, value2, value3, ....); | INSERT INTO <table name> VALUES (value1, value2, value3, ....); |
| contains the filename of the currently executing script. Group of answer choices MY_PHP PHP_MINE SELF_PHP PHP_SELF | PHP_SELF |
| PCRE function starts with prg_ Group of answer choices True False | False |
| MySQL is portable Group of answer choices True False | True |
| What is L in SQL? Group of answer choices Language Latency Logic Location | Language |
| mSQL short for Group of answer choices Master SQL might SQL Mono SQL mini SQL | mini SQL |
| Command to delete a table Group of answer choices REMOVE DROP CROSSOUT DELETE | DROP |
| Go to the MySQL path Group of answer choices C:\xampp\mysql\bin\mysql -v root C:\xampp\mysql\bin\mysql -x root C:\xampp\mysql\bin\mysql -s root C:\xampp\mysql\bin\mysql -u root | C:\xampp\mysql\bin\mysql -u root |
| Information stored in computer databases is actually stored in Group of answer choices Tables Fields Memory Cells | Tables |
| MySQL compiles using Group of answer choices GUN gcc GNU ggc GNU gcc GUN ggc | GNU gcc |
| Regular Expression pattern modifier for extra analysis of pattern Group of answer choices s e E S | e |
| A single complete set of related information. Group of answer choices Database Record Tables Fields | Record |
| Command to clear in MySQL Group of answer choices Del \d Cls \c | \c |
| SQL command to view all records in the table Group of answer choices VIEW * FROM <table name> SET * FROM <table name> CHECK * FROM <table name> SELECT * FROM <table name> | SELECT * FROM <table name> |
| MySQL is written in Group of answer choices C++ Ruby Java C language | C language ?? |
| Is a field that contains a unique identifier for each record in a primary table. Group of answer choices Primary key Foreign key Normalization Primary table | Primary key |
| Is the process of breaking tables into multiple related tables to reduce redundant information. Group of answer choices Normalization Foreign key Primary table Primary key | Normalization |
| database that stores information in a single table. Group of answer choices Round-file Single-file Flat-file Multi-file | Flat-file |
| MySQL is written in Group of answer choices Java C++ C language Ruby | C++ |
| SQL has a standard data manipulation language among many database management system. Group of answer choices True False | True |
| Type of Field data types that has a large number with a floating decimal point. DOUBLE FLOAT | FLOAT |
Created by:
powerupzzz