Computer O-net Examination Example(Unfinished)

O-net Examination - Year 2008 (Unfinished)

*Red choices is correct answer*

1. Which is not the application on "Smartphone"?
a. Ubumtu
b. iphone os
c. Android
d. Symbian

2. Which file contain data as a character type?
a. mp3
b. jpeg
c. html
d. movie

3. What does Open Source copyright allow user to do?
(1) Able to use without paying fee for copyright.
(2) Try using it first and pay later if found that it is interesting.
(3) User able to edit a program by himself.
a. (1) and (3)
b. (2) and (3)
c. Only (2)
d. Only (1)

4. One random web board requires...
(1) Users able to do their activities after they've logged in.
(2) Users may post a new comments or reply the old ones.
(3) System will automatically remember all users ID.
In case of designing this database, which is correct?
a. Making user table, comment table, and reply table.
b. No need of making user table despite of able to record user in comment and reply tables.
c. Making user and comment tables, whereas reply table already placed in comment table.
d. No need of making comment table as it's already recorded in user table.

5. What is the central processing unit of Computer?
a. Moniter
b. CPU
c. Speaker
d. Program

6. Which is the right behavior when researching information for assignment?
a. Copy it all from website.
b. Use information from web board for assignment.
c. Take images from website.
d. Give credit to the owner.

7. To hold a profession as Website Developer, which Information they must expert and able to do?
(1) Computer Hardware
(2) Operating System
(3) Web Server
(4) html
(5) Database System
(6) Java
a. (1) and (3)
b. (2) and (5)
c. (3) and (4)
d. (3) and (6)

8. The library want to develop book renting system that able to record data on electronic card without writing, which technology should the library use?
a. Smart Card
b. Fingerprint
c. Bar code
d. Wi-fi

9. Which are all wireless technology?
a. Wi-fi, IP
b. Wi-fi, Bluetooth
c. 3G, ADSL
d. 3G, Ethernet

10. Choose the best answer.
a. Recording data in CD is magnetic technology.
b. IP numbers are used with Network Interce Card.
c. Secondary storage is Volntile storage system.
d. ACII and EBCIDIC code that use 8-bit Character code.

11. Which is the smallest unit of Computer?
a. Bit
b. Byte
c. Field
d. Record

12. After the data has been processing, then what do we got?
a. Document
b. Record
c. Information
d. Database

13. Which is the Computer signal?
a. Analog
b. Digital
c. Electronic
d. Electricity

14. What is the file of WinZip?
a. .doc
b. .zip
c. .txt
d. .exe

15. Detail of data that show the property of Entity is?
a. Attribute
b. Relationship
c. Database
d. File

16. Which relationship is not correct?
a. 1:1
b. 1:M
c. M:1
d. M:n

17. To identify the relationship between?
a. One to One
b. One to Many
c. Many to Many
d. Many to One

18. In SQL, after FORM is?
a. Field name
b. Table name
c. Query name
d. All correct

19. In SQL, after SELECT is?
a. All possible
b. Table name
c. Field and Query name
d. None

20. What is the duty of DBMS?
a. Keeping data.
b. Connecting with data manager.
c. Controlling the use of data.
d. All correct.

This exercises is form:
https://krupaga.wordpress.com
http://natchapon21.blogspot.com/

PHP Functions

Standard Functions

is_string()

is_array()

is_bool()

is_float()

is_double()

is_real()

is_int()

is_integer()

is_long()

is_null()

is_numeric()

is_object()

is_scalar()

Typical Number&Math Functions

min()

max()

ceil()

floor()

round()

abs()

log()

log10()

decbin()

decoct()

dechex()

base_convert()

deg2rad()

rad2deg()

pi()

sin()

cos()

tan()

fmod()

bc Math Functions

bcadd()

bcsub()

bcmul()

bcdiv()

bcmod()

bccomp()

bcpow()

bcsqrt()

bcpowmod()

bcscale()

Random Number Functions

rand()

srand()

getrandmax()

mt_rand()

mt_srand()

mt_getrandmax()

Array

array_change_key_case()

array_pad()

array_splice()

array_merge()

each()

current()

pos()

key()

next()

prev()

end()

array_reverse()

unset()

array_pop()

array_push()

array_shift()

array_values()

array_keys()

array_chunk()

array_unshift()

array_unique()

array_count_values()

range()

sizeof()

count()

array_combine()

array_fill()

array_fill_key()

array_flip()

array_intersect()

array_intersect_assoc()

array_intersect_key()

array_walk()

array_walk_recursive()

String Functions

Addcslashes()

Addslashes()

bin2hex()

chop()

chr()

chunk_split()

convert_uuencode()

count_chars()

crc32()

crypt()

explode()

echo()

fprintf()

get_html_translation_table()

html_entity_decode()

htmlentities()

htmlspecialchars_decode()

htmlspecialchars()

implode()

join()

metaphone()

itrim()

rtrim()

trim()

ord()

parse_str()

print()

printf()

Quometa()

sha1()

sha1_file()

lavenshtein()

md5()

md5_file()

similar_text()

soundex()

sprintf()

sscanf()

str_replace()

str_ireplace()

str_pad()

str_repeat()

str_rot13()

str_shuffle()

str_split()

str_word_count()

strcasecmp()

strchr()

stristr()

strcoll()

strcspn()

strip_tags()

stripcslashes()

stripslashes()

strlen()

strnatcasecmp()

strnatcmp()

strncasecmp()

strncmp()

Information from: http://computer.todaygoods.com/php/index.html

Database System(Will upload more later)

(This post is under construction, will upload more soon)

Database System

   Database is information management system that let users able to use information of any work together, without information being complicate, and help user avoid the dissent of those information, also, information in system must be reliable, the same standard, by identify the information security.

   Nowadays, information is known as standard data, can be use to benefit in many ways, whether for business, management and other works.

   Organizations that have large amount of data find it's hard to manage them all, including when it's come to use, so Computer become the equipment for data management since then.

   However, each program must created control and management method itself, so database become necessary, especially for the work systems that need Computer. Therefore, design and development of database system should be about control and management of information using.

What is Database System

   Database System is an information structure that has detail of data, which relating to use along with various system.

   Users can storage data in many ways, therefore, they are able to add, edit, delete and view those data, which mostly are application of Computer system that use for data management.

Definition

- Bit 

   Is the smallest unit.

- Byte

   An unit that added many bits together and then became Character.

- Field

   An unit that consist of more than one characters, then got a meaning of something identity, e.g. name, address, etc.

- Record

   Unit from many field data assemble together, for example, 1 record of student, which content:
1. Student ID; 1 record
2. Student name; 1 record
3. Address; 1 record
- File
   Unit that assemble from many records(with the related data).

Other definition

- Entity
   Is the name of something, for example, people, place, etc.
- Relationships
   Is about relationship of entity, such as, student entity and subject entity.

Relationships between entity

   There are 3 types of relationship between entity.

1. One-to-one relationships (1:1)

2. One-to-many relationships (1:m)

3. Many-to-many relationships (m:n)

Importance of database processing

1. Reduce data redundancy.

2. Avoid data inconsistency.

3. Able to use data together.

4. Keep data reliable

5. Able to set data the same standard

6. Data security

7. Freedom of using data

Type of Databases

1. Relational database

2. Network database

3. Hierarchical database

Popular database program

- Access

- FoxPro

- dBase

- SQL