Wednesday, April 30, 2008

Boleh Nyontek Kartu Ucapan Lebaran

Mawar berseri dipagi hari
pancaran putihnya menyapa nurani
sms dikirim pengganti diri
SELAMAT IDUL FITRI
MOHON MAAF LAHIR BATHIN
Sebelum Ramadhan pergi
Sebelum Idul fitri datang
Sebelum operator sibuk
Sebelum sms pending mulu
Sebelum pulsa habis
Dari hati ngucapin MINAL AIDZIN WAL FAIDZIN
MOHON MAAF LAHIR DAN BATIN
Jika HATI sejernih AIR, jangan biarkan ia keruh,
Jika HATI seputih AWAN, jangan biarkan dia mendung,
Jika HATI seindah BULAN, hiasi ia dengan IMAN.
Mohon Maaf lahir dan batin
Menyambung kasih, merajut cinta, beralas ikhlas, beratap doa.
Semasa hidup bersimbah khilaf & dosa, berharap dibasuh maaf.
Selamat Idul Fitri
Melati semerbak harum mewangi,
Sebagai penghias di hari fitri,
SMS ini hadir pengganti diri,
Ulurkan tangan silaturahmi.
Selamat Idul Fitri
Sebelas bulan kita kejar dunia,
kita umbar napsu angkara.
Sebulan penuh kita gelar puasa,
kita bakar segala dosa.
Sebelas bulan kita sebar dengki dan prasangka,
Sebulan penuh kita tebar kasih sayang sesama.
Dua belas bulan kita berinteraksi penuh salah dan khilaf,
Di hari suci nan fitri ini, kita cuci hati, kita buka pintu maaf.
Selamat Idul Fitri, mohon maaf lahir dan bati

 

Andai jemari tak sempat berjabat.
Jika raga tak bisa bersua.
Bila ada kata membekas luka.
Semoga pintu maaf masih terbuka.
Selamat Idul Fitri

 

Faith makes all things possible.
Hope makes all things work.
Love makes all things beautiful.
May you have all of the three.
Happy Iedul Fitri.”

 

walopun operator sibuk n’ sms pending terus,
kami sekeluarga tetap kekeuh mengucapkan
Selamat Idul Fitri, mohon maaf lahir dan batin

 

Bila kata merangkai dusta..
Bila langkah membekas lara…
Bila hati penuh prasangka…
Dan bila ada langkah yang menoreh luka.
Mohon bukakan pintu maaf…
Selamat Idul Fitri Mohon Maaf Lahir Batin

 

Fitrah sejati adalah meng-Akbarkan Allah..
Dan Syariat-Nya di alam jiwa..
Di dunia nyata, dalam segala gerak..
Di sepanjang nafas dan langkah..
Semoga seperti itulah diri kita di hari kemenangan ini..
Selamat Idul Fitri Mohon Maaf Lahir Batin

 

Untuk lisan yg tak terjaga
untuk hati yg berprasangka
untuk janji yg tak ditepati
segala kekhilafan. minal aidin walfaizin mhn maaf lahir bathin

 

Waktu mengalir bagaikan air
Ramadhan suci akan berakhir
Tuk salah yg pernah ada
Tuk khilaf yg sempat terucap
Pintu maaf selalu kuharap
Met Idul Fitri 1427 H

 

Walaupun Hati gak sebening XL dan secerah MENTARI.Banyak khilaf yang buat FREN kecewa,kuminta SIMPATI-mu untuk BEBAS kan dari ROAMING dosa dan kita semua hanya bisa mengangkat JEMPOL kepadaNya yang selalu membuat kita HOKI dalam mencari kartu AS selama kita hidup karena kita harus FLEXIbel untuk menerima semua pemberianNYA dan menjalani MATRIX kehidupan ini…dan semoga amal kita tidak ESIA-ESIA…Mohon Maaf Lahir Bathin.

 

Walaupun Hati gak sebening XL dan secerah MENTARI.Banyak khilaf yang buat FREN kecewa,kuminta SIMPATI-mu untuk BEBAS kan dari ROAMING dosa dan kita semua hanya bisa mengangkat JEMPOL kepadaNya yang selalu membuat kita HOKI dalam mencari kartu AS selama kita hidup karena kita harus FLEXIbel untuk menerima semua pemberianNYA dan menjalani MATRIX kehidupan ini…dan semoga amal kita tidak ESIA-ESIA…Mohon Maaf Lahir Bathin

 

Satukan tangan,satukan hati
itulah indahnya silaturahmi
Di hari kemenangan kita padukan
keikhlasan untuk saling memaafkan

 

 

Selamat Hari Raya Idul Fitri 1427 H
Mohon Maaf Lahir Batin

 

Kata telah terucap, tangan telah tergerak, prasangka telah terungkap, Tiada kata, Kecuali “saling maaf” jalin ukhuwah & kasih sayang raih indahnya kemenangan hakiki, Selamat Hari Raya Iedul Fitri 1427 H

 

Selamat Hari …… , marilah kita saling mengasihi n memaafkan…
Ku tau kau telah banyak berbuat salah dan dosa kepadaku, sering meminjam duit n ga ngembaliin, pake motor ga pernah isi bensin, tapi tak usah risau… ku t`lah memaafkanmu…

 

Kata telah terucap, tangan telah tergerak, prasangka telah terungkap, Tiada kata, Kecuali “saling maaf” jalin ukhuwah & kasih sayang raih indahnya kemenanga hakiki, Saya mengucapkan Selamat Hari Raya Iedul Fitri 1427 H

 

” Sepuluh jari tersusun rapi.. Bunga melati pengharum hati .. SMS dikirim pengganti diri… Memohon maaf setulus hati … Mohon Maaf Lahir dan Batin .. Met Idul Fitri …

 

Andai jemari tak smpt berjabat,andai raga tak dpt b’tatap
seiring beduk yg mgema,sruan takbir yg berkumandang
kuhaturkan salam menyambut hari raya idul fitri,jk ada kata serta khilafku membekas lara mhn maaf lahir batin.
SELAMAT IDUL FITRI

 

 

Posted by almo in 15:51:25 | Permalink | Comments (3)

Ichaku lepas entah kemana…………….

Selamat Menempuh Hidup Baru bersama orang yang engkau pilih.

Posted by almo in 15:40:29 | Permalink | Comments Off

Sunday, January 6, 2008

Informasi Terkini

mas admin lagi bingung nich mo publish apaan?

Posted by almo in 17:00:00 | Permalink | Comments (3)

LPMP Semarang

sementara belum bisa di muat seluruhnya karena acara belum selesai
Posted by almo in 15:10:00 | Permalink | Comments Off

Monday, December 17, 2007

CCNA3 Final 2007

English FormE-2b CCNA3 Version3.1 Final – 2007 Fall

 

1.  Refer to the exhibit. The network has converged and Switch_6 has been elected root bridge of the STP tree. However, network traffic analysis indicates that Switch_1 would be a better root bridge. How can the network administrator make this change, assuming that the spanning-tree priorities are at the default settings?

 

Set the bridge priority of Switch_1 to 32,768.

            Set the bridge priority of Switch_6 to 65,565.

            ***Set the bridge priority of Switch_1 to 1.

            Set the bridge priority of Switch_6 to 255.

           

2.   When should EIGRP automatic summarization be turned off?

            when a router has not discovered a neighbor within three minutes

            when a router has more than three active interfaces

            ***when a router has discontiguous networks attached

            when a router has less than five active interfaces

 

 

 

 

 

 

 

 

 

 

 

3.   Refer to the output in the exhibit. What can be determined from the information shown?

            VTP has been enabled for all ports.

            Hosts in VLAN11 and VLAN22 must have IP addresses in the same subnet in order for them to exchange data.

            Three ports have been assigned to the management VLAN.

            ***ARP requests issued by the host on port Fa0/12 will be seen by all hosts on VLAN33.

 

4.   Refer to the OSPF network in the exhibit. Router R2 has been elected DR, but router R1 is the more powerful router. How can the network administrator configure R1 to force it to be elected as DR?

            R1(config)# ospf priority 1

            R1(config)# ip ospf priority 255

            R1(config)# interface fastethernet 0/0

R1(config-if)# ospf priority 0

            R1(config)# interface fastethernet 0/0

R1(config-if)# ip ospf priority 0

            ***R1(config)# interface fastethernet 0/0

R1(config-if)# ip ospf priority 255

 

5.   Which of the following are attributes of link-state routing protocols? (Choose three.)

            Periodic updates are sent every 120 seconds to neighboring routers.

            Each router sends its entire routing table to neighboring routers.

            ***Routers send updates when a change in the network is detected.

            ***Link-state protocols converge more rapidly than distance vector protocols.

            After convergence, link-state protocols use more bandwidth than distance vector protocols use.

            ***Link-state protocols are less prone to routing loops than distance vector protocols.

 

6.   Refer to the exhibit. What will be the result of DR elections in the OSPF network shown? (Choose three.)

***CTL will be DR of the 172.16.4.0/24 network.

            ID3 will be DR of the 172.16.4.0/24 network.

            ***CTL will be DR of the 172.16.5.0/24 network.

            ID1 will be DR of the 172.16.5.0/24 network.

            ***CTL will be DR of the 172.16.8.0/24 network.

            ID2 will be DR of the 172.16.8.0/24 network.

 

7.   The network administrator shown in the exhibit is connected to an Ethernet LAN port on ACC-1. The administrator needs to verify the configuration of the newly installed switch ACC-3. What must be done so that the administrator can access ACC-3 with a web browser? (Choose three.)

            ***Establish the Layer 3 connectivity of the host to ACC-3.

            Set the password on the management VLAN.

            Configure the hostname on ACC-3.

            ***Activate the HTTP service on ACC-3.

            ***Configure IP addressing parameters on ACC-3.

 

8.   Which of the following tasks must be completed to configure a router interface to serve the newly added network 192.168.10.64/27 and to advertise this network over RIP v2? (Choose three.)

            ***RIP v2 must be configured with the network command and the IP network number for the new network.

            RIP v2 must be configured with the network command and the IP host address and subnet mask for the newly activated interface.

            The router must be configured with the ip subnet-zero command so that this network can be added and advertised.

            ***A network host address and subnet mask must be applied to the newly activated interface.

            ***The routing protocol must be activated with the router rip and version 2 commands.

            RIP v2 must be configured on the other enterprise routers with an entry for the newly added network.

 

9.   Multiple routers have been configured with EIGRP as the routing protocol for use in the corporate network. What is true of the operation of this network? (Choose three.)

            Only link-state protocols will run in the network.

            ***Routing information in the form of partial updates will be sent in response to topology changes.

            ***The network can support multiple routed protocols.

            ***Hello packets are used to discover and verify the status of neighboring routers.

            Routing updates are broadcast to all other routers in the network.

            Routing updates that consist of entire routing tables are sent to neighboring routers.

 

10.   Refer to the graphic. Which of the following commands would be used on the router to provide communication between the two hosts connected to the switch?

            interface vlan 2

ip address 192.168.2.1 255.255.255.0

no shutdown

interface vlan 3

ip address 192.168.3.1 255.255.255.0

no shutdown

            ***interface fastethernet 0/0

no shutdown

interface fastethernet 0/0.2

encapsulation dot1q 2

ip address 192.168.2.1 255.255.255.0

interface fastethernet 0/0.3

encapsulation dot1q 3

ip address 192.168.3.1 255.255.255.0

            interface vlan 2

switchport mode trunk dot1q

interface vlan 3

switchport mode trunk dot11

            interface fastethernet 0/0

mode trunk dot1q 2 3

ip address 192.168.2.1 255.255.255.0

 

11.   Refer to the exhibit. Two Catalyst switches are connected, and both switches have ports configured for the Sales and Marketing VLANs as shown. What will allow hosts on the same VLAN to communicate with one another across different switches?

            STP

            VTP

            routing

            ***trunking

 

12.   Refer to the exhibit. A company always uses the last valid IP address in a subnetwork as the IP address of the router LAN interface. A network administrator is using a laptop to configure switch SW-A with a default gateway. Assuming the switch IP address is 192.168.120.12/24, what command string will the administrator use to assign a default gateway to the switch?

            SW-A(config)# ip gateway 192.168.120.1

            SW-A(config)# ip route 0.0.0.0 0.0.0.0 192.168.120.255

            SW-A(config)# ip route 192.168.120.254 255.255.255.0 fastethernet 0/0

            SW-A(config)# ip default-route 192.168.120.254

            ***SW-A(config)# ip default-gateway 192.168.120.254

 

13.    What is the first step in the spanning-tree process?

            elect a designated switch

            use a router to locate a default gateway

            ***elect a root bridge

            determine the path cost of each active port on the switch

 

14.   What is the first parameter used to determine which switch is selected as the root bridge in a spanning-tree network?

            highest path cost

            highest priority number

            highest Layer 2 address

            ***lowest priority number

            lowest path cost

            lowest Layer 2 address

 

15.   Refer to the exhibit. What is the meaning of the highlighted value of 64 shown in the routing table?

            It is the administrative distance.

            It is the value assigned by the Dijkstra algorithm that designates how many hops are in the network.

            It is the value used by the DUAL algorithm to determine the bandwidth for the link.

            ***It is the metric, which is cost.

 

16.   A new switch has been added to the network and it needs to support error-free switching. Which switching mode should be configured on the new switch?

            cut-through

            fragment-free

            ***store and forward

            auto-sensing

 

17.   Refer to the exhibit. What is the most efficient summarization of the routes attached to router R1?

            198.18.0.0/16

            ***198.18.48.0/21

            198.18.32.0/22

            198.18.48.0/23

            198.18.49.0/23

            198.18.52.0/22

 

18.   A network administrator asked an assistant to remove several VLANs from a switch. When the assistant entered in the no vlan 1 command an error was received. What was the cause of the error?

            VLANs can not be deleted until all ports have been removed from the VLAN assignment.

            VLANs can only be deleted by the user that created them.

            VLAN 1 can not be deleted until another VLAN has been assigned its duties.

            ***VLAN1 is the management VLAN by default and can not be deleted.

            The command was not entered properly, which caused a syntax error to occur.

 

19.   Refer to the exhibit. How many broadcast domains are there in the topology shown, assuming that VLANs are not configured on the switches?

            one

            ***two

            three

            four

            six

            eight

 

20.   What are two of the benefits that switches provide to a network without VLANs configured? (Choose two.)

            They allow creation of permanent virtual circuits.

            They decrease network throughput.

            They shrink the size of broadcast domains.

            ***They help eliminate collision domains.

            ***They allow existing bandwidth to be more efficiently utilized.

 

21.   Refer to the network and command output shown in the exhibit. A network administrator located at the Headquarters site needs to check the configuration of a switch located at the Pacific office. Which command can be used to gain remote access to the Pacific LAN switch, assuming the switch is assigned the IP address 198.19.27.251/24?

            Headquarters# telnet Pacific

            Headquarters# dial Pacific 198.19.27.251

            Headquarters(config)# line vty 0 4

Headquarters(config-line)# telnet Pacific

            ***Headquarters# telnet 198.19.27.251

 

22.   Which three statements describe full-duplex Ethernet? (Choose three.)

            ***It utilizes 100% of the bandwidth in both directions.

            It requires two wires.

            It increases the number of broadcast domains in the network.

            ***It allows data to be received and sent simultaneously.

            ***It reduces the number of collisions.

            It provides between 60% and 80% of the bandwidth in both directions.

 

23.   The following command was added to a router configuration:

 

ip route 172.26.153.0 255.255.255.0 198.19.27.249

What two effects will this command have? (Choose two.)

            It will create a default route using the interface with the IP address 198.19.27.249 as the next hop.

            The route will be marked with an “C” in the routing table.

            ***It will create a static route to the 172.26.153.0/24 network.

            All packets with an unknown destination address will be forwarded to the 172.26.153.0/24 network.

            ***Routes to network 172.26.153.0 that are learned dynamically will not be used to route packets as long as this configuration command is in effect.

 

24.   Refer to the exhibit. Each switch is shown with its MAC address. Which switch will be elected as the spanning-tree root bridge, if the switches are configured with their default priority values?

            Switch_1

            Switch_2

            Switch_3

            Switch_4

            ***Switch_5

            Switch_6

 

25.   Refer to the exhibit. Which configuration commands will direct outbound traffic from Corp_1 to the ISP and inbound traffic from the ISP to network 192.168.1.0/24?

            ***Corp_1(config)# ip route 0.0.0.0 0.0.0.0 serial 0/0

ISP(config)# ip route 192.168.1.0 255.255.255.0 serial 0/1

            Corp_1(config)# ip route 198.19.27.0 255.255.255.0 serial 0/0

ISP(config)# ip route 0.0.0.0 0.0.0.0 serial 0/1

            Corp_1(config)# ip route 0.0.0.0 0.0.0.0 serial 0/0

ISP(config)# ip route 0.0.0.0 0.0.0.0 serial 0/0

            Corp_1(config)# ip route 198.19.27.0 255.255.255.0 serial 0/0

ISP(config)# ip route 192.168.1.0 255.255.255.0 serial 0/1

 

26.   Refer to the exhibit. What is the correct OSPF configuration for router RT-1?

            RT-1(config)# router ospf 1

RT-1(config-router)# network 172.16.21.0 0.0.0.63 area 0

RT-1(config-router)# network 172.16.21.248 0.0.0.3 area 0

            RT-1(config)# router ospf 0

RT-1(config-router)# network 172.16.21.0 0.0.0.3 area 0

RT-1(config-router)# network 172.16.21.248 0.0.0.31 area 0

            ***RT-1(config)# router ospf 1

RT-1(config-router)# network 172.16.21.0 0.0.0.31 area 0

RT-1(config-router)# network 172.16.21.248 0.0.0.3 area 0

            RT-1(config)# router ospf 99

RT-1(config-router)# network 172.16.21.0 255.255.255.224 area 0

RT-1(config-router)# network 172.16.21.248 255.255.255.248 area 0

 

27.   Refer to the exhibit. Router LC-1 needs to be configured to provide communication between the networks shown. Which group of commands will configure EIGRP on LC-1 to work within this network?

            LC-1(config)# router eigrp 1

LC-1(config-router)# network 192.168.43.0 0.0.0.3 area 0

LC-1(config-router)# network 192.168.43.4 0.0.0.3 area 0

LC-1(config-router)# network 192.168.43.128 0.0.0.63 area 0

            LC-1(config)# router eigrp 1

LC-1(config-router)# network 192.168.43.0 0.0.0.3 no-summary

LC-1(config-router)# network 192.168.43.4 0.0.0.3 no-summary

LC-1(config-router)# network 192.168.43.128 0.0.0.192 no-summary

            ***LC-1(config)# router eigrp 1

LC-1(config-router)# network 192.168.43.0

            LC-1(config)# router eigrp 1

LC-1(config-router)# network 192.168.43.0 0.0.0.3

LC-1(config-router)# network 192.168.43.4 0.0.0.3

LC-1(config-router)# network 192.168.43.128 0.0.0.192

 

28.   Employees of XYZ Company connect their laptop computers to the office LAN using Ethernet ports. The Cisco switches used in the company network are configured with port security. At which layer of the three-layer design model do these switches operate?

            physical

            distribution

            data link

            ***access

            core

 

29.   Refer to the graphic. Switch 2 has computers attached that belong to VLAN 2. Switch 3 has computers attached that belong to VLAN 3. Switch 1 is a Cisco 2926G Layer 3 switch that has a route module installed. Switch 1 provides connectivity to the other switches and is used to route between the VLANs. At which layer of the three-layer switch design model does Switch 1 operate?

            physical

            data link

            core

            access

            network

            ***distribution

 

30.   Performance of the network shown in the exhibit has become poor since the addition of hosts to the network. The network administrator suspects that excessive collisions are causing this problem. If the network is using hubs, what should be done to reduce the collisions?

            Add a router to every hub segment.

            Replace hubs with access points.

            ***Replace hubs with switches.

            Add additional hubs.

 

31.   Refer to the exhibit. Which command will remove the static address from the MAC address table on a Cisco 2950 switch?

            VALLYGREEN(config)# no mac-address-table entry 00e0.2917.1884 fastethernet interface 0/4 vlan 1

            VALLYGREEN(config)# no mac-address-table 00e0.2917.1884 fastethernet 0/4

            VALLYGREEN(config-if)# no mac-address-table static 00e0.2917.1884 vlan 1

            ***VALLYGREEN(config)# no mac-address-table static 00e0.2917.1884 vlan 1 interface fastethernet 0/4

32.   Refer to the exhibit. If the exhibited network is running EIGRP, which subnetworks can be assigned to the serial links between LC-1 and the other routers?

            192.168.43.4/30 and 192.168.43.8/30

            192.168.43.32/30 and 192.168.43.160/30

            192.168.43.96/30 and 192.168.43.100/30

            192.168.43.160/30 and 192.168.43.164/30

            ***192.168.43.192/30 and 192.168.43.196/30

 

33.   Which layer of the hierarchical three-layer design model combines traffic from multiple IDFs?

            access

            backbone

            ***distribution

            core

34.   Refer to the graphic. The host on VLAN 2 cannot communicate with the host on VLAN 3. Which of the following could be the problem based on the output of the show interface fastethernet 0/1 command from the switch?

            The switch port 1 is not set to access mode.

            ***The router interface connected to switch port 1 is shut down.

            The router is not configured for trunking.

            The switch port is not configured for full duplex or a speed of 100 Mbps.

 

35.   Which two statements describe the Spanning Tree Protocol? (Choose two.)

            It can only be used in networks in which routers are installed.

            It can only be used in networks in which both routers and switches are used.

            ***It can only be used in networks in which Layer 2 switching is in use.

            ***It eliminates Layer 2 loops in network topologies.

            It eliminates the need for redundant physical paths in network topologies.

 

36. Refer to the exhibit. The link between switches SW-A and SW-B needs to provide connectivity between hosts on the same VLAN across the two switches. How should these ports be configured?

            as data channel ports

            as access ports

            ***as trunking ports

            as root ports

            as inter-VLAN ports

 

37.   What does a constant amber SYSTEM LED indicate on a Catalyst switch?

            The switch is going through POST.

            The switch is in the process of initializing ports.

            ***The switch has failed POST.

            The switch has passed POST and is working properly.

 

38.   For what two reasons would a network administrator choose to enable authentication for OSPF exchanges? (Choose two.)

            ***to prevent routing information from being falsified

            to reduce OSPF information exchange overhead

            to ensure that OSPF routing information takes priority over RIP or EIGRP updates

            to encrypt routing tables to prevent unauthorized viewing

            ***to ensure that routing information comes from a valid source

 

39.   What do EIGRP routers use to establish and maintain adjacency relationships with neighboring routers?

            the exchange of routing tables with directly attached routers

            ***the exchange of hello packets with neighboring routers

            the learning of new routes from neighbors

            the comparison of known routes to information received in updates

            the exchange of neighbor tables with directly attached routers

 

40.   Refer to the exhibit. Which sequence of commands is required to configure switch port Fa0/11 for host A?

            SW-A(config)# interface fastethernet 0/11

SW-A(config-if)# vlan 11

            SW-A(config)# interface vlan 11

SW-A(config-if)# switchport mode trunk

            SW-A(config)# interface vlan 11

SW-A(config-if)# switchport mode access 11

            ***SW-A(config)# interface fastethernet 0/11

SW-A(config-if)# switchport mode access

SW-A(config-if)# switchport access vlan 11

 

41.   Refer to the exhibit. What does “FORWARDING” mean in the command output shown?

            The switch is receiving BPDUs, but not sending data frames.

            The switch is participating in an election process by forwarding the BPDUs it receives.

            ***The switch is sending and receiving data frames.

            The switch is receiving BPDUs and populating the MAC address table, but not sending data.

 

42.   Refer to the exhibit. What is an advantage of this network design?

            It provides multiple paths for Layer 2 broadcasts to circulate through the network.

            It allows spanning tree to forward traffic across redundant paths simultaneously.

            It maximizes the number of ports available for users.

            ***It provides multiple paths for connectivity in the event of link failure.

 

43. Refer to exhibit. Routers Central and Remote are configured using RIPv1. Both routers are sending updates about their directly connected routes. The Central router can ping the Remote router serial interface and Remote can ping the serial interface of Central. However, neither router has dynamically learned routes from the other. What is the most likely problem?

            A clock rate is missing from one of the serial interfaces.

            A gateway of last resort is required.

            Subnets cannot be used with RIPv1.

            ***VLSM is not supported by RIPv1.

 

44.   If a company is using the IP address 172.16.0.0 and wants to create subnets using VLSM, which combination of addresses and masks will be valid?

            172.16.128.0 /18 and 172.16.128.192 /26

            172.16.160.0 /20 and 172.16.168.0 /20

            ***172.16.32.0 /19 and 172.16.64.128 /25

            172.16.192.0 /18 and 172.16.224.0 /19

 

45. Which of the following features do RIPv1 and RIPv2 have in common? (Choose three.)

            ***hop count as a metric

            classless routing

            ***use split horizon

            ***maximum hop count is 15

            broadcast updates

            no authentication

 

46. Which Ethernet switching mode has the least latency and lowest reliability?

            ***fast-forward

            asymmetric

            store-and-forward

            fragment-free

            symmetric

 

47.   Which of the following statements is true when VTP is configured on a switched network that incorporates VLANs?

            VTP is only compatible with the 802.1Q standard.

            VTP adds to the complexity of managing a switched network.

            ***All VTP hello packets are routed through VLAN 1 interfaces.

            Changes made to the VLAN configuration in the domain can be communicated to all switches dynamically.

 

***new questions, 10x to cyberhawk***

20.   What are two benefits that switches, without VLANs configured, provide to a network when compared to a hub? (Choose two.)
They allow creation of permanent virtual circuits.
They decrease network throughput.
They shrink the size of broadcast domains.
***They increase the number of collision domains.
***They allow existing bandwidth to be more efficiently utilized.

 

29.   Which statement is true when VTP is configured on a switched network that incorporates VLANs?
VTP is only compatible with the 802.1Q standard.
VTP adds to the complexity of managing a switched network.
A switch configured for VTP can belong to more than one VTP domain.
***, VTP dynamically communicates VLAN additions, deletions and modifications to all switches in the same VTP domain.

VTP advertisements are passed over access links to other switches.

 

www.inafridge.com – 2006

Posted by almo in 14:19:51 | Permalink | Comments Off

Saturday, December 8, 2007

Contekan CCNA3 Modul 6

Hai temen2 aku dah ngerjain nich CCNA3 Modul 6, nilainya lumayan bagus, cobadeh pake jawaban ini…………….

English FormB CCNA3 Version3.1 Module6 – 2007 fall

 

1.   A group of hosts has been connected to a new Fast Ethernet switch. Which of the following statements describe this newly created LAN, if the new switch has not yet been configured? (Choose three.)
            ***The hosts will negotiate 10 Mbps or 100 Mbps bandwidth with the switch, as required by their NICs.
            The hosts will be in separate broadcast domains.
            ***All of the hosts will be in the same VLAN.
            Hosts with 10 Mbps NICs will be unable to communicate with the network.
            ***All of the hosts should be able to send and receive ARP messages from each other.

            All of the hosts connected by Ethernet can manage the switch over Telnet or HTTP.

 

2.   How can a switch be configured to prevent unauthorized hosts from access to a network? (Choose three.)
            ***Host MAC addresses can be statically assigned to each switch port.
            Layer 2 access control lists can be used to prevent unauthorized network access.
            ***Unused ports can be shutdown.
            Passwords and usernames can be set for each Ethernet switch port.
            Unused switch ports can be assigned to the management VLAN.

            ***Port security can be activated to allow only the host with the first MAC address learned on a port to access the network.

 

3.   An old workstation has been replaced with a new one. The workgroup switch, a Catalyst 2950, is not learning the MAC address of the new workstation. A network technician has verified that a static MAC address is not configured on the attached switch port. Which two commands can the technician issue at the switch CLI to further troubleshoot the problem? (Choose two.)
            ***Switch# show port security
            Switch# show version
            Switch# show startup-config
            ***Switch# clear mac-address-table dynamic
            Switch# reload
            Switch# delete flash:vlan.dat

 

4.   After powering up a switch, the network technician notices that the system LED is amber. What can the technician assume? (Choose two.)
            The switch is negotiating full or half-duplex mode.
            The switch has completed negotiating 10 or 100 Mbps speed.
            ***The POST has failed.
            The boot sequence is in process.
            ***A fatal error has occurred.

            The switch is operating properly and is ready for service.

 

5.   Which switch command mode should always be password protected?
            User Command
            User Config
            User EXEC
            User Privileged

            ***Privileged EXEC

 

6.   Which type of cable is used to connect to the console port on a switch?
            a crossover cable
            a patch cable
            ***a rollover cable

            a straight-thru cable

 

7.   Which files must be deleted in order to completely remove an existing configuration from a Cisco 2950 switch? (Choose two.)
            flash:c2950-c3h2s-mz.120-5-3.WC.1.bin
            running-config
            VLAN.bin
            ***startup-config
            c2950-c3h2s-mz.120-5-3.WC.1.dat

            ***VLAN.dat

 

8.   A workstation on a switched Ethernet LAN is to be upgraded with a new Fast Ethernet NIC. What should be done to ensure that the workstation will be able to gain access to the network?
            delete the configuration file from the switch and reload IOS
            ***deactivate port security on the port until the new host has connected to the network
            remove the host from the the management VLAN until the new MAC address has been learned by the switch
            delete the VLAN.dat file from flash and reboot the switch

            configure the attached switch port for full-duplex mode

 

9.   Which commands can be used to change from Global Configuration mode to Privileged EXEC mode? (Choose three.)
            ***Ctrl+z
            disable
            ***end
            ***exit

            logout

 

10.   Which protocol is used to copy a new IOS image to a Catalyst switch during the upgrade procedure?
            HTTP
            Telnet
            ***TFTP
            TTY

            IOS

 

11.   A new policy for disaster recovery requires copying all critical network configurations and operating systems to a backup server that will be stored offsite. Which command will create a backup of the switch IOS image on the server?
            Switch# copy tftp NVRAM
            Switch# copy running-config tftp
            ***Switch# copy flash tftp
            Switch# copy IOS tftp
            Switch# copy tftp flash

            Switch# copy NVRAM tftp

 

12.   What must be done in order to initiate the password recovery procedure on a Catalyst 2900 series switch?
            Rename the Flash file.
            Enter the setup program by deleting the switch configuration file and rebooting the switch.
            ***Hold down the MODE button during switch startup.
            Wait for the STAT LED to turn green while holding down the Break key.

            Hold down the Ctrl-Break keys during switch startup.

 

13.   What is the name of the series of tests that execute every time a switch is powered on?
            RPS
            bootstrap
            ***power-on self test
            system STAT

            pre-boot

 

14.    What color is the System LED if the switch fails the POST?
            ***amber
            green
            red
            white

            off

 

15.   Which methods can be used to perform the initial configuration of a new switch? (Choose two.)
            copy a configuration from a FTP server
            ***type commands manually after entering the Privileged EXEC mode
            ***enter the System Configuration dialog
            Telnet to a local server to copy a configuration file

            connect to the switch using a web browser

 

16.   An administrator is using the switch help facility to find the command elements available to the configure command. What would the user type at the command prompt to display the next set of arguments available in the syntax for this command?
            Switch# c?
            Switch# c ?
            Switch# configure?
            ***Switch# configure ?

 

17.    From which switch command mode can the configure command be used?
            config
            user EXEC
            ***privileged EXEC
            command EXEC

            flash

 

18.    Although the backup configuration file on a Catalyst 2950 switch has been erased, it is found that VLANs are still configured in the switch. What must be done to clear the configured VLANs?
            ***The vlan.dat file must be erased and the switch reloaded.
            The switch flash memory must be purged and the switch rebooted.
            The vlan.cfg file must be renamed and IOS restarted.
            Each VLAN needs to be deleted individually and the configuration saved.

            The switch needs to be restarted, because the old running configuration is still in memory.

 

19.    How long will a host MAC address remain in the address table of a switch after the host has been turned off or moved to another device?
            30 seconds
            180 seconds
            ***300 seconds

            30 minutes

 

20.    When the copy tftp flash command is used to upgrade the IOS on a switch, which symbol indicates that the image was copied successfully?
            e
            *
            ***!
            s

            #

 

almoghai.blog.com

 

 

Posted by almo in 12:22:45 | Permalink | Comments Off

Modul Access

BAB I

 

Microsoft Access merupakan salah satu program pengolah database yang canggih yang digunakan untuk mengolah berbagai jenis data dengan pengoperasian yang mudah.
Banyak kemudahan yang akan diperoleh jika bekerja dengan microsoft Access diantara dapat melakukan proses penyortiran pengaturan data, pembuatan label data serta laporan pembuatan data kegiatan sehari-hari misalnya untuk menampung daftar pelanggan, pendataan data karyawan, dan lain sebagainya.
Sebelum memulai sebaiknya Anda persiapkan perhatian Anda dengan menarik napas dalam-dalam agar bangkit semangat Anda, mungkin pada saat ini Anda memilki anggapan bahwa Microsoft Access merupakan hal yang sulit dikerjakan tetapi perkembangan komputer sedemikian rupa dan tidak sesulit bayangan Anda itu, bahkan Anda mungkin menemukan kemudahan-kemudahan sehingga Anda dapat melewati modul ini dengan cepat untuk melanjutkan kepokok bahasan berikutnya.

 

A.    Memulai Microsoft Acces
Sebelum memulai microsoft Access, terlebih dahulu kita harus mengenal apa itu database dan apa saja komponen yang ada di dalamnya.
Pengertian Tabel, Field dan record
Seperti kita ketahui bahwa database merupakan kumpulan dari beberapa tabel yang terintegrasi menjadi satu kesatuan yang saling berhubungan.
Tabel merupakan kumpulan dari beberapa record dan fields. Sebagai ilustrasinya adalah sebagai berikut :

Fields

records

 

 

 

 


Nim
Nama
Alamat
Nilai UTS
Nilai UAS
01
Wati
Malang
90
90
02
Wahyu
Surabaya
80
70
03
Intan
Jakarta
70
80
04
Nusa
Balikpapan
50
80
05
Rudi
Riau
80
70

Jadi yang dimaksud dengan fields adalah atribut yang dimiliki oleh suatu tabel. Sedangkan record adalah isian data yang dimiliki oleh tabel.
Untuk memulai microsoft Access pada dasarnya hampir sama antara Taskbar Windows 95 – 2000 yaitu dimulai dengan tombol Start -> Program -> Program MS-Access.

 

B.    Lembar Kerja Microsoft Acces
Pada saat Anda pertama kali menjalankan microsoft Access maka akan tampil kotak dialog dimana memungkinkan Anda dapat membuat data base baru dengan dua cara :
1.      Blank Access Database

2.      Access database Wizards.


 

 

 

 

 

 

 

 

 

 

 

 

Jika Anda tidak menginginkan tampilan Kotak Dialog pada saat pertama kali dijalankan program MS Access Anda dapat memilih perintah option pada menu tools  dan matikan Check  Box, Starup Dialog, pada tab Sheet View.

 

 

 

 

 

Berikut ini adalah pilihan yang ada pada kotak dialog MS Access

Pilihan
Keterangan
Blank Database
Digunakan untuk membuat data base baru yg masih kosong dan Anda dapat menambahkan Obyek tabel, query, Form, Report, dan Obyek lainnya
Blank Data Access Page
Dipakai untuk membuat database baru yang diberikan oleh MS Access  secara bertahap
Project Existing Data
Dipakai untuk membuat data base baru berdasarkan tuntunan yang diberikan oleh microsoft access
Open end existing file
Dipakai untuk membuka file database yang telah dibuat sebelumnya

 

Tampilan jendela Ms. Acces

 

 

 

 

 

 

 

 

 

 

C.    Membuka File Database

Membuka file database MS Access berarti membuka file yang pernah dibuat dan disimpan. Selain membuka jendela database yang pernah dibuat Anda bisa membuka jendela database baru yang masih kosong dengan cara Klik menu file, pilih New atau pada Toolbars klik tombol new. Apabila Anda membuka jendela database baru maka  jendela database yang terbuka sebelumnya akan ditutup karena pada MS Access tidak dapat membuka lebih dari satu file database.

Untuk membuka file database dapat menggunakan salah satu cara berikut :

  1. Pilih File -> Open dari Menu Bar
  2. Klik tombol Open yang ada pada bagian toolbars pada database
  3. Tekan tombol Shorcut Key , Ctrl + O

D.    Menutup File Database

Bila Anda telah selesai bekerja dengan file database MS Access maka sebelum menutup file, simpan seluruh data yang pernah Anda buka. Untuk menutup file database, Anda dapat menggunakan salah satu llangkah berikut ;

1.      Klik File ->Close pada Menu Bar

2.      Tekan tombol kombinasi shorcut Key  Ctrl + F4 atau Ctrl + W

3.      Klik icon Close pada Menu Bar dibagian sudut kanan atas dari jendela database

 

E.     Menutup Program Microsoft Acces

Menutup program MS Access berarti keluar dari program MS Access. Untuk keluar dari program MS Access dapat dilakukan dengan salah satu cara berikut ini :

a.       Klik File ->Exit pada menu Bar

b.      Tekan tombol kombinasi shorcut Key  Alt + F4

c.       Klik icon Close pada Title Bar dibagian sudut kanan atas dari jendela database.

 

 

 


BAB II

 

Proyek Membuat Program Penerimaan Siswa Baru
1.      Buka aplikasi Microsoft Access
2.      Klik File New
3.      Pilih Blank Database

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4.      Create nama file database

 

Ketik Nama File

Klik disini

 

 

 

 

 

 

 

 

 

 

 

 

 

 



Setelah anda mengisi nama database, anda bisa langsung mengklik tombol create atau menekan tombol enter.
A.    Membuat Tabel
Untuk membuat tabel ada 3 cara yaitu:
1.      Create table in design view
2.      Create table by using wizard
3.      Create table bya entering data
Pada saat ini kita akan membuat tabel dengan cara yang pertama yaitu Create table in Design View. Langkah-langkahnya sebagai berikut :

 

 

  1. Tampilan awal create table in design view


 

 

 

 

 

 

 

 

 

 

 

 

  1. Klik 2 x create table in design view sehingga terbuka jendela seperti dibawah ini :


 

 

 

 

 

 

 

KETERANGAN :
a.       Field Name
Fungsinya untuk memasukkan nama-nama field dari suatu tabel.
b.     Data Type
Barbagai macam tipe data yang ada di Access sebagai berikut:
b.1.      Text
Merupakan tipe data yang sering digunakan ( Alfabetic dan Numeric). Panjang maksimumnya 255.
b.2.      Number
Hanya digunakan untuk menyimpan data numerik.
b.3.      Date/Time
Digunakan untuk menyimpan nilai tanggal dan jam. Panjang maksimumnya 8 karakter.
b.4.      Memo
Mampu menampung nilai sampai 65535 karakter.
b.5.      Currency
Sering digunakan untuk nilai mata uang.
b.6.      AutoNumber
Berisi angka urut yang sudak ditetapkan oleh Access yang muncul secara otomatis dan nilainya tidak dapat diubah.
b.7.      Yes/No
Berisi dua nilai saja yaitu Yes/No atau True/false dan On/Off.
b.8.      OLE Object
Digunakan untuk eksternal objek. Misalnya gambar,suara, dan sebagainya.
b.9.      Hyperlink
Gabungan dari Text dan Numerik yang disimpan dalam bentuk Text. Digunakan untuk manyimpan pointer ke situs web.
b.10.  Lookup Wizard
Untuk memilih sebuah nilai dari tabel lain atau List Box atau Combo Box.
c.      Description
Sebagai keterangan yang akan mempermudah dalam memahami field name

  1. Masukkan nama-nama field

     5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. Tentukan primary key
  2. Setelah itu close pada pojok kanan atas
  3. Klik yes, lalu beri nama tabel (contoh:daftar) kemudian klik OK

 

 

 

 

 

  1. Hasil dari pembuatan tabel tersebut di atas akan tampak seperti gambar di bawah :


 

 

 

 

 

 

 

B.    Menentukan Primary Key
Untuk menentukan dan mengubah primary key pada suatu field, ikuti langkah berikut ini:
1.     Pilih dan klik tabel yang anda inginkan ubah primary key-nya.
2.     Klik tombol toolbar Design.
3.     Pilih dan Klik nama field yang ingin dijadikan primary key
4.     Pilih dan klik menu Edit, Primary Key atau klik tombol toolbar Primary Key.

 

C.    Menambah Field
1.     Buka file   à  Pilih Table Daftar
2.     Pilih Design View
3.     Sisipkan field baru (Contoh Nama_ortu) caranya sama dengan membuat field pertama kali.

 

 

 

 

 

 

 

 

4.     Klik Field Ket → klik menu Insert → rows
5.     Masukkan nama field baru (contoh : Asal_Skl)

 

 

 

 

 

 

 

 

6.     Kemudian Klik Close dan Save OK
D.    Menghapus Record

Anda dapat menghapus satu atau lebih Record dalam tabel pada tampilan data Sheet view. Prosedur yang dapat Anda lakukan adalah sebagai berikut :

1.       Di dalam jendela data Sheet pilih Record yang ingin Anda hapus dan berikan salah satu perintah berikut :

a.       Pilih perintah Delete dari menu Edit

Tekan tombol Delete Record pada bagian Toolbar atau,

b.      Tekan Tombol Del yang ada di Keyboard atau,

c.       Klik Kanan Record yang ingin Anda hapus dari daftar pilihan menu yang tampil plih perintah delete Record.

 

 

 

2.       Setelah Anda melakukan salah satu perintah di atas maka akan tampil kotak Konfirmasi pilih Yes apabila Anda benar-benar ingin menghapus Record dan tombol No apabila ingin membatalkan proses penghapusan.

 


BAB III

 

Sebelum memulai kegiatan ini, sebaiknya kita tahu terlebih dulu maksud dari query. Query bisa diartikan sebagai pernyataan atau permintaan untuk memproses table yang ada.
Cara membuat query ada 2 yaitu:
1.      Create quey in design view
2.      Create query by using wizard.
Pada saat ini kita akan membahas untuk membuat query dengan cara yang pertama yaitu Create query in design view.
Langkah-langkahnya sebagai berikut:
1.      Klik Queries pada bagian objects

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2.      Klik 2 x Create query in Design view sama seperti membuat table.
Akan tampil daftar queries sebagai berikut :

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3.      Pilih nama table dalam daftar Show Table kemudian klik Add.
Tampilan daftar query1 sebagai berikut :

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4.      Klik 2 x nama field yang ada pada tabel daftar sehingga nama-nama field tersebut tersimpan dalam daftar queries seperti pada gambar diatas.
5.      Pada kolom Jml_nilai masukan rumus pembobotan setiap mata pelajaran. Pembobotan dibuat sesuai aturan yang ada. Contoh PPKn, Bah_ind, IPS dikalikan 1, IPA, Matemt dikalikan 4 dan Bah_ing dikalikan 3.
Rumus Jml_nilai :
([PPKn]+[Bah_ind]+[Matemt]+[Bah_ing]+[IPA]+[IPS]).
Dapat dilihat pada gambar dibawah.

 

 

 

 

 

 

6.      Buat Rumus untuk Nilai x bobot.
Rumus Jml_x_bbt :
(([PPKn]+[Bah_ind]+[IPS])+([Matemt]*4)+([IPA]*4)+([Bah_ing]*3)).
Dapat dilihat pada gambar dibawah.

 

 

 

 

 

 

7.      Kemudian klik tombol close pada sudut kanan atas,

 

 

 

 

 

 


BAB IV

 

A.    Membuat Form
Untuk menghasilkan tampilan yang lebih komunikatif, maka dibutuhkan suatu interface yang dapat membantu pengguna atau operator dalam menjalankan suatu program aplikasi. Salah satu interface yang disediakan oleh microsoft Access adalah Form.
Cara membuat form ada 2 yaitu:

  1. Create form in design view
  2. Create form by using wizard

Pada saat ini kita akan mempelajari cara membuat form dengan Create form by using wizard. Langkah-langkahnya:
1.     Klik Form pada Objects

 

 

 

 

 

 

 

2.     Klik 2 x Create form by using wizard akan tampil  form wizard

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3.     Pada Tables/Queries pilih Table : daftar kemudian Pindahkan semua field Available field ke Selected Fields dengan menekan tombol

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


4.     Kemudian klik
Akan tampil  jendela seperti tampak di bawah ini :

 

 

 

 

 

 

 

 

 

 

 

 

 

 




Kemudian klik

 

 

 

 

 

 

 

 

Pada tampilan berikut Anda dapat memilih diantara beberapa alternatif untuk dipakai sebagai bentuk tampilan form. Misalnya Anda memilih stone

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


5.     Kemudian klik

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



6.     Berikan nama form yang akan kita buat (contoh : daftar)
7.     Kemudian Klik Finish

 

 

 

 

 

 


B.    Mengatur Form
Dalam pembuatan form mungkin ada yang kurang sesuai, untuk melakukan perubahan kita bisa melakukan pengaturan pada form tersebut. Langkah-langkahnya:

 

1.     Buka Form daftar

 

 

 

 

 

 

 

 

 

 

 

 

 

 


2.     Buatlah Header Form dengan mengklik icon        desain View pada menu View, dan akan tampil :

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3.     Drag bar antar Form Header dan Detail sehingga terbentuk satu baris kosong

 

 

 

 

 

 

 

 

 

4.     Isikan Kata “PENERIMAAN SISWA BARU TAHUN 2004”

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



5.     Untuk mengisi Form Header klik
Kemudian klik daerah Form Header dan
Ketikkan kata-kata diatas
Untuk mengedit letak label klik 2 x labelà geser letak
            Label ke posisi yang anda inginkan
6.     Pada field Jml_nilai masukan rumus penjumlahan semua nilai dengan mengklik 2 x field Jml_nilai sebelah kanan
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7.     Edit Control Source dengan memasukan rumus klik akan muncul jendela Expression Builder

Klik disini

 

 

 

 

 

 

 

 

 



8.     Masukan rumus yang kita rencanakan

 

 

 

 

 

 

 

 

 

 

 

 

 

9.     Untuk menuliskan rumus cukup dengan mengklik 2 x nama field yang berada di form contohnya field PPKn simbol matematika yang kita gunakan tinggal klik yg ada pada bagian bawah ruang rumus.
10. Setelah selesai klik OK kemudian klik close pada pojok kanan atas Text Box
11. Buat Rumus jumlah nilai kali bobot setiap mata pelajaran dengan mengkilk 2 x field Jml_x_bbt

 

 

 

 

 

 

 

 

 

 

 

 

12. Langkahnya sama dengan cara memasukan rumus pada Jml_nilai
13. Masukan rumus pada jendela Expression Builder

 

 

 

 

 

 

 

 

 

14. Setelah selesai klik OK kemudian klik close pada pojok kanan atas Text Box
15. Setelah semua rumus selesai klik datasheet view             
16. Sekarang kita dapat memasukan data yang ada

 

 


MEMPERSIAPKAN APLIKASI DATA MASUKAN
C.    Input Data Record

Setelah mengikuti ketentuan dalam membuat table, langkah selanjutnya adalah memasukan data Record,  yang dilakukan dengan melalui jendela Data Sheet View dari sebuah table. Selain itu dapat juga dilakukan proses Editting data yaitu proses penambahan data record, memindah data Record, menyalin Data Record ataupun menghapus data record.

Prosedur yang dilakukan untuk menginput data adalah sebagai berikut :

1.      Pada jendela data base pilih salah satu nama tabel yang datanya ingin anda masukan.

2.      Buka jendela Data Sheet dari tabel tersebut dengan langkah :
a.   Tekan Tombol icon Open pada area kerja kemudian Tekan tombol  enter
b.   Klik Ganda pada nama tabel
c.   Klik kanan pada nama tabel dan pilih perintah open dari menu yang tampil.
3.      Setelah Anda jalankan salah satu perintah tersebut di atas maka akan tampil jendela data Sheet dari tabel yang masih kosong
4.      Anda dapat lansung memasukan data Record   sesuai dengan tatanan yang telah Anda buat pada jendela desain View.

 

 

 

 

 

 

 

 

 

 

 



Tidak perlu diisi                      Field Rumus tidak perlu diisi         Field yang dapat dientry
Setelah selesai entry maka kita dapat melihat data pada queries seperti diatas.

 

 

 

 

 

 

 

 

 

 

D.    Mengecek Hasil Entry Data
Setelah data dimasukkan, dilakukan pemeriksaan proses pemindahan dan pemasukan data apakah sesuai dengan prosedur atau intruksi kerja.
Memilah hasil pemindahan dan pemasukan data sesuai dengan prosedur dan intruksi kerja.
Mengidentifikasi keberhasilan pemindahan dan pemasukan data ke dalam program data base dari file data ke media penyimpan data.

 

E.     Mengisi Check List Entry Data

Mengidentifikasi langkah-langkah operasional dan keberhasilan proses pemindahan dan pemasukan data

Mengatur Design Repot dalam sebuah lembar kerja Preview.

Mengubah teks-teks yang terdapat didalam lembar kerta design tersebut agar menjadi diskriptif dan memindahkan label sehingga dapat tampil sejajar dengan Ctrl – Ctrl yang lain.

Menambahkan bebarapa informasi lain dibagian Footer.

 


MENG-UPDATE DATA
F.     Menentukan Tabel Baru
Satu-satunya hal yang konstan adalah perubahan. Bersama waktu, kebutuhan dan minat Anda berubah seiring Anda bertumbuh dan berkembang. Sebuah informasi yang dulu sangat penting bisa saja sekarang berubah menjadi tidak diperlukan atau malah mengganggu, sementara informasi yang semula dianggap tidak berguna sama sekali bisa berubah menjadi informasi penting. Seiring meningkatnya jumlah informasi dalam bidang bisnis dan kehidupan sehari-hari, Anda mungkin perlu menata atau mendistribusi ulang informasi tersebut. Anda perlu tahu bahwa mungkin Anda harus membeli rak baru, folder file baru, atau bahkan satu set kabinet file baru untuk menampung bidang yang anda minati. Hal yang sama terjadi pada database Anda.

 

G.    Memilih Field dan Record
Anda harus memiliki data sebelum melakukan editing pada sebuah jendela data sheet. Untuk memilih data atau record pada sebuah jendela data sheet dapat dilakukan dengan beberapa cara, untuk lebih jelasnya lihat pada daftar dibawah ini  :

 

Pilihan
Perintah
Sebuah  sel
Klik pada posisi sel tersebut
Beberapa sel
Drag drop pointer pada sisi kiri sel terbut sampai melintasi beberapa sel yang ingin Anda pilih
Sebuah Kolom
Klik pada pisisi selektor Kolom
Beberapa Kolom
Drag drop Pointer pada posisi selektor Kolom
Sebuah record
Klik pada pisisi selektor baris
Beberapa record
Drag drop Pointer  pada posisi celektor baris
Semua Record
·   Klik tombol select all pada selector baris
·   Pilih perintah select All Record dari menu Edit
·   Tekan kombinasi tombol Ctrl + A

 

H.    Memindahkan Insertion Point
Untuk memindahkan Insertion Point atau data Record dalam sebuah data sheet dapat menggunakan pasilitas yang ada diperintah Go To dari menu Edit, Panah atas, panah bawah, Page Up, Page Down atau menggunakan Vertikal scroll Bar. Selain itu Anda dapat juga memindahkan posisi Record Aktif dengan memilih tombol navigasi yang ada pada bagian bawah dari jendela data Sheet sebuah tabel. Perhatikan tabel berikut :

 

Pindah Ke
Perintah Klik
Awal record
 First Record
Akhir record
 Last record
Record Sebelumnya
 Previus Record
Record berukutnya
 Next Record
Record Baru
New Record
Record tertentu
 Atau tekan tombol F5 atau ketik nomer Record yang Anda inginkan dan lanjutkan dengan menekan tombol enter.

 

1.     Menambahkan Record
a.      Jika kita memiliki data baru dalam arti pendaftar baru maka kita dapat meng-update database kita dengan menambahkan data tersebut dapat melalui queries maupun melalui form.
b.      Update melalui gueris, buka file kemudian buka queries lalu masukan data baru

 

 

 

 

 

 

 

 

 

 

 

c.      Update melalui Form caranya sama dengan saat entry pertama kali.

 

 

 


BAB V
RINGKASAN MATERI

 

A.    Memulai Microsoft Access

Untuk memulai microsoft Access pada dasarnya hampir sama antara Task bar Windows 95 – 2000 yaitu dimulai dengan tombol Start – Program – Pilih – Program MS-Access .

 

B.    Lembar Kerja MS Access

Pada saat Anda pertama kali menjalankan microsoft Access maka akan tampil kotak dialog dimana memungkinkan Anda dapat membuat data base baru dengan dua cara :

1)      Blank Access Database

2)      Access database Wizards.

 

C.    Membuka File Database

Membuka file database MS Access berarti membuka file yang pernah dibuat dan disimpan. Selain membuka jendela database yang pernah dibuat, Anda bisa membuka jendela database baru yang masih kosong caranya dengan memberi perintah Klik menu file pilih New atau pada Toolbars klik tombol news  seperti berikut 

 

D.    Menutup File Database

Bila Anda telah selesai bekerja dengan file database MS Access maka sebelum menutup file simpan seluruh data yang pernah Anda buat, dengan memilih salah satu cara berikut :

1)      Klik Exit pada menu File

2)      Tekan tombol kombinasi shorcut Key  Alt + F4

3)      Klik icon Close pada Title Bar dibagian sudut kanan atas dari jendela database.

 

E.     Menutup Program MS Access

Menutup program MS Access berarti keluar dari program MS Access. Untuk keluar dari program tersebut langkahnya sebagai berikut :

Klik menu File pilih Exit

 

F.     Aplikasi Microsoft Access
Membuat Tabel

 

 

G.    Mempersiapkan Aplikasi dan Data Masukan.

Setelah mengikuti ketentuan dalam membuat table, langkah selanjutnya adalah memasukan data Record,  yang dilakukan dengan melalui jendela Data Sheet View dari sebuah table. Selain itu dapat juga dilakukan proses Editting data yaitu proses penambahan data record, memindah data Record, menyalin Data Record ataupun menghapus data record.

 

H.    Mengecek Hasil Entry Data
Setelah data dimasukkan, melakukan pemeriksaan proses pemindahan dan pemasukan data apakah sesuai dengan prosedur atau intruksi kerja

 

I.       Mengisi Check List Entry data
Mengidentifikasi langkah-langkah operasional dan keberhasilan proses pemindahan dan pemasukan data

 

Posted by almo in 11:45:24 | Permalink | Comments (2)

Friday, December 7, 2007

Contekan Test CCNA 3 Modul 5

English FormB CCNA3 Version3.1 Module5 – 2007 fall

 

1.   Which of the following are requirements of LAN design? (Choose three.)
            ***adaptability
            ***manageability
            operability
            ***scalability

            stability

2.   When designing a LAN, at which layer of the OSI model does the process of segmenting collision domains occur?
            Layer 1
            ***Layer 2
            Layer 4

            Layer 7

3.   Which of the following affect network availability? (Choose three.)
            ***throughput
            ***response time
            workstation speed
            ***access to resources

            desktop applications

4.   What type of cabling is specified by TIA/EIA standards for interconnection of Intermediate and Main Distribution Facilities?
            patch cables of variable lengths
            horizontal cross-connect cabling
            ***vertical cross-connect cabling

            parallel cross-connect cabling

5.   Which of the following are features of the access layer of the hierarchical network design model? (Choose two.)
            inter-VLAN routing
            ****Layer 2 filtering
            Layer 3 filtering
            ***microsegmentation

            bandwidth security

6.   A distribution layer switch operates at which OSI layers? (Choose two.)
            access
            ***data link
            ***network
            internet

            transport

7.   Which layer of the hierarchical network design model is often referred to as the backbone?
            access
            distribution
            network
            ***core
            workgroup

            WAN

8.   At which layer of the hierarchical design model do users connect to the network?
            application
            ***access
            distribution
            network

            core

9.   Which hierarchical design model layer is responsible for containing network problems to the workgroups in which they occur?
            application
            access
            ***distribution
            network

            core

10.   Which of the following are characteristics of the core layer of the hierarchical network design model? (Choose three.)
            ***redundant paths
            high-level policy enforcement
            packet manipulation
            media transitions
            ***rapid forwarding of traffic

            ***no packet filtering

11.   What is the primary reason for implementing security and policy routing at the distribution layer?
            filtering of core switching errors
            ***preventing policy and security issues from burdening the core layer
            preventing unnecessary security policy decisions from burdening the access layer
            maintaining a consistent three-layer security policy

            isolating the access layer from traffic destined for other networks

12.   A major network upgrade that was designed to improve speed and reliability has recently been completed. Users in one part of the network are experiencing dramatically decreased throughput and loss of connectivity. Which of the LAN design goals was not met for these users?
            ***functionality
            sustainability
            adaptability
            manageability

            scalability

13.   To reduce cost on a new network design, administrators select switches that initially will have 100 Mbps interface modules installed but will also have the ability to support 1000 Mbps interface modules. Which of the LAN design goals are being utilized? (Choose two.)
            sustainability
            reliability
            manageability
            ***adaptability
            functionality

            ***scalability

14.   What will increase the number of broadcast domains in a network? (Choose two.)
            replacing hubs with switches
            ***segmenting the network by installing a router
            ***creating VLANs for each workgroup
            adding additional hubs to the local area network
            replacing routers with LAN switches

            adding bridges to connect different workgroups

15.   Where should DNS and email servers be located?
            IDF
            ***MDF
            HCC
            VCC

            POP

16.   Which LAN standard uses CSMA/CD as its access method?
            FDDI
            ***Ethernet
            Wireless

            Token Ring

17.    VLAN1 and VLAN2 have been configured on a switch. What must be done for hosts on VLAN1 to communicate with hosts on VLAN2?
            VLAN overlapping must be enabled on the switch.
            The MAC address must be added to the ARP table in the switch.
            ***A router must be configured to allow routing between the VLANs.
            An entry in the switching table must be configured for each VLAN.

            Communication between VLANs is automatically enabled on switches.

18.   A network administrator needs to increase bandwidth and reduce traffic on a network. What should be used in the access layer of the hierarchical network design model to dedicate bandwidth to users while limiting broadcast domains?
            one router with multiple fast Ethernet interfaces
            multiple routers with Fast Ethernet interfaces
            multi-port gigabit switches
            ***switches running VLANs

            managed smart hubs

19.   Which devices are considered acceptable for creating more connection points at the end of horizontal cable runs? (Choose two.)
            ***hubs
            bridges
            ***switches

            routers

20.   Why is it important that the data carrying capacity of vertical cabling be greater than that of the horizontal cable?
            Vertical cabling is reserved for high bandwith video conferencing.
            Vertical cabling carries traffic from the IDF to the user.
            Vertical cabling carries traffic from the enterprise out to the Internet.
            ***Vertical cabling carries traffic from multiple areas of the network.

            Layer-three packets move faster through vertical cabling.

Posted by almo in 12:28:53 | Permalink | Comments Off