CS 3305 - AY2020-T2

True or False: After installation osCommerce automatically runs on SSL or https. Select one: True False

False

True or False: Drupal can use filters to compress JS, CSS, and BMP files. Select one: True False

False

True or False: Drupal cannot be used for large organizations. Select one: True False

False

True or False: Drupal modules cannot be abandoned by their creators. Select one: True False

False

True or False: PHP can not generate images, which are different each time a user visits the page. Select one: True False

False

True or False: Source code can be executed. Select one: True False

False

True or False: When using the POST method, variables are displayed in the URL. Select one: True False

False

PHP can generate PDF files based on database data, which is useful in creating reports. Select one: True False

True

True or False: Apache is called httpd on a Linux server. Select one: True False

True

True or False: Drupal allows multilingual support. Select one: True False

True

True or False: Drupal can be used at small organizations. Select one: True False

True

True or False: Drupal can store files, which are then available to visitors for download. Select one: True False

True

True or False: Drupal modules support collaboration over competition. Select one: True False

True

True or False: In PHP you can use both single quotes ( ' ' ) and double quotes ( " " ) for strings. Select one: True False

True

True or False: Most of the web sites today are Web 2.0. Select one: True False

True

True or False: PHP generated PDF files can use custom fonts. Select one: True False

True

True or False: Server-side programming allows users to login to web sites and generate content each time the page is visited. Select one: True False

True

True or False: Server-side programming uses some of the same languages as client-side (workstation) programming. Select one: True False

True

True or False: Software can be compiled at the command prompt. Select one: True False

True

True or False: osCommerce integrates with PayPal. Select one: True False

True

True or False: osCommerce web site offers an online demo of the software. Select one: True False

True

True or False:The PHP syntax is similar to many languages including C++ and Java, which makes it easy to learn for programmers: Select one: True False

True

Given that a database table has a field called FirstName, which code displays an element or field from the database record? Select one: a. echo $row['FirstName']; b. show $row['name']; c. echo $row[name]; d. echo $row(name);

a.

How do you get information from a form that is submitted using the "get" method? Select one: a. $_GET[]; b. Request.Form; Incorrect c. Request.QueryString; d. .getParameter();

a.

The basic Drupal element is: Select one: a. a node b. a template c. user permissions d. data

a.

The first step in the installation of osCommerce is: Select one: a. download the source files b. unzip the files into htdocs directory c. follow the installation URL in your browser Incorrect d. configure the web store by providing database connectivity and other details

a.

The full name of the e-commerce shop installed during our lab is: Select one: a. osCommerce Online Merchant v2.3 b. osCommerce c. Drupal d. v2.3.4 Full Package

a.

The speed of writing server code is increased when: Select one: a. The developer receives immediate feedback upon making changes b. The software is compiled before it is executed c. The developer uses discussion forums to debug code d. The software interpreted and error reporting is turned off

a.

What PHP function allows a connection to MySQL database: Select one: a. mysql_connect(); b. get_connection(); c. connect() d. mysql_db_connection()

a.

What command extracts a tarball archive file? Select one: a. tar -xzvf b. tar -czvf c. tar -out d. tar -v

a.

What does PHP stand for? Select one: a. PHP: Hypertext Preprocessor b. Private Home Page c. Personal Home Page d. Personal Hypertext Processor

a.

What feature of Drupal allows administrators to customize the system and make it do new things? Select one: a. modules b. plugins c. PHP development d. coDrupal

a.

What is the name given to Internet technologies supporting user collaboration and data exchange? Select one: a. Web 2.0 b. SQL Server c. Mobile technology d. Android

a.

What program can be used on a Windows computer to access a command prompt on a Unix/Linux server? Select one: a. putty.exe b. SQL Server c. cmd d. Internet Explorer

a.

What systems allow efficient web site management? Select one: a. CMS b. LMS c. ERP d. CRM

a.

Drupal API stands for: Select one: a. At Program Interface b. Application Programming Interface c. All Programming Initiatives d. Application Primary Incentive

b.

Drupal supports what kind of modules? Select one: a. Simple b. Core c. Basic d. Template

b.

Given the PHP code: $row=mysql_fetch_array($r); What type of variable is $row ? Select one: a. string b. array() c. integer d. boolean

b.

How do you write "Hello World" in PHP? Select one: a. Document.Write("Hello World"); b. echo "Hello World"; c. "Hello World" d. system.out.println("Hello World");

b.

Select an example of a server-side programming language: Select one: a. JavaScript b. Perl c. HTML d. CSS

b.

The PHP syntax is most similar to: Select one: a. JavaScript Incorrect b. Perl and C c. HTML d. CSS

b.

The server requirements for osCommerce v2.3.4 are: Select one: a. PHP v3+ and MySQL v3+ b. PHP v4+ and MySQL v3+ c. PHP v5+ and MySQL v5+ d. PHP v7+ and MySQL v5+

b.

What PHP function sets the database name to be used out of all the databases installed on the given server? Select one: a. mysql_get_db() b. mysql_select_db() c. mysql_set_db() d. mysql_select( )

b.

What are advantages of scripted applications over compiled applications? Choose all that apply. Select one or more: 1. performance 2. readability 3. maintainability 4. functionality a. 1,3 b. 2,3 c. 2,4 d. 1,2,3,4

b.

What commands can be used on a Linux server? Select one or more: 1. putty.exe 2. ls 3. make 4. Click on Start button a. 1, 4 b. 2, 3 c. 1 d. 2

b.

What directory contains configuration files in osCommerce? Select one: a. config b. includes c. admin d. catalog

b.

What feature of Drupal makes the look of the system flexible? Select one: a. artwork b. themes c. graphics d. design

b.

What is the correct way to create a function in PHP? Select one: a. new_function myFunction() b. function myFunction() Correct c. create myFunction() d. create myFunction(function)

b.

What is the most common extension for a source code package? Select one: a. .zip b. .tgz c. .txt d. .os

b.

What language is Drupal written in? Select one: a. ASP b. PHP c. C++ d. Java

b.

What license is expected for contributed modules? Select one: a. Apache b. GPL c. PHP d. Commercial

b.

What major organization runs Drupal as their CMS? Select one: a. facebook.com b. whitehouse.gov c. amazon.com d. oracle.com

b.

What parameters are needed to connect to a database? Select all that apply. Select one or more: 1. db version 2. host name 3. user 4. database name a. 123, b. 23, c. 14 d. 4,2,3

b.

What section of the osCommerce web site helps you to find reported problems in the software? Select one: a. GitHub b. Bug Reports c. Live Shops d. Add-Ons

b.

Which PHP function issues a command or query to the database? Select one: a. my_query() b. mysql_query() c. mysql_query_db() d. sqli_query() Feedback

b.

Which database in the list is Open Source? Select one: a. SQL Server b. MySQL c. Oracle d. Apache

b.

Which system is an example of an Open Source database? Select one: a. SQL Server b. MySQL c. Oracle d. Apache

b.

You can download the development version of osCommerce from: Select one or more: a. sf.net b. GitHub c. osCommerce.org d. apache.org

b.

What file types is Drupal distributed in? Check all that apply. Select one or more: 1. php 2. .tgz 3. .zip 4. .txt a. 1,3 b. 4,1 c. 2,3 d. 1,2

c

Drupal supports what kind of modules? Check all that apply. Select one: a. Visible b. Contributed c. Custom d. Text

c.

Identify a valid PHP variable: Select one: a. x b. x$ c. $x d. $x$

c.

What is the correct way to add 1 to the $count variable? Select one: a. $count =+1 b. ++count c. $count++; Correct d. count++;

c.

PHP script can perform the following functions: Select one: a. Generate an email to one or more receipients. b. Insert data into a database c. Display data from a database d. All of the above

d.

What Linux command downloads source code? Select one: a. mput b. get c. Internet Explorer d. wget

d.

What are examples of a scripted language? Choose all that apply. Select one or more: 1. C++ 2. PHP 3. Perl 4. Objective-C a. 2,3,4 b. 1, 3,4 c. 3,4 d. 2,3

d.

What feature allows users to modify content in Drupal? Select one: a. interoperability b. integration c. integer d. authentication

d.

What is a correct way to add a comment in PHP? Select one: a. <comment> </comment> b. <!-- --> Incorrect c. *\ *\ d. /* */

d.

What is a current version of Drupal? Select one: a. 4.x b. 5.x c. 6.x d. 7.x

d.

What is a good example of static Internet content? Select one: a. CNN news page b. Yahoo home page c. Facebook Wall d. None of the above

d.

What parameters are required in the PHP function, which issues a command or query to the database? Select one: a. number b. boolean c. integer d. string

d.

osCommerce can be installed on your own server, which means it is: Select one: a. hosted b. online c. cloud hosted d. self-hosted

d.