Prelim exam

It is a configuration file that is used for configuration of site-access issues, such as URL
redirect, URL shortening, Access-security control.

Htaccess

Data Access Layer or Persistence Layer of the MVC Layered Architecture.

Structure

The default file extension for PHP file is ".php"

True

.htaccess file that will automatically route the index.php next to the Controller

True

Defines a multi-line text input control.

//< textarea > tag
Query Builder class method that inserts record on the database.

$this->db->insert()
URI stands for Uniform Resource Identity

False

PHP runs on various platforms operating system such as apache and IIS.

False

The function of ci code to return a URI segment

$this->uri->segment
The function or ci code to load a view.

$this->load->view

PDO stands for Personal Data Objects.

False

_construct() method executes when a class is created or instantiated.

True

It is the Data Access Layer or Persistence Layer of the MVC Layered Architecture.

Structure
CI function code to load a Model class.

$this->load
variables are just like session variables except it is only available on the next request.

Flashdata

Form Helper method or code to return an HTML button.

form_button()

The function or ci code to show or call the client-side "non-existing page" error

show_404()

Meaning of URL.

Uniform Resource Locators

CI function code to load the database class.

$this->load->database();

Who is the inventor of PHP?

Rasmus Lerdorf

What functionality was added to PHP 5.1 as interface for accessing databases?

PDO
It is a URI Component that serve as persistent, location-independent identifiers

URN
Year that PHP was officially called Personal Home Page Tools.

1995
Form Helper method or code to return an HTML radio input type
form_radio()

It is a URI Component that locates the path or address.

Root address

PHP varianbles start with what symbol?

Originally, PHP is known as "Personal Home Pages"

False
CI method or code to set an error message in form validation.
$this->form_validation->set_message()

To load the view, the function is like this: $this->load->view('name');

False

php.org is the official php resource.

False

are function that is passed to another function and takes this "other function" as a
parameter

callback

will be loaded by the controller passing the returned data from the model.
callbacks

A vital part of a website or system UI because it accepts inputs as data parameters

Forms

Meaning of URN

Controller

Form Helper method or code to return an HTML text input type.

form_input()

Data Access Layer or Persistence Layer of the MVC Layered Architecture.

Uniform resource name

Form Helper method or code to return an HTML radio input type

form_radio()

Defines a multi-line text input control.

//< textarea > tag

It is a line that is not read/executed as part of the program.

Comment

PHP version that enabled the filter extension by default Native JSON default

5.2
The first URI segment

Controller

What do you call the 3rd, 4th segment of the URI?

Parameters

Element represents a control that presents a menu of options.

HTML select
row_array() fetch the data as a single row and result_array() fetch the data as a multi-
dimensional array.

True

Element can be placed onto a web page in a pre-checked fashion by setting the checked
attribute.

Checkbox
.htaccess file that will automatically route the index.php next to the Controller

True

PHP 3 was released in 1998.

True

What is the meaning of URL?

Uniform Resource Locator

Year that PHP was officially called Personal Home Page Tools.

1995

PHP development began in 1995.

False

It is a URI Component that serve as persistent, location-independent identifiers

URN
Andi Gutmans was the inventor of PHP.
False

Can hold an unlimited number of characters, and the text renders in a fixed-width font.
TextArea

URI stands for?

Uniform Resources Identifier

CI method or code to load the form validation library.

$this->load->library('form_validation')

functions to help you build your form easier and faster.

Model

CI method or code to set an error message in form validation.

$this->form_validation->set_message()

Year that PHP 3 was released

1998
CI file directory where the database configuration settings and database groups is found.
Application/config/database.php

HTML is a requirement in Code igniter

True
A thing that shares a common attribute.
Entity Class

Who is responsible in administering the primary and secondary resource in the database?
database administrator (DBA)

It is a question or an inquiry, sometimes loosely used for all types of interactions with
databases.
Query

People whose jobs require access to the database for querying, updating, and generating
reports.
End Users

Physical data models is a concept that shows how the data is stored on the computer.

True
A displayed schema is called Schema figure.

False

It is between high-level and low-level data models.

Representational or Implementation Data Models
Data model is a collection of concepts that is used to describe the structure of a database.
True

Attribute is a name for a set of similar things that you can list. Like objects, events, people.

False

Internal Level describes the physical storage structure of the database.

True
Facts that can be recorded and that have implicit meaning.
Data

Level of database design use to create database.

Physical Design

It is a collection of related data.

Database

Entity Instance is an instance of a particular entity.

True
An attribute that has a multiple value.
Multi-Value Attribute

Composite Attribute can be calculated from other attributes.

False

It describes how entities are related to each other.

Relationship

There’s no difference between the description of database and the database itself.

False

Attribute describes an entity class.

True

A computerized system that permits users to create and maintain a database.

Database Management System

Database System automatically takes care of backup and recovery.

True
Controlling Redundancy is used to improve the performance of queries.
True

They are liable for identifying the data to be stored within the database and for
selecting appropriate structures to represent and store this data.
Database Designers

Is an instance of a particular entity.

Entity Instance

For each entity instance the value of the identifier attribute is Unique.

True

Entity Relationship Diagram (ERD) was proposed by

Dr. Peter Chen

We call the database and DBMS software together as a

database system

Logical Design – transforming the ERD into relational model.

True

Composite attribute can be divided into more attributes

. True

Display a form to be fill out by the user.

Form based interface

Used to manage data within the object schema.

Data Manipulation Language

Like Web search engines (engine like Google), which the user can specify a string or any
keywords and expect to get a relevant result.
Keyword based database search

The interface presents a menu that lead to a user through request.

Menu based interfaces for web clients web or browsing

The interface allows users to access their data through their mobile phone or mobile
device.
Applications for mobile devices
Used to performed or rollback the changes that we made in the database using DML
commands.
Transaction control language

Used for creating tables, schema etc. in database.

Data definition language

Used to give or control privilege in a database.

Data control language

Describes how entities are related.

Relationships

Data abstraction is the data type, relationships and constraints that apply to the data.
False

Data Manipulation Language is use for manipulating data in a database.

True