PHP Introduction Flashcards

1
Q

A recursive acronym for “PHP: Hypertext Preprocessor” – It is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.

A

PHP: Hypertext Preprocessor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is PHP: Hypertext Preprocessor?

A

PHP is a server-side scripting language
PHP scripts are executed on the server
PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP is open-source software
PHP runs on different platforms (Windows, Linux, Unix, etc.)
PHP is compatible with almost all servers used today (Apache, IIS, etc.)
PHP is FREE to download from the official PHP resource: ww.php.net
PHP is easy to learn and runs efficiently on the server side

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A structured collection of data that is often stored electronically in a
computer system.

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In charge of controlling a database

A

Database Management System (DBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Abbreviated to just database, is the collective term for the data the DBMS, and the applications that are connected to it.

A

Database System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  • Are raw facts
  • Raw data must be formatted for storage, processing, and presentation
  • Are the foundation of information, which is the bedrock of knowledge
  • Building blocks of information
A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  • The result of processing raw data to reveal meaning.
  • Requires context to reveal meaning
  • produced by processing data
  • used to reveal meaning in data
A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  • Accurate, relevant, timely information is the key to good decision making
  • Good decision making is the key to organizational survival
  • Data management: focuses on proper generation, storage, and retrieval of data
A

Analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Practical tools for storing data

A

Databases and Spreadsheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Acts as a conduit between the database and the applications that will use it, enabling users to access, modify, and control how the
data is arranged and optimized. Also makes it easier to monitor and manage databases, enabling a number of administrative tasks like performance tweaking, backup, and recovery.

A

DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the roles of DBMS?

A
  • DBMS is the intermediary between the user and the database
  • DBMS enables data to be shared
  • DBMS integrates many users’ views of the data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Advantages of DBMS

A
  • Improved data sharing
  • Improved data security
  • Improved data access
  • Improved decision making
  • Increased end-user productivity
  • Minimized data inconsistency
  • Better data integration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

An open source relational database management system. It can
operate on any platform and was created and optimized for online applications.

A

MySQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

SQL

A

Structured Query Language, or SQL, is a query language.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly